J_3RSCCDITEM_TOTAL SAP (All fields for CCD item) Structure details
Description: All fields for CCD item
Related tables to J_3RSCCDITEM_TOTAL
Access table J_3RSCCDITEM_TOTAL
Structure field list including key, data, relationships and ABAP select examples
J_3RSCCDITEM_TOTAL 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 "All fields for CCD item" 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_3RSCCDITEM_TOTAL TYPE J_3RSCCDITEM_TOTAL.
The J_3RSCCDITEM_TOTAL table consists of various fields, each holding specific information or linking keys about All fields for CCD item data available in SAP. These include MANDT (Client), CCD (Customs Declaration Document Number), ITEM (Customs Declaration Item Number), PAGE_NUM (Page Number).. 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: Can be enhanced (character-type or numeric)
SAP J_3RSCCDITEM_TOTAL 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
CCD | Customs Declaration Document Number | J_3RS_CCD_BELN | CHAR | 10 | J_3RSCCDHEADER | ALPHA | J_3RS_CCD_BELN | CCD | |
ITEM | Customs Declaration Item Number | J_3RS_CCDITEMID | NUMC | 3 | J_3RS_CCD_ID | ITEM | |||
PAGE_NUM | Page Number | J_3RS_PGNUM | NUMC | 3 | |||||
SRC_CCD | Reference Customs Declaration | J_3RS_SRC_CCD | CHAR | 10 | ALPHA | J_3RS_CCD_BELN | |||
SRC_ITEM | Source Customs Declaration Item | J_3RS_SRC_CCDITEM | NUMC | 3 | J_3RS_CCDITEMID | ||||
STAWN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | T604 | STAWN | |||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | T005 | LAND1 | LND | ||
NETWR | Net Value in Document Currency | J_3RS_NETWR | CURR | 11(2) | WERTV6 | ||||
LSMENG | Quantity for Customs Declaration Item | J_3RS_LSMENG | QUAN | 15(3) | MENG15 | ||||
EDATU | Schedule line date | EDATU | DATS | 8 | DATUM | ||||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
NTGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
TRANSP_OBJ1 | Transport Packaging Details 1 | J_3RS_TRANSP_OBJ1 | CHAR | 255 | TEXT255 | ||||
TRANSP_OBJ2 | Transport Packaging Details 2 | J_3RS_TRANSP_OBJ2 | CHAR | 255 | TEXT255 | ||||
ADD_INFO | Additional Information | J_3RS_ADD_INFO | CHAR | 255 | TEXT255 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
CNTR_BLN | Contract Number | J_3RS_CNTRBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
CNTR_PSNR | Contract Item | J_3RS_CNTRPSNR | NUMC | 6 | Assigned to domain | POSNR | |||
ORD_BLN | Order Number | J_3RS_ORDBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
ORD_PSNR | Order Item | J_3RS_ORDPSNR | NUMC | 6 | Assigned to domain | POSNR | |||
EXPORT_ALLOWED | Export Approval Date | J_3RS_EXPAL | DATS | 8 | DATUM | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
VRKME | Sales unit | VRKME | UNIT | 3 | MARM | CUNIT | MEINS | ||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
LWAERS | Currency Key of Company Code | J_3RS_LWAERS | CUKY | 5 | Assigned to domain | WAERS | |||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
UMZIZ | Numerator for the Conversion Factor | J_3RS_UMZIZ | DEC | 5 | UMBSZ | ||||
UMZIN | Denominator for the Conversion Factor | J_3RS_UMZIN | DEC | 5 | UMBSN | ||||
SD1_RATE | Rate of Customs Duties 1 | J_3RS_SD1RATE | CURR | 15(2) | WERTV8 | ||||
SD1_AMOUNT | Amount of Customs Duties 1 | J_3RS_SD1AM | CURR | 15(2) | WERTV8 | ||||
SD1_TYPE | Type of Customs Duties 1 | J_3RS_SD1TYPE | CURR | 15(2) | WERTV8 | ||||
SD2_AMOUNT | Amount of Customs Duties 2 | J_3RS_SD2AM | CURR | 15(2) | WERTV8 | ||||
SD2_TYPE | Type of Customs Duties 2 | J_3RS_SD2TYPE | CURR | 15(2) | WERTV8 | ||||
SD3_AMOUNT | Amount of Customs Duties 3 | J_3RS_SD3AM | CURR | 15(2) | WERTV8 | ||||
SD3_TYPE | Type of Customs Duties 3 | J_3RS_SD3TYPE | CURR | 15(2) | WERTV8 | ||||
ADD_TXT1 | Additional Text 1 | J_3RS_ADDTXT1 | CHAR | 130 | TXT130 | ||||
ADD_TXT2 | Additional Text 2 | J_3RS_ADDTXT2 | CHAR | 130 | TXT130 | ||||
KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND | ||||
STAWN_NAME | Commodity Code Description | J_3RS_STAWN_NAME | CHAR | 160 | CHAR160 | ||||
BRGEW_KG | Gross Weight of the Item (kg) | BRGEW_KG | QUAN | 15(3) | MENG15 | ||||
NTGEW_KG | Net Weight of the Item (kg) | NTGEW_KG | QUAN | 15(3) | MENG15 | ||||
GEWEI_KG | Weigth unit (kg) | GEWEI_KG | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SRC_BEHOE_P1 | Code of Registering Customs Office | J_3RS_BEHOE | CHAR | 10 | Assigned to domain | BEHOE | |||
SRC_DATE_P2 | Customs Declaration Registration Date | J_3RS_DATE | DATS | 8 | DATUM | ||||
SRC_EXTN_P3 | Customs Declaration External Document Number | J_3RS_EXTNUM | CHAR | 10 | J_3RS_CCD_NUM | ||||
WERKS | Plant (Own or External) | WERKS_EXT | CHAR | 4 | Assigned to domain | WERKS | WRK | SH_T001W_EXTS | |
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | TVST | VSTEL | VST | ||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
OPEN_QUANT | Open Quantity for Customs Declaration Item | J_3RS_OPENQUANT | QUAN | 15(3) | MENG15 | ||||
SUBI_QUANT_UOM | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SUBI_QUANT | Total Quantity for Customs Declaration Subitems | J_3RS_SUBIQUANT | QUAN | 15(3) | MENG15 | ||||
MGLME | Quantity in Base UOM | J_3RS_BUOMQUANT | QUAN | 15(3) | MENG15 | ||||
SRC_OPENQTY | Open Quantity for Source Customs Declaration Item | J_3RS_SRCOPENQNT | QUAN | 15(3) | MENG15 |
Key field | Non-key field |
How do I retrieve data from SAP structure J_3RSCCDITEM_TOTAL using ABAP code?
As J_3RSCCDITEM_TOTAL 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_3RSCCDITEM_TOTAL as there is no data to select.How to access SAP table J_3RSCCDITEM_TOTAL
Within an ECC or HANA version of SAP you can also view further information about J_3RSCCDITEM_TOTAL 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