SAP ABAP Table /ECRS/WLEN_ADD_S (Worklist for Intrastat Declaration - Data to Create)
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_ADD_S | Table Relationship Diagram |
Short Description | Worklist for Intrastat Declaration - Data to Create |
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 | GFLOW | /ECRS/GFLOW | /ECRS/GFLOW | CHAR | 1 | 0 | Flow of Goods | ||
2 | RETFL | /ECRS/RETFL | XFELD | CHAR | 1 | 0 | Indicator: Returns | ||
3 | ENTYP | /ECRS/ENTYP | /ECRS/ENTYP | CHAR | 1 | 0 | Type of Entry in Worklist | ||
4 | GDDAT | /ECRS/GDDAT | DATS | DATS | 8 | 0 | Date of Goods Movement | ||
5 | IDDAT | /ECRS/IDDAT | DATS | DATS | 8 | 0 | Date of Invoice for Goods Movement | ||
6 | CDDAT | /ECRS/CDDAT | DATS | DATS | 8 | 0 | Date of Correction or Cancellation | ||
7 | RPYEA | /ECRS/RPYEA | /ECRS/CYEAR | NUMC | 4 | 0 | Declaration Year | ||
8 | RPMON | /ECRS/RPMON | /ECRS/MONTH | CHAR | 2 | 0 | Declaration Month | ||
9 | .INCLUDE | 0 | 0 | Goods Movement: Reference Data | |||||
10 | GDSRC | /ECRS/GDSRC | LOGSYS | CHAR | 10 | 0 | Goods Movement: Source System | TBDLS | |
11 | GDOBT | /ECRS/GDOBT | /ECRS/GDOBT | CHAR | 10 | 0 | Goods Movement: Object Type | ||
12 | GDOBK | /ECRS/GDOBK | /ECRS/OBKEY | CHAR | 40 | 0 | Goods Movement: Object Key/Document Number | ||
13 | GDOBI | /ECRS/GDOBI | /ECRS/OBITN | CHAR | 10 | 0 | Goods Movement: Item Number | ||
14 | .INCLUDE | 0 | 0 | Invoice: Reference Data | |||||
15 | IDSRC | /ECRS/IDSRC | LOGSYS | CHAR | 10 | 0 | Invoice for Goods Movement: Source System | TBDLS | |
16 | IDOBT | /ECRS/IDOBT | /ECRS/IDOBT | CHAR | 10 | 0 | Invoice for Goods Movement: Object Type | ||
17 | IDOBK | /ECRS/IDOBK | /ECRS/OBKEY | CHAR | 40 | 0 | Invoice for Goods Movement: Object Key/Document Number | ||
18 | IDOBI | /ECRS/IDOBI | /ECRS/OBITN | CHAR | 10 | 0 | Invoice for Goods Movement: Item Number | ||
19 | .INCLUDE | 0 | 0 | Correction: Reference Data | |||||
20 | CDSRC | /ECRS/CDSRC | LOGSYS | CHAR | 10 | 0 | Correction: Source System | TBDLS | |
21 | CDOBT | /ECRS/CDOBT | /ECRS/CDOBT | CHAR | 10 | 0 | Correction: Object Type | ||
22 | CDOBK | /ECRS/CDOBK | /ECRS/OBKEY | CHAR | 40 | 0 | Correction: Object Key/Document Number | ||
23 | CDOBI | /ECRS/CDOBI | /ECRS/OBITN | CHAR | 10 | 0 | Correction: Item Number | ||
24 | .INCLUDE | 0 | 0 | Cancellation Document: Reference Data | |||||
25 | CNSRC | /ECRS/CNSRC | LOGSYS | CHAR | 10 | 0 | Cancellation: Source System | TBDLS | |
26 | CNOBT | /ECRS/CNOBT | /ECRS/CNOBT | CHAR | 10 | 0 | Cancellation: Object Type | ||
27 | CNOBK | /ECRS/CNOBK | /ECRS/OBKEY | CHAR | 40 | 0 | Cancellation: Object Key/Document Number | ||
28 | CNOBI | /ECRS/CNOBI | /ECRS/OBITN | CHAR | 10 | 0 | Cancellation: Item Number | ||
29 | .INCLUDE | 0 | 0 | Order/Purchase Order Document: Reference Data | |||||
30 | ODSRC | /ECRS/ODSRC | LOGSYS | CHAR | 10 | 0 | Sales/Purchasing Document: Source System | TBDLS | |
31 | ODOBT | /ECRS/ODOBT | /ECRS/ODOBT | CHAR | 10 | 0 | Sales/Purchasing Document: Object Type | ||
32 | ODOBK | /ECRS/ODOBK | /ECRS/OBKEY | CHAR | 40 | 0 | Sales/Purchasing Document: Object Key/Document Number | ||
33 | ODOBI | /ECRS/ODOBI | /ECRS/OBITN | CHAR | 10 | 0 | Sales/Purchasing Document: Item Number | ||
34 | .INCLUDE | 0 | 0 | Worklist - Provider of Information | |||||
35 | POIVA | /ECRS/POIVA | /ECRS/VATID | CHAR | 20 | 0 | VAT Registration Number of Provider of Information | ||
36 | POIAD | /ECRS/POIAD | /ECRS/ADDNR | CHAR | 5 | 0 | Additional Number of Provider of Information | ||
37 | GFPIC | /ECRS/GFPIC | LAND1 | CHAR | 3 | 0 | Country of Provider of Information (Flow of Goods) (Int.SAP) | T005 | |
38 | GFPIR | /ECRS/GFPIR | REGIO | CHAR | 3 | 0 | Region of Provider of Information (Flow of Goods) (Int. SAP) | T005S | |
39 | .INCLUDE | 0 | 0 | Worklist - Value Flow | |||||
40 | VFPTT | /ECRS/VFPTT | /ECRS/VFPTT | CHAR | 1 | 0 | Partner Type (Value Flow) | ||
41 | VFPTV | /ECRS/VFPTV | /ECRS/VATID | CHAR | 20 | 0 | Partner VAT Registration Number (Value Flow) | ||
42 | VFPTC | /ECRS/VFPTC | LAND1 | CHAR | 3 | 0 | Partner Country (Value Flow) (Internal SAP Code) | T005 | |
43 | VFPTN | /ECRS/VFPTN | BU_PARTNER | CHAR | 10 | 0 | Partner Number (Value Flow) | * | |
44 | .INCLUDE | 0 | 0 | Worklist - Flow of Goods | |||||
45 | GFPTC | /ECRS/GFPTC | LAND1 | CHAR | 3 | 0 | Partner Country (Flow of Goods) (Internal SAP Code) | T005 | |
46 | GFPTR | /ECRS/GFPTR | REGIO | CHAR | 3 | 0 | Region in Partner Country (Flow of Goods) (Int. SAP Code) | T005S | |
47 | GFPTN | /ECRS/GFPTN | BU_PARTNER | CHAR | 10 | 0 | Partner Number (Flow of Goods) | * | |
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 | RPCTI | /ECRS/RPCTI | /ECRS/RPCTI | CHAR | 2 | 0 | Country of Declaration (ISO Code) | * | |
57 | .INCLUDE | 0 | 0 | Worklist - Characteristics | |||||
58 | BTTYP | /ECRS/BTTYP | /ECRS/BTTYP | CHAR | 2 | 0 | Business Transaction Type (Intrastat Code) | * | |
59 | PRCDR | /ECRS/PRCDR | /ECRS/PRCDR | CHAR | 5 | 0 | Procedure (Intrastat Code) | * | |
60 | MOTAB | /ECRS/MOTAB | /ECRS/MOTAB | CHAR | 1 | 0 | Mode of Transport at the Border (Intrastat Code) | * | |
61 | NAOTV | /ECRS/NAOTV | LAND1 | CHAR | 3 | 0 | Country of Means of Transport | * | |
62 | PORTI | /ECRS/PORTI | /ECRS/PORTI | CHAR | 4 | 0 | Port/Airport (Intrastat Code) | * | |
63 | INCTM | /ECRS/INCTM | CHAR03 | CHAR | 3 | 0 | Incoterms | ||
64 | SPMCO | /ECRS/SPMCO | /ECRS/SPMCO | CHAR | 2 | 0 | Special Movement Code (Intrastat Code) | * | |
65 | ORPYE | /ECRS/ORPYE | /ECRS/CYEAR | NUMC | 4 | 0 | Declaration Year of Original Entry | ||
66 | ORPMO | /ECRS/ORPMO | /ECRS/MONTH | CHAR | 2 | 0 | Declaration Month of Original Entry | ||
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 | .INCLUDE | 0 | 0 | Additional Fields | |||||
81 | ADDF1 | /ECRS/ADDF1 | /ECRS/ADDF1 | CHAR | 5 | 0 | Additional Field 1 | ||
82 | ADDF2 | /ECRS/ADDF2 | /ECRS/ADDF2 | CHAR | 10 | 0 | Additional Field 2 | ||
83 | ADDF3 | /ECRS/ADDF3 | /ECRS/ADDF3 | CHAR | 15 | 0 | Additional Field 3 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /ECRS/WLEN_ADD_S | BMUOM | T006 | MSEHI | KEY | 1 | CN |
2 | /ECRS/WLEN_ADD_S | CDSRC | TBDLS | LOGSYS | KEY | 1 | CN |
3 | /ECRS/WLEN_ADD_S | CNSRC | TBDLS | LOGSYS | KEY | 1 | CN |
4 | /ECRS/WLEN_ADD_S | CTYOO | T005 | LAND1 | KEY | 1 | CN |
5 | /ECRS/WLEN_ADD_S | DOUOM | T006 | MSEHI | KEY | 1 | CN |
6 | /ECRS/WLEN_ADD_S | GDSRC | TBDLS | LOGSYS | KEY | 1 | CN |
7 | /ECRS/WLEN_ADD_S | GFPIC | T005 | LAND1 | KEY | 1 | CN |
8 | /ECRS/WLEN_ADD_S | GFPIR | T005S | BLAND | KEY | 1 | CN |
9 | /ECRS/WLEN_ADD_S | GFPTC | T005 | LAND1 | KEY | 1 | CN |
10 | /ECRS/WLEN_ADD_S | GFPTR | T005S | BLAND | KEY | 1 | CN |
11 | /ECRS/WLEN_ADD_S | IDSRC | TBDLS | LOGSYS | KEY | 1 | CN |
12 | /ECRS/WLEN_ADD_S | INCUR | TCURC | WAERS | KEY | 1 | CN |
13 | /ECRS/WLEN_ADD_S | NWUOM | T006 | MSEHI | KEY | 1 | CN |
14 | /ECRS/WLEN_ADD_S | ODSRC | TBDLS | LOGSYS | KEY | 1 | CN |
15 | /ECRS/WLEN_ADD_S | REGOO | T005S | BLAND | KEY | 1 | CN |
16 | /ECRS/WLEN_ADD_S | SPUOM | T006 | MSEHI | KEY | 1 | CN |
17 | /ECRS/WLEN_ADD_S | STCUR | TCURC | WAERS | KEY | 1 | CN |
18 | /ECRS/WLEN_ADD_S | VFPTC | T005 | LAND1 | KEY | 1 | CN |
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in |