J_3RFGTDMAT

GTD usage in material documents | #transactional | Component: Financials Russia
Column Name Description
MANDT FK Client
BUKRS FK Company Code
CUSTOMS FK Customs Office Code
GTDDATE FK Customs Declaration Date
GTDNUMBER FK Customs Declaration Number
GTDTYPE FK Origin of Customs Declaration Show values
LIFNR FK Account Number of Supplier
POSNR FK Technical Line ID in Customs Declaration Database
MBLNR FK Number of Material Document
MJAHR FK Material Document Year
ZEILE FK Item in Material Document
Column Name Description
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
📏 Base Unit of Measure (BOM_MEINS):
BOM_MENGE Quantity
Column Name Description
GTDDATE FK Customs Declaration Date
BUDAT Posting Date in the Document
Column Name Description
Column Name Description Domain name
MBLNRREF Number of Original Material Document Referenced BELNR
MJAHRREF Original Material Document Year GJAHR
ZEILEREF Item of Original Material Document Referenced MBLPO
HERKL Country/Region of Origin of Material (Non-Preferential Ori.) LAND1
REFTSTAMP Time Stamp of Reference creation TIMESTAMP
CREUSER Entry Created By UNAME
BOM_NUMBER Bill of Material STNUM
BOM_MATNR BOM component MATNR
Master Data Relations Join Conditions
Company Code
  • J_3RFGTDMAT.MANDT == T001.MANDT
  • J_3RFGTDMAT.BUKRS == T001.BUKRS
Account Number of Supplier
  • J_3RFGTDMAT.MANDT == LFA1.MANDT
  • J_3RFGTDMAT.LIFNR == LFA1.LIFNR
Material Number
  • Material Number
  • Client
  • J_3RFGTDMAT.MATNR == MARA.MATNR
  • J_3RFGTDMAT.MANDT == MARA.MANDT
Base Unit of Measure
  • J_3RFGTDMAT.MANDT == T006.MANDT
  • J_3RFGTDMAT.MEINS == T006.MSEHI