SAP ABAP Table P20_ALTINN2_ERC (ERC Cluster for Altinn-2)

Hierarchy

☛ SAP_HRCNO (Software Component) Sub component SAP_HRCNO of SAP_HR
   ⤷ PY-NO (Application Component) Norway
     ⤷ PC20 (Package) HR accounting: Norway

Basic Data

Table Category	INTTAB	Structure
Structure	P20_ALTINN2_ERC	Table Relationship Diagram
Short Description	ERC Cluster for Altinn-2

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	RKEY	☐	P20_ALTINN2_KEY		STRU	0	0
2	TERMIN	☐	P20_TERM	P20_TERM	NUMC	1	0	Period
3	TYEAR	☐	P20_ERAAR	P20_AAR	NUMC	4	0	Year of reporting
4	REPNR	☐	P20_REPNR	P20_REPNR	NUMC	11	0	Organizations number used for tax and ERC reporting
5	SEQNR	☐	NUMC2	NUMC2	NUMC	2	0	Two digit number
6	ERC	☐	P20_ALTINN_DETAILS		STRU	0	0
7	GENRAL_INFO	☐	P20_GENRAL_INFO		STRU	0	0
8	TERMIN	☐	P20_TERM	P20_TERM	NUMC	1	0	Period
9	ERYEAR	☐	P20_ERAAR	P20_AAR	NUMC	4	0	Year of reporting
10	EMPR_MUNICC	☐	P20_MUNICC	P20_MUNIC	CHAR	4	0	Municipality Number
11	REPNR	☐	P20_REPNR	P20_REPNR	NUMC	11	0	Organizations number used for tax and ERC reporting
12	EMPR_MUNICC_NAME	☐	P20_NAVN	TEXT20	CHAR	20	0	Municipality name
13	ALTIN_STAT	☐	P20_RUN_STATUS	P20_RUN_STATUS	CHAR	1	0	Status for Altinn run
14	SPECIAL_GRPS	☐	P20_SPECIAL_GRPS		STRU	0	0
15	STATS	☐	P20_STATS	P20_STATS	CHAR	2	0	Company status regarding branch and employers contribution
16	RBUNF	☐	P20_BUNF_USED	CHAR012	CHAR	12	0	Used amount of "Bunnfradraget" in particular Termin
17	TILS	☐	P20_ALT_TILS	CHAR12	CHAR	12	0	Tils Amount Reported to Altinn
18	UTL1_ERC_BASIS	☐	P20_UTL1_ERC_BASIS	CHAR012	CHAR	12	0	Contribution basis (Workers from USA and Canada)
19	UTL1_CALC_ERC	☐	P20_UTL1_CALC_ERC	CHAR012	CHAR	12	0	Calculated Contribution (Workers from USA and Canada)
20	UTL2_MONTHS	☐	P20_UTL2_MONTHS	CHAR012	CHAR	12	0	Number of months (Some Seamen)
21	UTL2_RATE	☐	ABRWT	DEC7_2	DEC	9	2	Value of payroll constants
22	ERC_TAB	☐	P20_ERC_TAB		TTYP	0	0
23	TAX_TAB	☐	P20_TAX_TAB		TTYP	0	0
24	RESULT_SUM	☐	P20_RESULT		STRU	0	0
25	SUM_ERCBASIS_NOR	☐	P20_SUM_ERBAS_NOR	CHAR012	CHAR	12	0	Sum Contribution Basis Employees Under 62 Years
26	SUM_REIM	☐	P20_REIM	CHAR12	CHAR	12	0	Reimbursment Amount Submitted to Altinn
27	SUM_PENS	☐	P20_PENS	CHAR12	CHAR	12	0	Pension Amount Submitted to Altinn
28	REST_BUNDFRAG	☐	P20_BUDFRAG	CHAR012	CHAR	12	0	Remaining Bundfradrag
29	SUM_ERC	☐	P20_ERBAS_SUM	CHAR012	CHAR	12	0	Sum of employers contribution
30	SUM_ADTAX	☐	P20_ADTAX_SUM	CHAR012	CHAR	12	0	Sum of Tax paid by Employer.
31	BATCH	☐	P20_ALTINN_HEADER		STRU	0	0
32	BATCH_ID	☐	P20_BATCH_ID	CHAR18	CHAR	18	0	Batch ID
33	ENTSY_ID	☐	P20_ENTERP_ID	NUMC10	NUMC	10	0	Enterprise System ID
34	PASSWORD	☐	P20_PASSWORD	CHARALT	CHAR	15	0	Password
35	PARTICI_ID	☐	P20_PARTICI_ID	NUMC11	NUMC	11	0	Organization Number
36	SENDERS_REF	☐	P20_SENDERS_REF	CHAR020	CHAR	20	0	Senders Reference unique in System
37	COMPLETED	☐	P20_COMPLETED	INT1	INT1	3	0	Flag that Controls data to be send to Workflow
38	LOCKED	☐	P20_LOCKED	INT1	INT1	3	0	Flag Controling whether data can be edited in Altinn or not
39	SVAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox

History

Last changed by/on	SAP	20130529
SAP Release Created in