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
⤷ 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
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in |