SAP ABAP Table J_3RFGTDINV (GTD usage in billing 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_3RFGTDINV	Table Relationship Diagram
Short Description	GTD usage in billing 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	INVOICENUM	☑	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
12	INVOICEPOS	☑	POSNR_VF	POSNR	NUMC	6	0	Billing item	VBUP
13	INVNUMREF	☑	J_3RF_GTDINVREF	VBELN	CHAR	10	0	Number of Original Billing Document Referenced	*
14	INVPOSREF	☑	J_3RF_GTDPOSREF	POSNR	NUMC	6	0	Item of Original Billing Document Referenced	*
15	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
16	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
18	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
19	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
20	REFTSTAMP	☐	J_3RF_GTDREFTST	TIMESTAMP	CHAR	14	0	Time Stamp of Reference creation
21	CREUSER	☐	J_3RF_GTDUSERCRE	UNAME	CHAR	12	0	Entry Created By

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3RFGTDINV	BUKRS	T001	BUKRS	KEY	1	CN
2	J_3RFGTDINV	CUSTOMS	J_3RFGTD	BUKRS	KEY	1	CN
3	J_3RFGTDINV	GTDNUMBER	J_3RFGTD	CUSTOMS	KEY	1	CN
4	J_3RFGTDINV	GTDTYPE	J_3RFGTD	GTDDATE	KEY	1	CN
5	J_3RFGTDINV	INVOICENUM	VBUK	VBELN	KEY	1	CN
6	J_3RFGTDINV	INVOICEPOS	VBUP	POSNR	KEY	1	CN
7	J_3RFGTDINV	LIFNR	LFA1	LIFNR	KEY	1	CN
8	J_3RFGTDINV	MATNR	MARA	MATNR	REF	C	CN
9	J_3RFGTDINV	MEINS	T006	MSEHI	REF	C	CN
10	J_3RFGTDINV	POSNR	J_3RFGTD	GTDTYPE	KEY	1	CN

History

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