SAP ABAP Table /ECRS/DVIA (Default Values for Import Worklist)
Hierarchy
☛
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
⤷
SLL-ECR (Application Component) Electronic Compliance Reporting
⤷
/ECRS/BL_MD (Package) ECR: Business Logic - Master Data
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation⤷
SLL-ECR (Application Component) Electronic Compliance Reporting⤷
/ECRS/BL_MD (Package) ECR: Business Logic - Master Data
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | /ECRS/DVIA |
Table Relationship Diagram 
|
| Short Description | Default Values for Import Worklist |
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 | Default Values for Import Worklist - Key | |||||
| 2 | MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 3 | .INCLUDE |
0 | 0 | Default Values for Import - Key w/o Client | |||||
| 4 | POIID |
/ECRS/POIID | /ECRS/POIID | CHAR | 10 | 0 | Provider of Information ID | /ECRS/POIA | |
| 5 | DIREC |
/ECRS/DIREC | /ECRS/DIREC | CHAR | 1 | 0 | Direction (Receipt, Dispatch) | ||
| 6 | PTCTI |
/ECRS/PTCTI | /ECRS/PTCTI | CHAR | 2 | 0 | Partner Country (Intrastat Code) | /ECRS/TRAP | |
| 7 | .INCLUDE |
0 | 0 | Default Values for Worklist Import - Data | |||||
| 8 | RPCTI |
/ECRS/RPCTI | /ECRS/RPCTI | CHAR | 2 | 0 | Country of Declaration (ISO Code) | /ECRS/TRPC | |
| 9 | .INCLUDE |
0 | 0 | Default Values for Worklist Import - Default Values | |||||
| 10 | BTTYP |
/ECRS/BTTYP | /ECRS/BTTYP | CHAR | 2 | 0 | Business Transaction Type (Intrastat Code) | /ECRS/TBTT | |
| 11 | PRCDR |
/ECRS/PRCDR | /ECRS/PRCDR | CHAR | 5 | 0 | Procedure (Intrastat Code) | /ECRS/TPRC | |
| 12 | MOTAB |
/ECRS/MOTAB | /ECRS/MOTAB | CHAR | 1 | 0 | Mode of Transport at the Border (Intrastat Code) | /ECRS/TMOT | |
| 13 | NAOTV |
/ECRS/NAOTV | LAND1 | CHAR | 3 | 0 | Country of Means of Transport | T005 | |
| 14 | INCOI |
/ECRS/INCOI | /ECRS/INCOI | CHAR | 3 | 0 | Incoterms (Intrastat Code) | /ECRS/TINC | |
| 15 | REGIN |
/ECRS/REGIN | /ECRS/REGIN | CHAR | 3 | 0 | Region in Country of Declaration (Intrastat Code) | /ECRS/TRGI | |
| 16 | CTOOI |
/ECRS/CTOOI | /ECRS/CTOOI | CHAR | 2 | 0 | Country of Origin (Intrastat Code) | /ECRS/TRCO | |
| 17 | PORTI |
/ECRS/PORTI | /ECRS/PORTI | CHAR | 4 | 0 | Port/Airport (Intrastat Code) | /ECRS/TPRT | |
| 18 | SPMCO |
/ECRS/SPMCO | /ECRS/SPMCO | CHAR | 2 | 0 | Special Movement Code (Intrastat Code) | /ECRS/TSMC | |
| 19 | .INCLUDE |
0 | 0 | Administrative Data: Created by, Changed by, Time Stamp | |||||
| 20 | CRTBY |
/ECRS/CRTBY | XUBNAME | CHAR | 12 | 0 | Name of User Who Added Object | USR02 | |
| 21 | CRTTS |
/ECRS/CRTTS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp When Object Was Added | ||
| 22 | LCHBY |
/ECRS/LCHBY | XUBNAME | CHAR | 12 | 0 | Name of User Who Changed Object | USR02 | |
| 23 | 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/DVIA | CRTBY |  USR02 |
BNAME |
KEY | 1 | CN |
| 2 | /ECRS/DVIA | LCHBY | USR02 |
BNAME |
KEY | 1 | CN |
| 3 | /ECRS/DVIA | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 4 | /ECRS/DVIA | NAOTV | T005 |
LAND1 |
|||
| 5 | /ECRS/DVIA | POIID | /ECRS/POIA |
MANDT |
KEY | 1 | CN |
| 6 | /ECRS/DVIA | PORTI | /ECRS/TPRT |
RPCTI |
KEY | 1 | CN |
| 7 | /ECRS/DVIA | PRCDR | /ECRS/TPRC |
RPCTI |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20141106 |
| SAP Release Created in | 710 |
