SAP ABAP Table /ECRS/WLEN_EXT_ERP_S (External Structure for Creating Worklist Entries)
Hierarchy
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
   SLL-ECR (Application Component) Electronic Compliance Reporting
     /ECRS/IM_FC (Package) ECR: Integration Module - Functions
Basic Data
Table Category INTTAB    Structure 
Structure /ECRS/WLEN_EXT_ERP_S   Table Relationship Diagram
Short Description External Structure for Creating Worklist Entries    
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 GDSRC /ECRS/GDSRC LOGSYS CHAR 10   0   Goods Movement: Source System *
2 GDOBT /ECRS/GDOBT /ECRS/GDOBT CHAR 10   0   Goods Movement: Object Type  
3 GDOBK /ECRS/GDOBK /ECRS/OBKEY CHAR 40   0   Goods Movement: Object Key/Document Number  
4 GDOBI /ECRS/GDOBI /ECRS/OBITN CHAR 10   0   Goods Movement: Item Number  
5 IDSRC /ECRS/IDSRC LOGSYS CHAR 10   0   Invoice for Goods Movement: Source System *
6 IDOBT /ECRS/IDOBT /ECRS/IDOBT CHAR 10   0   Invoice for Goods Movement: Object Type  
7 IDOBK /ECRS/IDOBK /ECRS/OBKEY CHAR 40   0   Invoice for Goods Movement: Object Key/Document Number  
8 IDOBI /ECRS/IDOBI /ECRS/OBITN CHAR 10   0   Invoice for Goods Movement: Item Number  
9 CDSRC /ECRS/CDSRC LOGSYS CHAR 10   0   Correction: Source System *
10 CDOBT /ECRS/CDOBT /ECRS/CDOBT CHAR 10   0   Correction: Object Type  
11 CDOBK /ECRS/CDOBK /ECRS/OBKEY CHAR 40   0   Correction: Object Key/Document Number  
12 CDOBI /ECRS/CDOBI /ECRS/OBITN CHAR 10   0   Correction: Item Number  
13 CNSRC /ECRS/CNSRC LOGSYS CHAR 10   0   Cancellation: Source System *
14 CNOBT /ECRS/CNOBT /ECRS/CNOBT CHAR 10   0   Cancellation: Object Type  
15 CNOBK /ECRS/CNOBK /ECRS/OBKEY CHAR 40   0   Cancellation: Object Key/Document Number  
16 CNOBI /ECRS/CNOBI /ECRS/OBITN CHAR 10   0   Cancellation: Item Number  
17 GFLOW /ECRS/GFLOW /ECRS/GFLOW CHAR 1   0   Flow of Goods  
18 ENTYP /ECRS/ENTYP /ECRS/ENTYP CHAR 1   0   Type of Entry in Worklist  
19 GDDAT /ECRS/GDDAT DATS DATS 8   0   Date of Goods Movement  
20 IDDAT /ECRS/IDDAT DATS DATS 8   0   Date of Invoice for Goods Movement  
21 CDDAT /ECRS/CDDAT DATS DATS 8   0   Date of Correction or Cancellation  
22 ODSRC /ECRS/ODSRC LOGSYS CHAR 10   0   Sales/Purchasing Document: Source System *
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 POIVA /ECRS/POIVA /ECRS/VATID CHAR 20   0   VAT Registration Number of Provider of Information  
29 POIAD /ECRS/POIAD /ECRS/ADDNR CHAR 5   0   Additional Number of Provider of Information  
30 GFPIC /ECRS/GFPIC LAND1 CHAR 3   0   Country of Provider of Information (Flow of Goods) (Int.SAP) T005
31 GFPIR /ECRS/GFPIR REGIO CHAR 3   0   Region of Provider of Information (Flow of Goods) (Int. SAP) T005S
32 VFPTT /ECRS/VFPTT /ECRS/VFPTT CHAR 1   0   Partner Type (Value Flow)  
33 VFPTV /ECRS/VFPTV /ECRS/VATID CHAR 20   0   Partner VAT Registration Number (Value Flow)  
34 VFPTC /ECRS/VFPTC LAND1 CHAR 3   0   Partner Country (Value Flow) (Internal SAP Code) T005
35 VFPTN /ECRS/VFPTN BU_PARTNER CHAR 10   0   Partner Number (Value Flow) BUT000
36 VFVCT /ECRS/VFVCT /ECRS/VCTYP CHAR 1   0   Type: Vendor or Customer of Partner (Value Flow)  
37 VFVCN /ECRS/VFVCN /ECRS/VCNUM CHAR 10   0   Vendor or Customer Number of Partner (Value Flow)  
38 GFPTC /ECRS/GFPTC LAND1 CHAR 3   0   Partner Country (Flow of Goods) (Internal SAP Code) T005
39 GFPTR /ECRS/GFPTR REGIO CHAR 3   0   Region in Partner Country (Flow of Goods) (Int. SAP Code) T005S
40 GFPTN /ECRS/GFPTN BU_PARTNER CHAR 10   0   Partner Number (Flow of Goods) BUT000
41 GFVCT /ECRS/GFVCT /ECRS/VCTYP CHAR 1   0   Type: Vendor or Customer of Partner (Flow of Goods)  
42 GFVCN /ECRS/GFVCN /ECRS/VCNUM CHAR 10   0   Vendor or Customer Number of Partner (Flow of Goods)  
43 RETFL /ECRS/RETFL XFELD CHAR 1   0   Indicator: Returns  
44 TGLFL /ECRS/TGLFL XFELD CHAR 1   0   Indicator: Triangular Transaction Within the EU  
45 COMCD /ECRS/COMCD_IF /ECRS/COMCD_IF CHAR 8   0   Commodity Code for Feeder System Interface  
46 PRNUM COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
47 MATNR /ECRS/MATNR /ECRS/MATNR CHAR 40   0   Material Number  
48 PRDES /ECRS/PRDES TEXT60 CHAR 60   0   Product Description  
49 CTYOO /ECRS/CTYOO LAND1 CHAR 3   0   Country of Origin (Internal SAP Code) T005
50 REGOO /ECRS/REGOO REGIO CHAR 3   0   Region of Origin (Internal SAP Code) T005S
51 BTTYP /ECRS/BTTYP /ECRS/BTTYP CHAR 2   0   Business Transaction Type (Intrastat Code) *
52 PRCDR /ECRS/PRCDR /ECRS/PRCDR CHAR 5   0   Procedure (Intrastat Code) *
53 MOTAB /ECRS/MOTAB /ECRS/MOTAB CHAR 1   0   Mode of Transport at the Border (Intrastat Code) *
54 PORTI /ECRS/PORTI /ECRS/PORTI CHAR 4   0   Port/Airport (Intrastat Code) *
55 INCTM /ECRS/INCTM CHAR03 CHAR 3   0   Incoterms  
56 SPMCO /ECRS/SPMCO /ECRS/SPMCO CHAR 2   0   Special Movement Code (Intrastat Code) *
57 INVAL /ECRS/INVAL WERT15 CURR 15   2   Invoice Value  
58 INCUR /ECRS/INCUR WAERS CUKY 5   0   Currency Key for Invoice Value TCURC
59 STVAL /ECRS/STVAL WERT15 CURR 15   2   Statistical Value  
60 STCUR /ECRS/STCUR WAERS CUKY 5   0   Currency Key for Statistical Value TCURC
61 NTWEI /ECRS/NTWEI MENG13 QUAN 13   3   Net Weight  
62 NWUOM /ECRS/NWUOM MEINS UNIT 3   0   Unit of Measure for Net Weight T006
63 SPQUA /ECRS/SPQUA MENG13 QUAN 13   3   Quantity in Supplementary Unit  
64 SPUOM /ECRS/SPUOM MEINS UNIT 3   0   Supplementary Unit T006
65 DOQUA /ECRS/DOQUA MENG13 QUAN 13   3   Quantity in Document Unit of Measure  
66 DOUOM /ECRS/DOUOM MEINS UNIT 3   0   Document Unit of Measure T006
67 BMQUA /ECRS/BMQUA MENG13 QUAN 13   3   Quantity in Base Unit of Measure  
68 BMUOM /ECRS/BMUOM MEINS UNIT 3   0   Base Unit of Measure T006
69 ORPYE /ECRS/ORPYE /ECRS/CYEAR NUMC 4   0   Declaration Year of Original Entry  
70 ORPMO /ECRS/ORPMO /ECRS/MONTH CHAR 2   0   Declaration Month of Original Entry  
71 ADDF1 /ECRS/ADDF1 /ECRS/ADDF1 CHAR 5   0   Additional Field 1  
72 ADDF2 /ECRS/ADDF2 /ECRS/ADDF2 CHAR 10   0   Additional Field 2  
73 ADDF3 /ECRS/ADDF3 /ECRS/ADDF3 CHAR 15   0   Additional Field 3  
74 COMCF /ECRS/COMCD /ECRS/COMCD CHAR 30   0   Commodity Code  
75 NAOTV /ECRS/NAOTV LAND1 CHAR 3   0   Country of Means of Transport *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /ECRS/WLEN_EXT_ERP_S BMUOM T006 MSEHI KEY 1 CN
2 /ECRS/WLEN_EXT_ERP_S CTYOO T005 LAND1 KEY 1 CN
3 /ECRS/WLEN_EXT_ERP_S DOUOM T006 MSEHI KEY 1 CN
4 /ECRS/WLEN_EXT_ERP_S GFPIC T005 LAND1 KEY 1 CN
5 /ECRS/WLEN_EXT_ERP_S GFPIR T005S BLAND KEY 1 CN
6 /ECRS/WLEN_EXT_ERP_S GFPTC T005 LAND1 KEY 1 CN
7 /ECRS/WLEN_EXT_ERP_S GFPTN BUT000 PARTNER KEY 1 CN
8 /ECRS/WLEN_EXT_ERP_S GFPTR T005S BLAND KEY 1 CN
9 /ECRS/WLEN_EXT_ERP_S INCUR TCURC WAERS KEY 1 CN
10 /ECRS/WLEN_EXT_ERP_S NWUOM T006 MSEHI KEY 1 CN
11 /ECRS/WLEN_EXT_ERP_S REGOO T005S BLAND KEY 1 CN
12 /ECRS/WLEN_EXT_ERP_S SPUOM T006 MSEHI KEY 1 CN
13 /ECRS/WLEN_EXT_ERP_S STCUR TCURC WAERS KEY 1 CN
14 /ECRS/WLEN_EXT_ERP_S VFPTC T005 LAND1 KEY 1 CN
15 /ECRS/WLEN_EXT_ERP_S VFPTN BUT000 PARTNER KEY 1 CN
History
Last changed by/on SAP  20141106 
SAP Release Created in 710