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