J_3RFGTD_REP SAP (Customs Declaration Usage (needed for J_3RFGTDUSAGE report)) Structure details
Description: Customs Declaration Usage (needed for J_3RFGTDUSAGE report)
Structure field list including key, data, relationships and ABAP select examples
J_3RFGTD_REP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Customs Declaration Usage (needed for J_3RFGTDUSAGE report)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_J_3RFGTD_REP TYPE J_3RFGTD_REP.
The J_3RFGTD_REP table consists of various fields, each holding specific information or linking keys about Customs Declaration Usage (needed for J_3RFGTDUSAGE report) data available in SAP. These include MANDT (Client), BUKRS (Company Code), CUSTOMS (Customs Office Code), GTDDATE (Customs Declaration Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP J_3RFGTD_REP structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
BUKRS_NAME | Company Name | J_3RF_GTD_CC_NAME | CHAR | 140 | CHAR140 | ||||
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
CUSTOMS | Customs Office Code | J_3RF_GTDCUST | CHAR | 10 | Assigned to domain | BEHOE | J_3RF_GTD_FULLNUMBER | ||
GTDDATE | Customs Declaration Date | J_3RF_GTDDAT | DATS | 8 | Assigned to domain | J_3RF_GTDDAT | |||
GTDNUMBER | Customs Declaration Number | J_3RF_GTDNUM | CHAR | 10 | Assigned to domain | J_3RF_GTDNUM | J_3RF_GTD_FULLNUMBER | ||
GTDTYPE | Origin of Customs Declaration | J_3RF_GTDTYPE | CHAR | 1 | J_3RF_GTDTYPE | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
POSNR | Technical Line ID in Customs Declaration Database | J_3RF_GTDPOSNR | NUMC | 5 | NUM05 | ||||
LIFNR_NAME | Vendor Name | J_3RF_GTD_LIFNR_NAME | CHAR | 140 | CHAR140 | ||||
GTDPOS | Customs Declaration Document Line Item Number | J_3RF_GTDITEM | NUMC | 3 | J_3RF_GTDPOSNR | J_3RF_GTD_POSNR | |||
ISSUEDAT | Issue Date of Goods in Customs Declaration | J_3RF_GTDISSUED | DATS | 8 | DATE | ||||
ORDERNUM | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
ORDERPOS | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
BILLREF | Billing Document Reference | J_3RF_BILLREF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
MMDOCNUM | Material Document Reference | J_3RF_GTD_MMDOCNUM | CHAR | 10 | ALPHA | BELNR | |||
MMDOCJAHR | Year of Material Document Reference | J_3RF_GTD_MMDOCJAHR | NUMC | 4 | GJAHR | GJAHR | |||
MMDOCPOS | Item of Material Document Reference | J_3RF_GTD_MMDOCPOS | NUMC | 4 | MBLPO | ||||
INDELNUM | Inbound Delivery Reference | J_3RF_GTD_DELNUM | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
INDELPOS | Inbound Delivery Item Reference | J_3RF_GTD_DELPOS | NUMC | 6 | Assigned to domain | POSNR | |||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
MATTEXT | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MENGE | Material Quantity in Base Unit of Measure | J_3RFGTD_QNT | QUAN | 13(3) | MENG13 | ||||
OPENMENGE | Available Material Quantity in the Customs Declaration Item | J_3RFGTD_OPENQNT | QUAN | 13(3) | MENG13 | ||||
INVOICENUM | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
INVOICEPOS | Billing item | POSNR_VF | NUMC | 6 | Assigned to domain | POSNR | |||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
FKART | Billing Type | FKART | CHAR | 4 | Assigned to domain | FKART | |||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
INVNUMREF | Number of Original Billing Document Referenced | J_3RF_GTDINVREF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
INVPOSREF | Item of Original Billing Document Referenced | J_3RF_GTDPOSREF | NUMC | 6 | Assigned to domain | POSNR | |||
KUNNR | Invoice Sold-to Party | J_3RF_GTD_INVKUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KUNNR_NAME | Invoice Sold-to Party Description | J_3RF_GTD_INVKUNNR_NAME | CHAR | 140 | CHAR140 | ||||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
ZEILE | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
MBLNRREF | Number of Original Material Document Referenced | J_3RF_GTDMDOCREF | CHAR | 10 | ALPHA | BELNR | |||
MJAHRREF | Original Material Document Year | J_3RF_GTDMJAHRREF | NUMC | 4 | GJAHR | GJAHR | |||
ZEILEREF | Item of Original Material Document Referenced | J_3RF_GTDMPOSREF | NUMC | 4 | MBLPO | ||||
REFTSTAMP | Time Stamp of Reference creation | J_3RF_GTDREFTST | CHAR | 14 | TIMESTAMP | ||||
GTDTSTAMP | Time Stamp of GTD creation | J_3RF_GTDTSCRE | CHAR | 14 | TIMESTAMP | ||||
D_TYPE | Item Type in Customs Declaration Usage Report | J_3RF_GTDREPLINE | CHAR | 1 | J_3RF_GTDREPLINE |
Key field | Non-key field |
How do I retrieve data from SAP structure J_3RFGTD_REP using ABAP code?
As J_3RFGTD_REP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J_3RFGTD_REP as there is no data to select.How to access SAP table J_3RFGTD_REP
Within an ECC or HANA version of SAP you can also view further information about J_3RFGTD_REP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects