SAP ABAP Table /ECRS/POIA_S (Provider of Information - Data)

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

History

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