SAP ABAP Table /ECRS/RP_LI_WL_S (Log Item Data and Worklist Data)
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 INTTAB    Structure 
Structure /ECRS/RP_LI_WL_S   Table Relationship Diagram
Short Description Log Item Data and Worklist Data    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 GUID_RPLH /ECRS/GUID_16 SYSUUID RAW 16   0   GUID in 'RAW' format  
2 ITNUM /ECRS/ITNUM /ECRS/ITNUM NUMC 10   0   Item Number in Intrastat Declaration  
3 RPITY /ECRS/RPITY /ECRS/RPITY CHAR 1   0   Item Category  
4 GUID_RPIT /ECRS/GUID_16 SYSUUID RAW 16   0   GUID in 'RAW' format  
5 PRFLG /ECRS/PRFLG /ECRS/PRFLG CHAR 1   0   Processing Status of an Entry During Import  
6 MSGTY /ECRS/MSGTY /ECRS/MSGTY CHAR 1   0   Message Type  
7 MSGID SYMSGID ARBGB CHAR 20   0   Message Class *
8 MSGNO SYMSGNO SYMSGNO NUMC 3   0   Message Number  
9 MSGV1 SYMSGV SYCHAR50 CHAR 50   0   Message Variable  
10 MSGV2 SYMSGV SYCHAR50 CHAR 50   0   Message Variable  
11 MSGV3 SYMSGV SYCHAR50 CHAR 50   0   Message Variable  
12 MSGV4 SYMSGV SYCHAR50 CHAR 50   0   Message Variable  
13 FWLED /ECRS/FWLED XFELD CHAR 1   0   Flag: Entry Was Deleted from Worklist  
14 .INCLUDE       0   0   Worklist for Intrastat Declaration - Data  
15 .INCLUDE       0   0   Goods Movement: Reference Data  
16 GDSRC /ECRS/GDSRC LOGSYS CHAR 10   0   Goods Movement: Source System TBDLS
17 GDOBT /ECRS/GDOBT /ECRS/GDOBT CHAR 10   0   Goods Movement: Object Type  
18 GDOBK /ECRS/GDOBK /ECRS/OBKEY CHAR 40   0   Goods Movement: Object Key/Document Number  
19 GDOBI /ECRS/GDOBI /ECRS/OBITN CHAR 10   0   Goods Movement: Item Number  
20 .INCLUDE       0   0   Invoice: Reference Data  
21 IDSRC /ECRS/IDSRC LOGSYS CHAR 10   0   Invoice for Goods Movement: Source System TBDLS
22 IDOBT /ECRS/IDOBT /ECRS/IDOBT CHAR 10   0   Invoice for Goods Movement: Object Type  
23 IDOBK /ECRS/IDOBK /ECRS/OBKEY CHAR 40   0   Invoice for Goods Movement: Object Key/Document Number  
24 IDOBI /ECRS/IDOBI /ECRS/OBITN CHAR 10   0   Invoice for Goods Movement: Item Number  
25 .INCLUDE       0   0   Correction: Reference Data  
26 CDSRC /ECRS/CDSRC LOGSYS CHAR 10   0   Correction: Source System TBDLS
27 CDOBT /ECRS/CDOBT /ECRS/CDOBT CHAR 10   0   Correction: Object Type  
28 CDOBK /ECRS/CDOBK /ECRS/OBKEY CHAR 40   0   Correction: Object Key/Document Number  
29 CDOBI /ECRS/CDOBI /ECRS/OBITN CHAR 10   0   Correction: Item Number  
30 .INCLUDE       0   0   Cancellation Document: Reference Data  
31 CNSRC /ECRS/CNSRC LOGSYS CHAR 10   0   Cancellation: Source System TBDLS
32 CNOBT /ECRS/CNOBT /ECRS/CNOBT CHAR 10   0   Cancellation: Object Type  
33 CNOBK /ECRS/CNOBK /ECRS/OBKEY CHAR 40   0   Cancellation: Object Key/Document Number  
34 CNOBI /ECRS/CNOBI /ECRS/OBITN CHAR 10   0   Cancellation: Item Number  
35 RPYEA /ECRS/RPYEA /ECRS/CYEAR NUMC 4   0   Declaration Year  
36 RPMON /ECRS/RPMON /ECRS/MONTH CHAR 2   0   Declaration Month  
37 GFLOW /ECRS/GFLOW /ECRS/GFLOW CHAR 1   0   Flow of Goods  
38 ENTYP /ECRS/ENTYP /ECRS/ENTYP CHAR 1   0   Type of Entry in Worklist  
39 GDDAT /ECRS/GDDAT DATS DATS 8   0   Date of Goods Movement  
40 IDDAT /ECRS/IDDAT DATS DATS 8   0   Date of Invoice for Goods Movement  
41 CDDAT /ECRS/CDDAT DATS DATS 8   0   Date of Correction or Cancellation  
42 .INCLUDE       0   0   Order/Purchase Order Document: Reference Data  
43 ODSRC /ECRS/ODSRC LOGSYS CHAR 10   0   Sales/Purchasing Document: Source System TBDLS
44 ODOBT /ECRS/ODOBT /ECRS/ODOBT CHAR 10   0   Sales/Purchasing Document: Object Type  
45 ODOBK /ECRS/ODOBK /ECRS/OBKEY CHAR 40   0   Sales/Purchasing Document: Object Key/Document Number  
46 ODOBI /ECRS/ODOBI /ECRS/OBITN CHAR 10   0   Sales/Purchasing Document: Item Number  
47 .INCLUDE       0   0   Worklist - Provider of Information  
48 POIVA /ECRS/POIVA /ECRS/VATID CHAR 20   0   VAT Registration Number of Provider of Information  
49 POIAD /ECRS/POIAD /ECRS/ADDNR CHAR 5   0   Additional Number of Provider of Information  
50 GFPIC /ECRS/GFPIC LAND1 CHAR 3   0   Country of Provider of Information (Flow of Goods) (Int.SAP) T005
51 GFPIR /ECRS/GFPIR REGIO CHAR 3   0   Region of Provider of Information (Flow of Goods) (Int. SAP) T005S
52 .INCLUDE       0   0   Worklist - Value Flow  
53 VFPTT /ECRS/VFPTT /ECRS/VFPTT CHAR 1   0   Partner Type (Value Flow)  
54 VFPTV /ECRS/VFPTV /ECRS/VATID CHAR 20   0   Partner VAT Registration Number (Value Flow)  
55 VFPTC /ECRS/VFPTC LAND1 CHAR 3   0   Partner Country (Value Flow) (Internal SAP Code) T005
56 VFPTN /ECRS/VFPTN BU_PARTNER CHAR 10   0   Partner Number (Value Flow) *
57 .INCLUDE       0   0   Worklist - Flow of Goods  
58 GFPTC /ECRS/GFPTC LAND1 CHAR 3   0   Partner Country (Flow of Goods) (Internal SAP Code) T005
59 GFPTR /ECRS/GFPTR REGIO CHAR 3   0   Region in Partner Country (Flow of Goods) (Int. SAP Code) T005S
60 GFPTN /ECRS/GFPTN BU_PARTNER CHAR 10   0   Partner Number (Flow of Goods) *
61 RETFL /ECRS/RETFL XFELD CHAR 1   0   Indicator: Returns  
62 TGLFL /ECRS/TGLFL XFELD CHAR 1   0   Indicator: Triangular Transaction Within the EU  
63 .INCLUDE       0   0   Worklist - Product Data  
64 COMCD /ECRS/COMCD /ECRS/COMCD CHAR 30   0   Commodity Code  
65 PRNUM COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
66 PRDES /ECRS/PRDES TEXT60 CHAR 60   0   Product Description  
67 CTYOO /ECRS/CTYOO LAND1 CHAR 3   0   Country of Origin (Internal SAP Code) T005
68 REGOO /ECRS/REGOO REGIO CHAR 3   0   Region of Origin (Internal SAP Code) T005S
69 GUID_PR /ECRS/GUID_16 SYSUUID RAW 16   0   GUID in 'RAW' format  
70 RPCTI /ECRS/RPCTI /ECRS/RPCTI CHAR 2   0   Country of Declaration (ISO Code) *
71 .INCLUDE       0   0   Worklist - Characteristics  
72 BTTYP /ECRS/BTTYP /ECRS/BTTYP CHAR 2   0   Business Transaction Type (Intrastat Code) *
73 PRCDR /ECRS/PRCDR /ECRS/PRCDR CHAR 5   0   Procedure (Intrastat Code) *
74 MOTAB /ECRS/MOTAB /ECRS/MOTAB CHAR 1   0   Mode of Transport at the Border (Intrastat Code) *
75 NAOTV /ECRS/NAOTV LAND1 CHAR 3   0   Country of Means of Transport *
76 PORTI /ECRS/PORTI /ECRS/PORTI CHAR 4   0   Port/Airport (Intrastat Code) *
77 INCTM /ECRS/INCTM CHAR03 CHAR 3   0   Incoterms  
78 SPMCO /ECRS/SPMCO /ECRS/SPMCO CHAR 2   0   Special Movement Code (Intrastat Code) *
79 ORPYE /ECRS/ORPYE /ECRS/CYEAR NUMC 4   0   Declaration Year of Original Entry  
80 ORPMO /ECRS/ORPMO /ECRS/MONTH CHAR 2   0   Declaration Month of Original Entry  
81 .INCLUDE       0   0   Worklist - Key Figures  
82 INVAL /ECRS/INVAL WERT15 CURR 15   2   Invoice Value  
83 INCUR /ECRS/INCUR WAERS CUKY 5   0   Currency Key for Invoice Value TCURC
84 STVAL /ECRS/STVAL WERT15 CURR 15   2   Statistical Value  
85 STCUR /ECRS/STCUR WAERS CUKY 5   0   Currency Key for Statistical Value TCURC
86 NTWEI /ECRS/NTWEI MENG13 QUAN 13   3   Net Weight  
87 NWUOM /ECRS/NWUOM MEINS UNIT 3   0   Unit of Measure for Net Weight T006
88 SPQUA /ECRS/SPQUA MENG13 QUAN 13   3   Quantity in Supplementary Unit  
89 SPUOM /ECRS/SPUOM MEINS UNIT 3   0   Supplementary Unit T006
90 DOQUA /ECRS/DOQUA MENG13 QUAN 13   3   Quantity in Document Unit of Measure  
91 DOUOM /ECRS/DOUOM MEINS UNIT 3   0   Document Unit of Measure T006
92 BMQUA /ECRS/BMQUA MENG13 QUAN 13   3   Quantity in Base Unit of Measure  
93 BMUOM /ECRS/BMUOM MEINS UNIT 3   0   Base Unit of Measure T006
94 .INCLUDE       0   0   Additional Fields  
95 ADDF1 /ECRS/ADDF1 /ECRS/ADDF1 CHAR 5   0   Additional Field 1  
96 ADDF2 /ECRS/ADDF2 /ECRS/ADDF2 CHAR 10   0   Additional Field 2  
97 ADDF3 /ECRS/ADDF3 /ECRS/ADDF3 CHAR 15   0   Additional Field 3  
98 .INCLUDE       0   0   Administrative Data: Created by, Changed by, Time Stamp  
99 CRTBY /ECRS/CRTBY XUBNAME CHAR 12   0   Name of User Who Added Object USR02
100 CRTTS /ECRS/CRTTS TZNTSTMPS DEC 15   0   UTC Time Stamp When Object Was Added  
101 LCHBY /ECRS/LCHBY XUBNAME CHAR 12   0   Name of User Who Changed Object USR02
102 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/RP_LI_WL_S BMUOM T006 MSEHI KEY 1 CN
2 /ECRS/RP_LI_WL_S CDSRC TBDLS LOGSYS KEY 1 CN
3 /ECRS/RP_LI_WL_S CNSRC TBDLS LOGSYS KEY 1 CN
4 /ECRS/RP_LI_WL_S CRTBY USR02 BNAME KEY 1 CN
5 /ECRS/RP_LI_WL_S CTYOO T005 LAND1 KEY 1 CN
6 /ECRS/RP_LI_WL_S DOUOM T006 MSEHI KEY 1 CN
7 /ECRS/RP_LI_WL_S GDSRC TBDLS LOGSYS KEY 1 CN
8 /ECRS/RP_LI_WL_S GFPIC T005 LAND1 KEY 1 CN
9 /ECRS/RP_LI_WL_S GFPIR T005S BLAND KEY 1 CN
10 /ECRS/RP_LI_WL_S GFPTC T005 LAND1 KEY 1 CN
11 /ECRS/RP_LI_WL_S GFPTR T005S BLAND KEY 1 CN
12 /ECRS/RP_LI_WL_S IDSRC TBDLS LOGSYS KEY 1 CN
13 /ECRS/RP_LI_WL_S INCUR TCURC WAERS KEY 1 CN
14 /ECRS/RP_LI_WL_S LCHBY USR02 BNAME KEY 1 CN
15 /ECRS/RP_LI_WL_S NWUOM T006 MSEHI KEY 1 CN
16 /ECRS/RP_LI_WL_S ODSRC TBDLS LOGSYS KEY 1 CN
17 /ECRS/RP_LI_WL_S REGOO T005S BLAND KEY 1 CN
18 /ECRS/RP_LI_WL_S SPUOM T006 MSEHI KEY 1 CN
19 /ECRS/RP_LI_WL_S STCUR TCURC WAERS KEY 1 CN
20 /ECRS/RP_LI_WL_S VFPTC T005 LAND1 KEY 1 CN
History
Last changed by/on SAP  20141106 
SAP Release Created in