SAP ABAP Table /ECRS/UI_EDIT_POI_DETAIL_S (Provider of Information: Detailed Data)

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_EDIT_POI_DETAIL_S	Table Relationship Diagram
Short Description	Provider of Information: Detailed Data

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	Provider of Information - Key w/o Client
2	POIID	☐	/ECRS/POIID	/ECRS/POIID	CHAR	10	0	Provider of Information ID	*
3	.INCLUDE	☐				0	0	Provider of Information - Data
4	RPCTI	☐	/ECRS/RPCTI	/ECRS/RPCTI	CHAR	2	0	Country of Declaration (ISO Code)	/ECRS/TRPC
5	.INCLUDE	☐				0	0	Provider of Information - Basic Data
6	POIVA	☐	/ECRS/POIVA	/ECRS/VATID	CHAR	20	0	VAT Registration Number of Provider of Information
7	POIAD	☐	/ECRS/POIAD	/ECRS/ADDNR	CHAR	5	0	Additional Number of Provider of Information
8	RPCUR	☐	/ECRS/RPCUR	WAERS	CUKY	5	0	Key of Declaration Currency	TCURC
9	EXCHT	☐	/ECRS/EXCHT	KURST	CHAR	4	0	Exchange Rate Type for Currency Translation	TCURV
10	RPLE1	☐	/ECRS/RPLE1	/ECRS/RPLEV	CHAR	1	0	Received Declaration Level	/ECRS/TRPL
11	RPLE2	☐	/ECRS/RPLE2	/ECRS/RPLEV	CHAR	1	0	Dispatch Declaration Level	/ECRS/TRPL
12	GFFID	☐	/ECRS/GFFID	/ECRS/GFFID	NUMC	2	0	Format of Declaration File	/ECRS/TGFC
13	.INCLUDE	☐				0	0	Provider of Information - Variable Data
14	COLCE	☐	/ECRS/COLCE	/ECRS/COLCE	CHAR	20	0	Collection Center (Intrastat Code)	/ECRS/TCCE
15	FDTOF	☐	/ECRS/FDTOF	/ECRS/FDTOF	CHAR	2	0	State of Tax Office
16	STENR	☐	/ECRS/STENR	/ECRS/STENR	CHAR	11	0	Tax Number
17	MTNUM	☐	/ECRS/MTNUM	CHAR6	CHAR	6	0	Material Number of Receipt (Fed. Statistics Office, Germany)
18	MTNU2	☐	/ECRS/MTNU2	CHAR6	CHAR	6	0	Material Number of Shipment (Fed. Stat. Office, Germany)
19	AUTNR	☐	/ECRS/AUTNR	CHAR4	CHAR	4	0	Authorization Number
20	AUTCO	☐	/ECRS/AUTCO	CHAR8	CHAR	8	0	Authentication Code
21	REGNR	☐	/ECRS/REGNR	CHAR3	CHAR	3	0	Registration Number
22	REGON	☐	/ECRS/REGON	CHAR14	CHAR	14	0	Registration Number (REGON, Poland)
23	KFFLN	☐	/ECRS/KFFLN	XFELD	CHAR	1	0	Flag: Generate Header in Declaration File
24	.INCLUDE	☐				0	0	Provider of Information - Address Data
25	POINA	☐	/ECRS/POINA	TEXT35	CHAR	35	0	Name of Provider of Information
26	POISN	☐	/ECRS/POISN	TEXT35	CHAR	35	0	Street/House Number of Provider of Information
27	POIPC	☐	/ECRS/POIPC	CHAR10	CHAR	10	0	Postal Code of Provider of Information
28	POICI	☐	/ECRS/POICI	TEXT35	CHAR	35	0	City of Provider of Information
29	POIPN	☐	/ECRS/POIPN	CHAR30	CHAR	30	0	Telephone Number of Provider of Information
30	POIFN	☐	/ECRS/POIFN	CHAR30	CHAR	30	0	Fax Number of Provider of Information
31	.INCLUDE	☐				0	0	Provider of Information - Contact Person
32	CPNAM	☐	/ECRS/CPNAM	TEXT35	CHAR	35	0	Name of Contact Person
33	CP_NAMLAST	☐	NAME_LAST	TEXT40	CHAR	40	0	Last name
34	CP_NAMFIRST	☐	NAME_FIRST	TEXT40	CHAR	40	0	First name
35	CPSTN	☐	/ECRS/CPSTN	TEXT35	CHAR	35	0	Street/House Number of Contact Person
36	CPPOC	☐	/ECRS/CPPOC	CHAR10	CHAR	10	0	Postal Code of Contact Person
37	CPCIT	☐	/ECRS/CPCIT	TEXT35	CHAR	35	0	Location of Contact Person
38	CPPHO	☐	/ECRS/CPPHO	CHAR30	CHAR	30	0	Contact Person: Telephone Number
39	CPMPN	☐	/ECRS/CPMPN	CHAR30	CHAR	30	0	Mobile Phone Number of Contact Person
40	CPFAX	☐	/ECRS/CPFAX	CHAR30	CHAR	30	0	Fax Number of Contact Person
41	CPEML	☐	/ECRS/CPEML	TEXT70	CHAR	70	0	e-Mail Address of Contact Person
42	CPPOS	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	*
43	.INCLUDE	☐				0	0	Administrative Data: Created by, Changed by, Time Stamp
44	CRTBY	☐	/ECRS/CRTBY	XUBNAME	CHAR	12	0	Name of User Who Added Object	USR02
45	CRTTS	☐	/ECRS/CRTTS	TZNTSTMPS	DEC	15	0	UTC Time Stamp When Object Was Added
46	LCHBY	☐	/ECRS/LCHBY	XUBNAME	CHAR	12	0	Name of User Who Changed Object	USR02
47	LCHTS	☐	/ECRS/LCHTS	TZNTSTMPS	DEC	15	0	UTC Time Stamp When Object Was Changed
48	RPCTI_TXT	☐	/ECRS/RPCTX	TEXT40	CHAR	40	0	Name of Country of Declaration
49	FDTOF_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
50	EXCHT_TXT	☐	CURVW	TEXT40	CHAR	40	0	Exchange rate type usage
51	RPLE1_TXT	☐	/ECRS/RPLT1	TEXT40	CHAR	40	0	Name of Received Declaration Level
52	RPLE2_TXT	☐	/ECRS/RPLT2	TEXT40	CHAR	40	0	Name of Dispatch Declaration Level
53	RPCUR_TXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
54	COLCE_TXT	☐	/ECRS/CCETX	TEXT40	CHAR	40	0	Name of Collection Center
55	GFFID_TXT	☐	/ECRS/GFFTX	TEXT40	CHAR	40	0	Name of Format of Declaration File
56	CRTON	☐	/ECRS/CRTON	DATS	DATS	8	0	Date When the Object Was Created
57	CRTAT	☐	/ECRS/CRTAT	UZEIT	TIMS	6	0	Time Object Was Added
58	LCHON	☐	/ECRS/LCHON	DATS	DATS	8	0	Date When Object Was Changed
59	LCHAT	☐	/ECRS/LCHAT	UZEIT	TIMS	6	0	Time When Object Was Changed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ECRS/UI_EDIT_POI_DETAIL_S	CRTBY	USR02	BNAME	KEY	1	CN
2	/ECRS/UI_EDIT_POI_DETAIL_S	EXCHT	TCURV	KURST	KEY	1	CN
3	/ECRS/UI_EDIT_POI_DETAIL_S	GFFID	/ECRS/TGFC	RPCTI	KEY	1	CN
4	/ECRS/UI_EDIT_POI_DETAIL_S	LCHBY	USR02	BNAME	KEY	1	CN
5	/ECRS/UI_EDIT_POI_DETAIL_S	RPCUR	TCURC	WAERS	KEY	1	CN
6	/ECRS/UI_EDIT_POI_DETAIL_S	RPLE1	/ECRS/TRPL	DIREC	KEY
7	/ECRS/UI_EDIT_POI_DETAIL_S	RPLE2	/ECRS/TRPL	DIREC	KEY	1	CN

History

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