SAP ABAP Table /ECRS/UI_MD_DW_300_S (Create/Display/Change Default Values for Import: Detail)

Hierarchy

☛ SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
   ⤷ SLL-ECR (Application Component) Electronic Compliance Reporting
     ⤷ /ECRS/UI_MD (Package) ECR: User Interface - Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	/ECRS/UI_MD_DW_300_S	Table Relationship Diagram
Short Description	Create/Display/Change Default Values for Import: Detail

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	Default Values to Import Worklist for a POIID
2	DIREC	☐	/ECRS/DIREC	/ECRS/DIREC	CHAR	1	0	Direction (Receipt, Dispatch)
3	PTCTI	☐	/ECRS/PTCTI	/ECRS/PTCTI	CHAR	2	0	Partner Country (Intrastat Code)	/ECRS/TPCI
4	.INCLUDE	☐				0	0	Default Values for Worklist Import - Data
5	RPCTI	☐	/ECRS/RPCTI	/ECRS/RPCTI	CHAR	2	0	Country of Declaration (ISO Code)	/ECRS/TRPC
6	.INCLUDE	☐				0	0	Default Values for Worklist Import - Default Values
7	BTTYP	☐	/ECRS/BTTYP	/ECRS/BTTYP	CHAR	2	0	Business Transaction Type (Intrastat Code)	/ECRS/TBTT
8	PRCDR	☐	/ECRS/PRCDR	/ECRS/PRCDR	CHAR	5	0	Procedure (Intrastat Code)	/ECRS/TPRC
9	MOTAB	☐	/ECRS/MOTAB	/ECRS/MOTAB	CHAR	1	0	Mode of Transport at the Border (Intrastat Code)	/ECRS/TMOT
10	NAOTV	☐	/ECRS/NAOTV	LAND1	CHAR	3	0	Country of Means of Transport	T005
11	INCOI	☐	/ECRS/INCOI	/ECRS/INCOI	CHAR	3	0	Incoterms (Intrastat Code)	/ECRS/TINC
12	REGIN	☐	/ECRS/REGIN	/ECRS/REGIN	CHAR	3	0	Region in Country of Declaration (Intrastat Code)	/ECRS/TRGI
13	CTOOI	☐	/ECRS/CTOOI	/ECRS/CTOOI	CHAR	2	0	Country of Origin (Intrastat Code)	/ECRS/TRCO
14	PORTI	☐	/ECRS/PORTI	/ECRS/PORTI	CHAR	4	0	Port/Airport (Intrastat Code)	/ECRS/TPRT
15	SPMCO	☐	/ECRS/SPMCO	/ECRS/SPMCO	CHAR	2	0	Special Movement Code (Intrastat Code)	/ECRS/TSMC
16	.INCLUDE	☐				0	0	Administrative Data: Created by, Changed by, Time Stamp
17	CRTBY	☐	/ECRS/CRTBY	XUBNAME	CHAR	12	0	Name of User Who Added Object	USR02
18	CRTTS	☐	/ECRS/CRTTS	TZNTSTMPS	DEC	15	0	UTC Time Stamp When Object Was Added
19	LCHBY	☐	/ECRS/LCHBY	XUBNAME	CHAR	12	0	Name of User Who Changed Object	USR02
20	LCHTS	☐	/ECRS/LCHTS	TZNTSTMPS	DEC	15	0	UTC Time Stamp When Object Was Changed
21	CRTON	☐	/ECRS/CRTON	DATS	DATS	8	0	Date When the Object Was Created
22	CRTAT	☐	/ECRS/CRTAT	UZEIT	TIMS	6	0	Time Object Was Added
23	LCHON	☐	/ECRS/LCHON	DATS	DATS	8	0	Date When Object Was Changed
24	LCHAT	☐	/ECRS/LCHAT	UZEIT	TIMS	6	0	Time When Object Was Changed
25	DIREC_TXT	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
26	PTCTI_TXT	☐	LANDX50	TEXT50	CHAR	50	0	Country Name (Max. 50 Characters)
27	BTTYP_TXT	☐	/ECRS/BTTTX	TEXT60	CHAR	60	0	Name of Business Transaction Type
28	PRCDR_TXT	☐	/ECRS/PRCTX	TEXT60	CHAR	60	0	Name of Procedure
29	MOTAB_TXT	☐	/ECRS/MOTTX	TEXT40	CHAR	40	0	Name of Mode of Transport at the Border
30	INCOI_TXT	☐	/ECRS/INCTX	TEXT40	CHAR	40	0	Name of Incoterms
31	REGIN_TXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
32	CTOOI_TXT	☐	LANDX50	TEXT50	CHAR	50	0	Country Name (Max. 50 Characters)
33	PORTI_TXT	☐	/ECRS/PRTTX	TEXT40	CHAR	40	0	Name of Port/Airport
34	SPMCO_TXT	☐	/ECRS/SMCTX	TEXT40	CHAR	40	0	Name of Special Movement Code
35	RPCTI_TXT	☐	/ECRS/RPCTX	TEXT40	CHAR	40	0	Name of Country of Declaration
36	NAOTV_TXT	☐	/ECRS/NTVTX	TEXT50	CHAR	50	0	Name of Country of Means of Transport

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ECRS/UI_MD_DW_300_S	CRTBY	USR02	BNAME	KEY	1	CN
2	/ECRS/UI_MD_DW_300_S	LCHBY	USR02	BNAME	KEY	1	CN
3	/ECRS/UI_MD_DW_300_S	NAOTV	T005	LAND1
4	/ECRS/UI_MD_DW_300_S	PORTI	/ECRS/TPRT	RPCTI	KEY	1	CN
5	/ECRS/UI_MD_DW_300_S	PRCDR	/ECRS/TPRC	RPCTI	KEY	1	CN
6	/ECRS/UI_MD_DW_300_S	PTCTI	/ECRS/TPCI	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20141106
SAP Release Created in