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