SAP ABAP Table /ECRS/RPIT (Declaration Item)
Hierarchy
☛
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
⤷ SLL-ECR (Application Component) Electronic Compliance Reporting
⤷ /ECRS/BL_TD (Package) ECR: Business Logic - Transaction Data
⤷ SLL-ECR (Application Component) Electronic Compliance Reporting
⤷ /ECRS/BL_TD (Package) ECR: Business Logic - Transaction Data
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | /ECRS/RPIT | Table Relationship Diagram |
Short Description | Declaration Item |
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 | Declaration Item - Key | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | .INCLUDE | 0 | 0 | Declaration Item - Key w/o Client | |||||
4 | GUID_RPIT | /ECRS/GUID_16 | SYSUUID | RAW | 16 | 0 | GUID in 'RAW' format | ||
5 | .INCLUDE | 0 | 0 | Declaration Item - Data | |||||
6 | ITNUM | /ECRS/ITNUM | /ECRS/ITNUM | NUMC | 10 | 0 | Item Number in Intrastat Declaration | ||
7 | GUID_RPHD | /ECRS/GUID_16 | SYSUUID | RAW | 16 | 0 | GUID in 'RAW' format | ||
8 | GUID_RPAI | /ECRS/GUID_16 | SYSUUID | RAW | 16 | 0 | GUID in 'RAW' format | ||
9 | RPCTI | /ECRS/RPCTI | /ECRS/RPCTI | CHAR | 2 | 0 | Country of Declaration (ISO Code) | /ECRS/TRPC | |
10 | DIREC | /ECRS/DIREC | /ECRS/DIREC | CHAR | 1 | 0 | Direction (Receipt, Dispatch) | ||
11 | ITCPL | /ECRS/ITCPL | XFELD | CHAR | 1 | 0 | Indicator: Item Is Correct | ||
12 | MANCF | /ECRS/MANCF | XFELD | CHAR | 1 | 0 | Indicator: Item Was Created Manuall | ||
13 | .INCLUDE | 0 | 0 | Declaration Item - Characteristics | |||||
14 | BTTYP | /ECRS/BTTYP | /ECRS/BTTYP | CHAR | 2 | 0 | Business Transaction Type (Intrastat Code) | /ECRS/TBTT | |
15 | PRCDR | /ECRS/PRCDR | /ECRS/PRCDR | CHAR | 5 | 0 | Procedure (Intrastat Code) | /ECRS/TPRC | |
16 | COMCD | /ECRS/COMCD | /ECRS/COMCD | CHAR | 30 | 0 | Commodity Code | ||
17 | PTCTI | /ECRS/PTCTI | /ECRS/PTCTI | CHAR | 2 | 0 | Partner Country (Intrastat Code) | /ECRS/TRAP | |
18 | REGIN | /ECRS/REGIN | /ECRS/REGIN | CHAR | 3 | 0 | Region in Country of Declaration (Intrastat Code) | /ECRS/TRGI | |
19 | CTOOI | /ECRS/CTOOI | /ECRS/CTOOI | CHAR | 2 | 0 | Country of Origin (Intrastat Code) | /ECRS/TRCO | |
20 | MOTAB | /ECRS/MOTAB | /ECRS/MOTAB | CHAR | 1 | 0 | Mode of Transport at the Border (Intrastat Code) | /ECRS/TMOT | |
21 | NAOTV | /ECRS/NAOTV | LAND1 | CHAR | 3 | 0 | Country of Means of Transport | T005 | |
22 | PORTI | /ECRS/PORTI | /ECRS/PORTI | CHAR | 4 | 0 | Port/Airport (Intrastat Code) | /ECRS/TPRT | |
23 | INCOI | /ECRS/INCOI | /ECRS/INCOI | CHAR | 3 | 0 | Incoterms (Intrastat Code) | /ECRS/TINC | |
24 | SPMCO | /ECRS/SPMCO | /ECRS/SPMCO | CHAR | 2 | 0 | Special Movement Code (Intrastat Code) | /ECRS/TSMC | |
25 | PTVAT | /ECRS/PTVAT | /ECRS/VATID | CHAR | 20 | 0 | VAT Registration Number of Partner | ||
26 | .INCLUDE | 0 | 0 | Declaration Item - Key Figures | |||||
27 | INVAL | /ECRS/INVAL | WERT15 | CURR | 15 | 2 | Invoice Value | ||
28 | STVAL | /ECRS/STVAL | WERT15 | CURR | 15 | 2 | Statistical Value | ||
29 | RPCUR | /ECRS/RPCUR | WAERS | CUKY | 5 | 0 | Key of Declaration Currency | TCURC | |
30 | IFVAL | /ECRS/IFVAL | WERT15 | CURR | 15 | 2 | Invoice Value in Foreign Currency | ||
31 | FCCUR | /ECRS/FCCUR | WAERS | CUKY | 5 | 0 | Key of Foreign Currency | TCURC | |
32 | NTWEI | /ECRS/NTWEI | MENG13 | QUAN | 13 | 3 | Net Weight | ||
33 | KGUOM | /ECRS/KGUOM | MEINS | UNIT | 3 | 0 | Unit of Measure for Kilograms | T006 | |
34 | SPQUA | /ECRS/SPQUA | MENG13 | QUAN | 13 | 3 | Quantity in Supplementary Unit | ||
35 | SPUOM | /ECRS/SPUOM | MEINS | UNIT | 3 | 0 | Supplementary Unit | T006 | |
36 | .INCLUDE | 0 | 0 | Additional Fields | |||||
37 | ADDF1 | /ECRS/ADDF1 | /ECRS/ADDF1 | CHAR | 5 | 0 | Additional Field 1 | ||
38 | ADDF2 | /ECRS/ADDF2 | /ECRS/ADDF2 | CHAR | 10 | 0 | Additional Field 2 | ||
39 | ADDF3 | /ECRS/ADDF3 | /ECRS/ADDF3 | CHAR | 15 | 0 | Additional Field 3 | ||
40 | GFLOW | /ECRS/GFLOW | /ECRS/GFLOW | CHAR | 1 | 0 | Flow of Goods | ||
41 | .INCLUDE | 0 | 0 | Administrative Data: Created by, Changed by, Time Stamp | |||||
42 | CRTBY | /ECRS/CRTBY | XUBNAME | CHAR | 12 | 0 | Name of User Who Added Object | USR02 | |
43 | CRTTS | /ECRS/CRTTS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp When Object Was Added | ||
44 | LCHBY | /ECRS/LCHBY | XUBNAME | CHAR | 12 | 0 | Name of User Who Changed Object | USR02 | |
45 | LCHTS | /ECRS/LCHTS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp When Object Was Changed |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /ECRS/RPIT | CRTBY | USR02 | BNAME | KEY | 1 | CN |
2 | /ECRS/RPIT | FCCUR | TCURC | WAERS | KEY | 1 | CN |
3 | /ECRS/RPIT | KGUOM | T006 | MSEHI | KEY | 1 | CN |
4 | /ECRS/RPIT | LCHBY | USR02 | BNAME | KEY | 1 | CN |
5 | /ECRS/RPIT | MANDT | T000 | MANDT | KEY | 1 | CN |
6 | /ECRS/RPIT | NAOTV | T005 | LAND1 | KEY | 1 | N |
7 | /ECRS/RPIT | PORTI | /ECRS/TPRT | RPCTI | KEY | 1 | CN |
8 | /ECRS/RPIT | PRCDR | /ECRS/TPRC | RPCTI | KEY | 1 | CN |
9 | /ECRS/RPIT | RPCUR | TCURC | WAERS | KEY | 1 | CN |
10 | /ECRS/RPIT | SPUOM | T006 | MSEHI | KEY | 1 | CN |
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in | 710 |