SAP ABAP Table J_3RFGTD_REP (Customs Declaration Usage (needed for J_3RFGTDUSAGE report))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J3RF (Package) Localization Russia: FI

Basic Data

Table Category	INTTAB	Structure
Structure	J_3RFGTD_REP	Table Relationship Diagram
Short Description	Customs Declaration Usage (needed for J_3RFGTDUSAGE report)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	BUKRS_NAME	☐	J_3RF_GTD_CC_NAME	CHAR140	CHAR	140	0	Company Name
2	.INCLUDE	☐				0	0	Source Customs Declaration Key
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	.INCLUDE	☐				0	0	Customs Declaration full Number
6	CUSTOMS	☐	J_3RF_GTDCUST	BEHOE	CHAR	10	0	Customs Office Code	*
7	GTDDATE	☐	J_3RF_GTDDAT	J_3RF_GTDDAT	DATS	8	0	Customs Declaration Date	*
8	GTDNUMBER	☐	J_3RF_GTDNUM	J_3RF_GTDNUM	CHAR	10	0	Customs Declaration Number	*
9	GTDTYPE	☐	J_3RF_GTDTYPE	J_3RF_GTDTYPE	CHAR	1	0	Origin of Customs Declaration
10	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
11	POSNR	☐	J_3RF_GTDPOSNR	NUM05	NUMC	5	0	Technical Line ID in Customs Declaration Database
12	LIFNR_NAME	☐	J_3RF_GTD_LIFNR_NAME	CHAR140	CHAR	140	0	Vendor Name
13	GTDPOS	☐	J_3RF_GTDITEM	J_3RF_GTDPOSNR	NUMC	3	0	Customs Declaration Document Line Item Number
14	ISSUEDAT	☐	J_3RF_GTDISSUED	DATE	DATS	8	0	Issue Date of Goods in Customs Declaration
15	ORDERNUM	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
16	ORDERPOS	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
17	BILLREF	☐	J_3RF_BILLREF	VBELN	CHAR	10	0	Billing Document Reference	*
18	MMDOCNUM	☐	J_3RF_GTD_MMDOCNUM	BELNR	CHAR	10	0	Material Document Reference
19	MMDOCJAHR	☐	J_3RF_GTD_MMDOCJAHR	GJAHR	NUMC	4	0	Year of Material Document Reference
20	MMDOCPOS	☐	J_3RF_GTD_MMDOCPOS	MBLPO	NUMC	4	0	Item of Material Document Reference
21	INDELNUM	☐	J_3RF_GTD_DELNUM	VBELN	CHAR	10	0	Inbound Delivery Reference	*
22	INDELPOS	☐	J_3RF_GTD_DELPOS	POSNR	NUMC	6	0	Inbound Delivery Item Reference	*
23	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
24	MATTEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
25	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
26	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
27	MENGE	☐	J_3RFGTD_QNT	MENG13	QUAN	13	3	Material Quantity in Base Unit of Measure
28	OPENMENGE	☐	J_3RFGTD_OPENQNT	MENG13	QUAN	13	3	Available Material Quantity in the Customs Declaration Item
29	INVOICENUM	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
30	INVOICEPOS	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item	*
31	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
32	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
33	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
34	INVNUMREF	☐	J_3RF_GTDINVREF	VBELN	CHAR	10	0	Number of Original Billing Document Referenced	*
35	INVPOSREF	☐	J_3RF_GTDPOSREF	POSNR	NUMC	6	0	Item of Original Billing Document Referenced	*
36	KUNNR	☐	J_3RF_GTD_INVKUNNR	KUNNR	CHAR	10	0	Invoice Sold-to Party	*
37	KUNNR_NAME	☐	J_3RF_GTD_INVKUNNR_NAME	CHAR140	CHAR	140	0	Invoice Sold-to Party Description
38	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
39	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
40	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
41	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
42	MBLNRREF	☐	J_3RF_GTDMDOCREF	BELNR	CHAR	10	0	Number of Original Material Document Referenced
43	MJAHRREF	☐	J_3RF_GTDMJAHRREF	GJAHR	NUMC	4	0	Original Material Document Year
44	ZEILEREF	☐	J_3RF_GTDMPOSREF	MBLPO	NUMC	4	0	Item of Original Material Document Referenced
45	REFTSTAMP	☐	J_3RF_GTDREFTST	TIMESTAMP	CHAR	14	0	Time Stamp of Reference creation
46	GTDTSTAMP	☐	J_3RF_GTDTSCRE	TIMESTAMP	CHAR	14	0	Time Stamp of GTD creation
47	D_TYPE	☐	J_3RF_GTDREPLINE	J_3RF_GTDREPLINE	CHAR	1	0	Item Type in Customs Declaration Usage Report

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3RFGTD_REP	BUKRS	T001	BUKRS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	605