SAP ABAP Table /ECRS/WLEN_EXT_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/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/WLEN_EXT_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 | GFPTC | /ECRS/GFPTC | LAND1 | CHAR | 3 | 0 | Partner Country (Flow of Goods) (Internal SAP Code) | T005 | |
37 | GFPTR | /ECRS/GFPTR | REGIO | CHAR | 3 | 0 | Region in Partner Country (Flow of Goods) (Int. SAP Code) | T005S | |
38 | GFPTN | /ECRS/GFPTN | BU_PARTNER | CHAR | 10 | 0 | Partner Number (Flow of Goods) | BUT000 | |
39 | RETFL | /ECRS/RETFL | XFELD | CHAR | 1 | 0 | Indicator: Returns | ||
40 | TGLFL | /ECRS/TGLFL | XFELD | CHAR | 1 | 0 | Indicator: Triangular Transaction Within the EU | ||
41 | COMCD | /ECRS/COMCD_IF | /ECRS/COMCD_IF | CHAR | 8 | 0 | Commodity Code for Feeder System Interface | ||
42 | PRNUM | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
43 | PRDES | /ECRS/PRDES | TEXT60 | CHAR | 60 | 0 | Product Description | ||
44 | CTYOO | /ECRS/CTYOO | LAND1 | CHAR | 3 | 0 | Country of Origin (Internal SAP Code) | T005 | |
45 | REGOO | /ECRS/REGOO | REGIO | CHAR | 3 | 0 | Region of Origin (Internal SAP Code) | T005S | |
46 | BTTYP | /ECRS/BTTYP | /ECRS/BTTYP | CHAR | 2 | 0 | Business Transaction Type (Intrastat Code) | * | |
47 | PRCDR | /ECRS/PRCDR | /ECRS/PRCDR | CHAR | 5 | 0 | Procedure (Intrastat Code) | * | |
48 | MOTAB | /ECRS/MOTAB | /ECRS/MOTAB | CHAR | 1 | 0 | Mode of Transport at the Border (Intrastat Code) | * | |
49 | PORTI | /ECRS/PORTI | /ECRS/PORTI | CHAR | 4 | 0 | Port/Airport (Intrastat Code) | * | |
50 | INCTM | /ECRS/INCTM | CHAR03 | CHAR | 3 | 0 | Incoterms | ||
51 | SPMCO | /ECRS/SPMCO | /ECRS/SPMCO | CHAR | 2 | 0 | Special Movement Code (Intrastat Code) | * | |
52 | INVAL | /ECRS/INVAL | WERT15 | CURR | 15 | 2 | Invoice Value | ||
53 | INCUR | /ECRS/INCUR | WAERS | CUKY | 5 | 0 | Currency Key for Invoice Value | TCURC | |
54 | STVAL | /ECRS/STVAL | WERT15 | CURR | 15 | 2 | Statistical Value | ||
55 | STCUR | /ECRS/STCUR | WAERS | CUKY | 5 | 0 | Currency Key for Statistical Value | TCURC | |
56 | NTWEI | /ECRS/NTWEI | MENG13 | QUAN | 13 | 3 | Net Weight | ||
57 | NWUOM | /ECRS/NWUOM | MEINS | UNIT | 3 | 0 | Unit of Measure for Net Weight | T006 | |
58 | SPQUA | /ECRS/SPQUA | MENG13 | QUAN | 13 | 3 | Quantity in Supplementary Unit | ||
59 | SPUOM | /ECRS/SPUOM | MEINS | UNIT | 3 | 0 | Supplementary Unit | T006 | |
60 | DOQUA | /ECRS/DOQUA | MENG13 | QUAN | 13 | 3 | Quantity in Document Unit of Measure | ||
61 | DOUOM | /ECRS/DOUOM | MEINS | UNIT | 3 | 0 | Document Unit of Measure | T006 | |
62 | BMQUA | /ECRS/BMQUA | MENG13 | QUAN | 13 | 3 | Quantity in Base Unit of Measure | ||
63 | BMUOM | /ECRS/BMUOM | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
64 | ORPYE | /ECRS/ORPYE | /ECRS/CYEAR | NUMC | 4 | 0 | Declaration Year of Original Entry | ||
65 | ORPMO | /ECRS/ORPMO | /ECRS/MONTH | CHAR | 2 | 0 | Declaration Month of Original Entry | ||
66 | ADDF1 | /ECRS/ADDF1 | /ECRS/ADDF1 | CHAR | 5 | 0 | Additional Field 1 | ||
67 | ADDF2 | /ECRS/ADDF2 | /ECRS/ADDF2 | CHAR | 10 | 0 | Additional Field 2 | ||
68 | ADDF3 | /ECRS/ADDF3 | /ECRS/ADDF3 | CHAR | 15 | 0 | Additional Field 3 | ||
69 | COMCF | /ECRS/COMCD | /ECRS/COMCD | CHAR | 30 | 0 | Commodity Code | ||
70 | 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_S | BMUOM | T006 | MSEHI | KEY | 1 | CN |
2 | /ECRS/WLEN_EXT_S | CTYOO | T005 | LAND1 | KEY | 1 | CN |
3 | /ECRS/WLEN_EXT_S | DOUOM | T006 | MSEHI | KEY | 1 | CN |
4 | /ECRS/WLEN_EXT_S | GFPIC | T005 | LAND1 | KEY | 1 | CN |
5 | /ECRS/WLEN_EXT_S | GFPIR | T005S | BLAND | KEY | 1 | CN |
6 | /ECRS/WLEN_EXT_S | GFPTC | T005 | LAND1 | KEY | 1 | CN |
7 | /ECRS/WLEN_EXT_S | GFPTN | BUT000 | PARTNER | KEY | 1 | CN |
8 | /ECRS/WLEN_EXT_S | GFPTR | T005S | BLAND | KEY | 1 | CN |
9 | /ECRS/WLEN_EXT_S | INCUR | TCURC | WAERS | KEY | 1 | CN |
10 | /ECRS/WLEN_EXT_S | NWUOM | T006 | MSEHI | KEY | 1 | CN |
11 | /ECRS/WLEN_EXT_S | REGOO | T005S | BLAND | KEY | 1 | CN |
12 | /ECRS/WLEN_EXT_S | SPUOM | T006 | MSEHI | KEY | 1 | CN |
13 | /ECRS/WLEN_EXT_S | STCUR | TCURC | WAERS | KEY | 1 | CN |
14 | /ECRS/WLEN_EXT_S | VFPTC | T005 | LAND1 | KEY | 1 | CN |
15 | /ECRS/WLEN_EXT_S | VFPTN | BUT000 | PARTNER | KEY | 1 | CN |
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in | 710 |