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