SAP ABAP Table /ECRS/UI_TD_RP_310_S (Create / Change / Display Intrastat Declaration: Item)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	/ECRS/UI_TD_RP_310_S	Table Relationship Diagram
Short Description	Create / Change / Display Intrastat Declaration: Item

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	Declaration Item Data for Transfer to UI
2	.INCLUDE	☐				0	0	Correction Item - Basic Data
3	.INCLUDE	☐				0	0	Correction Item - Main Basic Data
4	ITNUM	☐	/ECRS/ITNUM	/ECRS/ITNUM	NUMC	10	0	Item Number in Intrastat Declaration
5	RPCTI	☐	/ECRS/RPCTI	/ECRS/RPCTI	CHAR	2	0	Country of Declaration (ISO Code)	/ECRS/TRPC
6	DIREC	☐	/ECRS/DIREC	/ECRS/DIREC	CHAR	1	0	Direction (Receipt, Dispatch)
7	COYEA	☐	/ECRS/COYEA	/ECRS/CYEAR	NUMC	4	0	Declaration Year to Which Correction Refers
8	COMON	☐	/ECRS/COMON	/ECRS/MONTH	CHAR	2	0	Declaration Month to Which the Correction Refers
9	COPON	☐	/ECRS/COPON	/ECRS/COPON	CHAR	1	0	Correction Type
10	ITCPL	☐	/ECRS/ITCPL	XFELD	CHAR	1	0	Indicator: Item Is Correct
11	MANCF	☐	/ECRS/MANCF	XFELD	CHAR	1	0	Indicator: Item Was Created Manuall
12	.INCLUDE	☐				0	0	Declaration Item - Characteristics
13	BTTYP	☐	/ECRS/BTTYP	/ECRS/BTTYP	CHAR	2	0	Business Transaction Type (Intrastat Code)	/ECRS/TBTT
14	PRCDR	☐	/ECRS/PRCDR	/ECRS/PRCDR	CHAR	5	0	Procedure (Intrastat Code)	/ECRS/TPRC
15	COMCD	☐	/ECRS/COMCD	/ECRS/COMCD	CHAR	30	0	Commodity Code
16	PTCTI	☐	/ECRS/PTCTI	/ECRS/PTCTI	CHAR	2	0	Partner Country (Intrastat Code)	*
17	REGIN	☐	/ECRS/REGIN	/ECRS/REGIN	CHAR	3	0	Region in Country of Declaration (Intrastat Code)	/ECRS/TRGI
18	CTOOI	☐	/ECRS/CTOOI	/ECRS/CTOOI	CHAR	2	0	Country of Origin (Intrastat Code)	*
19	MOTAB	☐	/ECRS/MOTAB	/ECRS/MOTAB	CHAR	1	0	Mode of Transport at the Border (Intrastat Code)	/ECRS/TMOT
20	NAOTV	☐	/ECRS/NAOTV	LAND1	CHAR	3	0	Country of Means of Transport	T005
21	PORTI	☐	/ECRS/PORTI	/ECRS/PORTI	CHAR	4	0	Port/Airport (Intrastat Code)	/ECRS/TPRT
22	INCOI	☐	/ECRS/INCOI	/ECRS/INCOI	CHAR	3	0	Incoterms (Intrastat Code)	/ECRS/TINC
23	SPMCO	☐	/ECRS/SPMCO	/ECRS/SPMCO	CHAR	2	0	Special Movement Code (Intrastat Code)	/ECRS/TSMC
24	PTVAT	☐	/ECRS/PTVAT	/ECRS/VATID	CHAR	20	0	VAT Registration Number of Partner
25	.INCLUDE	☐				0	0	Declaration Item - Key Figures
26	INVAL	☐	/ECRS/INVAL	WERT15	CURR	15	2	Invoice Value
27	STVAL	☐	/ECRS/STVAL	WERT15	CURR	15	2	Statistical Value
28	RPCUR	☐	/ECRS/RPCUR	WAERS	CUKY	5	0	Key of Declaration Currency	TCURC
29	IFVAL	☐	/ECRS/IFVAL	WERT15	CURR	15	2	Invoice Value in Foreign Currency
30	FCCUR	☐	/ECRS/FCCUR	WAERS	CUKY	5	0	Key of Foreign Currency	TCURC
31	NTWEI	☐	/ECRS/NTWEI	MENG13	QUAN	13	3	Net Weight
32	KGUOM	☐	/ECRS/KGUOM	MEINS	UNIT	3	0	Unit of Measure for Kilograms	T006
33	SPQUA	☐	/ECRS/SPQUA	MENG13	QUAN	13	3	Quantity in Supplementary Unit
34	SPUOM	☐	/ECRS/SPUOM	MEINS	UNIT	3	0	Supplementary Unit	T006
35	.INCLUDE	☐				0	0	Additional Fields
36	ADDF1	☐	/ECRS/ADDF1	/ECRS/ADDF1	CHAR	5	0	Additional Field 1
37	ADDF2	☐	/ECRS/ADDF2	/ECRS/ADDF2	CHAR	10	0	Additional Field 2
38	ADDF3	☐	/ECRS/ADDF3	/ECRS/ADDF3	CHAR	15	0	Additional Field 3
39	.INCLUDE	☐				0	0	Administrative Data: Created by, Changed by, Time Stamp
40	CRTBY	☐	/ECRS/CRTBY	XUBNAME	CHAR	12	0	Name of User Who Added Object	USR02
41	CRTTS	☐	/ECRS/CRTTS	TZNTSTMPS	DEC	15	0	UTC Time Stamp When Object Was Added
42	LCHBY	☐	/ECRS/LCHBY	XUBNAME	CHAR	12	0	Name of User Who Changed Object	USR02
43	LCHTS	☐	/ECRS/LCHTS	TZNTSTMPS	DEC	15	0	UTC Time Stamp When Object Was Changed
44	CRTON	☐	/ECRS/CRTON	DATS	DATS	8	0	Date When the Object Was Created
45	CRTAT	☐	/ECRS/CRTAT	UZEIT	TIMS	6	0	Time Object Was Added
46	LCHON	☐	/ECRS/LCHON	DATS	DATS	8	0	Date When Object Was Changed
47	LCHAT	☐	/ECRS/LCHAT	UZEIT	TIMS	6	0	Time When Object Was Changed
48	SPMCO_TXT	☐	/ECRS/SMCTX	TEXT40	CHAR	40	0	Name of Special Movement Code
49	PRCDR_TXT	☐	/ECRS/PRCTX	TEXT60	CHAR	60	0	Name of Procedure
50	BTTYP_TXT	☐	/ECRS/BTTTX	TEXT60	CHAR	60	0	Name of Business Transaction Type
51	PTCTI_TXT	☐	/ECRS/RPCTX	TEXT40	CHAR	40	0	Name of Country of Declaration
52	COMCD_TXT	☐	TEXT240	TEXT240	CHAR	240	0	Text field of length 240
53	INCOI_TXT	☐	/ECRS/INCTX	TEXT40	CHAR	40	0	Name of Incoterms
54	NAOTV_TXT	☐	/ECRS/NTVTX	TEXT50	CHAR	50	0	Name of Country of Means of Transport
55	CTOOI_TXT	☐	/ECRS/COITX	TEXT40	CHAR	40	0	Name of Country of Origin
56	REGIN_TXT	☐	/ECRS/RGITX	TEXT40	CHAR	40	0	Name of Region
57	MOTAB_TXT	☐	/ECRS/MOTTX	TEXT40	CHAR	40	0	Name of Mode of Transport at the Border
58	RPCUR2	☐	/ECRS/RPCUR	WAERS	CUKY	5	0	Key of Declaration Currency	TCURC
59	PORTI_TXT	☐	/ECRS/PRTTX	TEXT40	CHAR	40	0	Name of Port/Airport
60	RPCTI_TXT	☐	/ECRS/RPCTX	TEXT40	CHAR	40	0	Name of Country of Declaration
61	SPUOM_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
62	KGUOM_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
63	COMON_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
64	COPON_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ECRS/UI_TD_RP_310_S	CRTBY	USR02	BNAME	KEY	1	CN
2	/ECRS/UI_TD_RP_310_S	FCCUR	TCURC	WAERS	KEY	1	CN
3	/ECRS/UI_TD_RP_310_S	KGUOM	T006	MSEHI	KEY	1	CN
4	/ECRS/UI_TD_RP_310_S	LCHBY	USR02	BNAME	KEY	1	CN
5	/ECRS/UI_TD_RP_310_S	NAOTV	T005	LAND1	KEY	1	CN
6	/ECRS/UI_TD_RP_310_S	PORTI	/ECRS/TPRT	RPCTI	KEY	1	CN
7	/ECRS/UI_TD_RP_310_S	PRCDR	/ECRS/TPRC	RPCTI	KEY	1	CN
8	/ECRS/UI_TD_RP_310_S	RPCUR	TCURC	WAERS	KEY	1	CN
9	/ECRS/UI_TD_RP_310_S	RPCUR2	TCURC	WAERS	KEY	1	CN
10	/ECRS/UI_TD_RP_310_S	SPUOM	T006	MSEHI	KEY	1	CN

History

Last changed by/on	SAP	20141106
SAP Release Created in	710