SAP ABAP Table J_3RFGTD (Source Customs Declaration Contents)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_3RFGTD	Table Relationship Diagram
Short Description	Source Customs Declaration Contents

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☑				0	0	Source Customs Declaration Key
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	.INCLUDE	☑				0	0	Customs Declaration full Number
5	CUSTOMS	☑	J_3RF_GTDCUST	BEHOE	CHAR	10	0	Customs Office Code	*
6	GTDDATE	☑	J_3RF_GTDDAT	J_3RF_GTDDAT	DATS	8	0	Customs Declaration Date
7	GTDNUMBER	☑	J_3RF_GTDNUM	J_3RF_GTDNUM	CHAR	10	0	Customs Declaration Number
8	GTDTYPE	☑	J_3RF_GTDTYPE	J_3RF_GTDTYPE	CHAR	1	0	Origin of Customs Declaration
9	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
10	POSNR	☑	J_3RF_GTDPOSNR	NUM05	NUMC	5	0	Technical Line ID in Customs Declaration Database
11	.INCLUDE	☐				0	0	Source Customs Declaration Contents
12	GTDPOS	☐	J_3RF_GTDITEM	J_3RF_GTDPOSNR	NUMC	3	0	Customs Declaration Document Line Item Number
13	ISSUEDAT	☐	J_3RF_GTDISSUED	DATE	DATS	8	0	Issue Date of Goods in Customs Declaration
14	ORDERNUM	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
15	ORDERPOS	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
16	INDELNUM	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	LIKP
17	INDELPOS	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	LIPS
18	MMDOCNUM	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document	MKPF
19	MMDOCJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document	MKPF
20	MMDOCPOS	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document	MSEG
21	BILLREF	☐	J_3RF_BILLREF	VBELN	CHAR	10	0	Billing Document Reference	VBRK
22	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
24	MENGE	☐	J_3RF_GTDMENGE	MENG13	QUAN	13	3	Material Quantity in Base Unit of Measure
25	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
26	GTDTSTAMP	☐	J_3RF_GTDTSCRE	TIMESTAMP	CHAR	14	0	Time Stamp of GTD creation
27	CREUSER	☐	J_3RF_GTDUSERCRE	UNAME	CHAR	12	0	Entry Created By
28	CHGTSTAMP	☐	J_3RF_GTDTSCHG	TIMESTAMP	CHAR	14	0	Time Stamp of Change
29	CHGUSER	☐	J_3RF_GTDUSERCHG	UNAME	CHAR	12	0	Entry Last Changed By

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3RFGTD	BILLREF	VBRK	VBELN	KEY	1	CN
2	J_3RFGTD	BUKRS	T001	BUKRS	KEY	1	CN
3	J_3RFGTD	HERKL	T005	LAND1	KEY	1	CN
4	J_3RFGTD	INDELNUM	LIKP	VBELN	KEY	1	CN
5	J_3RFGTD	INDELPOS	LIPS	POSNR	KEY	1	CN
6	J_3RFGTD	LIFNR	LFA1	LIFNR	KEY	1	CN
7	J_3RFGTD	MATNR	MARA	MATNR	KEY	1	CN
8	J_3RFGTD	MEINS	T006	MSEHI	KEY	1	CN
9	J_3RFGTD	MMDOCJAHR	MKPF	MJAHR	KEY	1	CN
10	J_3RFGTD	MMDOCNUM	MKPF	MBLNR	KEY	1	CN
11	J_3RFGTD	MMDOCPOS	MSEG	ZEILE	KEY	1	CN
12	J_3RFGTD	ORDERNUM	EKKO	EBELN	KEY	1	CN
13	J_3RFGTD	ORDERPOS	EKPO	EBELP	KEY	1	CN

History

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