SAP ABAP Table /ECRS/POIA (Provider of Information)

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/ECRS/POIA	Table Relationship Diagram
Short Description	Provider of Information

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

History

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