SAP ABAP Table /ECRS/RPAI (Aggregated 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
Basic Data
Table Category TRANSP    Transparent table 
Transparent table /ECRS/RPAI   Table Relationship Diagram
Short Description Aggregated 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   Aggregated Declaration Item - Key  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 .INCLUDE       0   0   Aggregated Declaration Item - Key w/o Client  
4 GUID_RPAI /ECRS/GUID_16 SYSUUID RAW 16   0   GUID in 'RAW' format  
5 .INCLUDE       0   0   Aggregated 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 RPCTI /ECRS/RPCTI /ECRS/RPCTI CHAR 2   0   Country of Declaration (ISO Code) /ECRS/TRPC
9 DIREC /ECRS/DIREC /ECRS/DIREC CHAR 1   0   Direction (Receipt, Dispatch)  
10 .INCLUDE       0   0   Declaration Item - Characteristics  
11 BTTYP /ECRS/BTTYP /ECRS/BTTYP CHAR 2   0   Business Transaction Type (Intrastat Code) /ECRS/TBTT
12 PRCDR /ECRS/PRCDR /ECRS/PRCDR CHAR 5   0   Procedure (Intrastat Code) /ECRS/TPRC
13 COMCD /ECRS/COMCD /ECRS/COMCD CHAR 30   0   Commodity Code  
14 PTCTI /ECRS/PTCTI /ECRS/PTCTI CHAR 2   0   Partner Country (Intrastat Code) /ECRS/TRAP
15 REGIN /ECRS/REGIN /ECRS/REGIN CHAR 3   0   Region in Country of Declaration (Intrastat Code) /ECRS/TRGI
16 CTOOI /ECRS/CTOOI /ECRS/CTOOI CHAR 2   0   Country of Origin (Intrastat Code) /ECRS/TRCO
17 MOTAB /ECRS/MOTAB /ECRS/MOTAB CHAR 1   0   Mode of Transport at the Border (Intrastat Code) /ECRS/TMOT
18 NAOTV /ECRS/NAOTV LAND1 CHAR 3   0   Country of Means of Transport T005
19 PORTI /ECRS/PORTI /ECRS/PORTI CHAR 4   0   Port/Airport (Intrastat Code) /ECRS/TPRT
20 INCOI /ECRS/INCOI /ECRS/INCOI CHAR 3   0   Incoterms (Intrastat Code) /ECRS/TINC
21 SPMCO /ECRS/SPMCO /ECRS/SPMCO CHAR 2   0   Special Movement Code (Intrastat Code) /ECRS/TSMC
22 PTVAT /ECRS/PTVAT /ECRS/VATID CHAR 20   0   VAT Registration Number of Partner  
23 .INCLUDE       0   0   Declaration Item - Key Figures  
24 INVAL /ECRS/INVAL WERT15 CURR 15   2   Invoice Value  
25 STVAL /ECRS/STVAL WERT15 CURR 15   2   Statistical Value  
26 RPCUR /ECRS/RPCUR WAERS CUKY 5   0   Key of Declaration Currency TCURC
27 IFVAL /ECRS/IFVAL WERT15 CURR 15   2   Invoice Value in Foreign Currency  
28 FCCUR /ECRS/FCCUR WAERS CUKY 5   0   Key of Foreign Currency TCURC
29 NTWEI /ECRS/NTWEI MENG13 QUAN 13   3   Net Weight  
30 KGUOM /ECRS/KGUOM MEINS UNIT 3   0   Unit of Measure for Kilograms T006
31 SPQUA /ECRS/SPQUA MENG13 QUAN 13   3   Quantity in Supplementary Unit  
32 SPUOM /ECRS/SPUOM MEINS UNIT 3   0   Supplementary Unit T006
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /ECRS/RPAI FCCUR TCURC WAERS KEY 1 CN
2 /ECRS/RPAI KGUOM T006 MSEHI KEY 1 CN
3 /ECRS/RPAI MANDT T000 MANDT KEY 1 CN
4 /ECRS/RPAI NAOTV T005 LAND1 KEY 1 CN
5 /ECRS/RPAI PORTI /ECRS/TPRT RPCTI KEY 1 CN
6 /ECRS/RPAI PRCDR /ECRS/TPRC RPCTI KEY 1 CN
7 /ECRS/RPAI RPCUR TCURC WAERS KEY 1 CN
8 /ECRS/RPAI SPUOM T006 MSEHI KEY 1 CN
History
Last changed by/on SAP  20141106 
SAP Release Created in 710