SAP ABAP Table J_3RFGTDMAT (GTD usage in material documents)

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_3RFGTDMAT	Table Relationship Diagram
Short Description	GTD usage in material documents

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	J_3RFGTD
6	GTDDATE	☑	J_3RF_GTDDAT	J_3RF_GTDDAT	DATS	8	0	Customs Declaration Date	J_3RFGTD
7	GTDNUMBER	☑	J_3RF_GTDNUM	J_3RF_GTDNUM	CHAR	10	0	Customs Declaration Number	J_3RFGTD
8	GTDTYPE	☑	J_3RF_GTDTYPE	J_3RF_GTDTYPE	CHAR	1	0	Origin of Customs Declaration	J_3RFGTD
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	J_3RFGTD
11	MBLNR	☑	MBLNR	BELNR	CHAR	10	0	Number of Material Document	MKPF
12	MJAHR	☑	MJAHR	GJAHR	NUMC	4	0	Year of material document	MKPF
13	ZEILE	☑	MBLPO	MBLPO	NUMC	4	0	Item in material document	MSEG
14	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
15	MBLNRREF	☐	J_3RF_GTDMDOCREF	BELNR	CHAR	10	0	Number of Original Material Document Referenced
16	MJAHRREF	☐	J_3RF_GTDMJAHRREF	GJAHR	NUMC	4	0	Original Material Document Year
17	ZEILEREF	☐	J_3RF_GTDMPOSREF	MBLPO	NUMC	4	0	Item of Original Material Document Referenced
18	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
19	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
20	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
22	REFTSTAMP	☐	J_3RF_GTDREFTST	TIMESTAMP	CHAR	14	0	Time Stamp of Reference creation
23	CREUSER	☐	J_3RF_GTDUSERCRE	UNAME	CHAR	12	0	Entry Created By
24	BOM_NUMBER	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
25	BOM_MATNR	☐	IDNRK	MATNR	CHAR	18	0	BOM Component	*
26	BOM_MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
27	BOM_MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3RFGTDMAT	BUKRS	T001	BUKRS	KEY	1	CN
2	J_3RFGTDMAT	CUSTOMS	J_3RFGTD	BUKRS	KEY	1	CN
3	J_3RFGTDMAT	GTDNUMBER	J_3RFGTD	CUSTOMS	KEY	1	CN
4	J_3RFGTDMAT	GTDTYPE	J_3RFGTD	GTDDATE	KEY	1	CN
5	J_3RFGTDMAT	LIFNR	LFA1	LIFNR	KEY	1	CN
6	J_3RFGTDMAT	MATNR	MARA	MATNR	REF	C	CN
7	J_3RFGTDMAT	MBLNR	MKPF	MBLNR	KEY	1	CN
8	J_3RFGTDMAT	MEINS	T006	MSEHI	REF	C	CN
9	J_3RFGTDMAT	MJAHR	MKPF	MJAHR	KEY	1	CN
10	J_3RFGTDMAT	POSNR	J_3RFGTD	GTDTYPE	KEY	1	CN
11	J_3RFGTDMAT	ZEILE	MSEG	ZEILE	KEY	1	CN

History

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