SAP ABAP Table PC280 (Social Insurance payroll Belgium)

Hierarchy

☛ SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
   ⤷ PY-BE (Application Component) Belgium
     ⤷ PC12 (Package) HR accounting: Belgium

Basic Data

Table Category	INTTAB	Structure
Structure	PC280	Table Relationship Diagram
Short Description	Social Insurance payroll Belgium

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	CNTR1	☐	CNTRN	RAW1	RAW	1	0	National assignment indicator
2	CNTR2	☐	CNTRN	RAW1	RAW	1	0	National assignment indicator
3	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
4	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
5	ANSTA	☐	ANSTA	NUM1	NUMC	1	0	Employment status
6	JUPER	☐	JUPER	JUPER	CHAR	4	0	Legal Person
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
9	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
10	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
11	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
12	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
13	ENTKM	☐	ENTKM	DEC3	DEC	3	0	Distance in Kilometers
14	WKWNG	☐	WKWNG	CHAR1	CHAR	1	0	Company Housing
15	TEILK	☐	TEILK	XFELD	CHAR	1	0	Indicator Part-Time Employee
16	EMPCT	☐	EMPCT	BSGRD	DEC	5	2	Employment percentage
17	DYSCH	☐	DYSCH	XFELD	CHAR	1	0	Create Daily Work Schedule Dynamically
18	ZTERF	☐	PT_ZTERF	ZTERF	NUMC	1	0	Employee Time Management Status	T555V
19	SCHKZ	☐	SCHKN	SCHKN	CHAR	8	0	Work Schedule Rule	T508A
20	WOSTD	☐	WOSTD	STDAZ	DEC	5	2	Hours per week
21	MOSTD	☐	MOSTD	STDAZ	DEC	5	2	Monthly hours
22	ARBST	☐	STDTG	STDAZ	DEC	5	2	Daily Working Hours
23	BSGRD	☐	BSGRD	BSGRD	DEC	5	2	Capacity Utilization Level
24	BESTE	☐	BESTE	BESTE	CHAR	1	0	Frequency of payment	T5B71
25	BERGM	☐	BERGM	BERGM	CHAR	1	0	Weekly workdays schedule	T5B72
26	BEREG	☐	BEREG	BEREG	CHAR	1	0	Employment percentage	T5B73
27	CTTYP	☐	CTTYP	CTTYP	CHAR	2	0	Contract Type	T547V
28	ARBER	☐	ARBER	DATUM	DATS	8	0	Expiration Date of Work Permit
29	BEANC	☐	BEANC	DATUM	DATS	8	0	Seniority
30	BEAAN	☐	BEAAN	DEC3	DEC	3	0	Contract time amount
31	BETIM	☐	BETIM	CHAR3	CHAR	3	0	Contract period
32	BEGWU	☐	BEGWU	BETRG	CURR	9	2	Unemployment payment
33	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
34	BEUWG	☐	BEUWG	DEC3_2	DEC	5	2	Contractual Mean Working Hours per week
35	BECAO	☐	BECAO	BECAO	CHAR	4	0	Collective agreement	T5B6B
36	BEGPC	☐	BEGPC	BEGPC	CHAR	7	0	Joint Commission (00046)	T5B6C
37	BECNR	☐	BECNR	CHAR15	CHAR	15	0	Contract number
38	BEMCH	☐	BEMCH	CHAR1	CHAR	1	0	Meal voucher
39	BEGFB	☐	BEGFB	XFELD	CHAR	1	0	Early retirement with fixed compensation
40	BEGGH	☐	BEGGH	XFELD	CHAR	1	0	Entitled family member
41	BREGM	☐	BREGM	CHAR2	CHAR	2	0	Regulation contract months per year
42	RSZBL	☐	RSZBL	RSZLD	CHAR	4	0	Obsolete: SI/Belcotax country	T5B0F
43	RSZGL	☐	RSZGL	RSZLD	CHAR	4	0	Place/country of birth (00169)	T5B0F
44	RSZKE	☐	RSZKE	RSZKE	NUMC	3	0	Profession group	T5B07
45	RSZNA	☐	RSZNA	RSZNA	CHAR	1	0	Obsolete: SI Nationality	T5B08
46	RSZPN	☐	RSZPN	CHAR10	CHAR	10	0	Pension number
47	RSZRR	☐	RSZRR	NUM11	NUMC	11	0	INSS - National ID number (00024)
48	RSZVW	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
49	RSZCA	☐	RSZCA	RSZCA	CHAR	3	0	Employer class (SI employer category)	T5B02
50	RSZFF	☐	RSZFF	RSZFF	CHAR	2	0	SI Position Code (00057)	T5B05
51	RSZFS	☐	RSZFS	P12_RSZFS	CHAR	2	0	Factory shutdown fund	*
52	RSZKN	☐	RSZKN	RSZKN	CHAR	3	0	Worker code (SI employee category)	T5B01
53	RSZLM	☐	RSZLM	XFELD	CHAR	1	0	Wage reduction
54	RSZNO	☐	RSZNO	RSZNO	CHAR	1	0	Employee notification (00053)	T5B04
55	RSZSP	☐	RSZSP	RSZSP	CHAR	2	0	Employee specification	T5B03
56	RSZWG	☐	RSZWG	RSZWG	CHAR	2	0	SI contribution reduction	T5B09
57	BVETL	☐	BVETL	CHAR001	CHAR	1	0	Conversion flag
58	BVFAM	☐	BVFAM	BVFAM	CHAR	1	0	Marital status	T5B14
59	BVEKI	☐	BVEKI	P12_CHARN3	CHAR	1	0	Partner's income
60	FIXVA	☐	P12_WREFV	P12_WREFV	CHAR	1	0	Workdays system
61	PPAID	☐	P12_PPAID	DEC3_2	DEC	5	2	Percentage of remuneration on a yearly basis
62	BEUW2	☐	P12_BEUW2	DEC3_2	DEC	5	2	Mean number of hours per week
63	REMES	☐	P12_REMES	P12_REMES	NUMC	3	0	Reorganization measure
64	EMPLP	☐	P12_EMPLPROM	P12_EMPLPROM	NUMC	3	0	Employment promotion measure (00052)
65	APTYP	☐	P12_APPRTYPE	P12_APPRTYPE	NUMC	1	0	Apprenticeship type (00055)
66	RETIR	☐	P12_RETIRED	P12_RETIRED	CHAR	1	0	Retired (00054)
67	MODRM	☐	P12_MODEREM	P12_MODEREM	NUMC	1	0	Remuneration method (00056)
68	REDST	☐	P12_REDSTART	DATUM	DATS	8	0	Start date for for employer's deduction (00090)
69	OSSIN	☐	P12_ORIGPERNR	PERNR	NUMC	8	0	Social security number of replaced worker (00092)
70	OREDD	☐	P12_ORIGREDD	DATUM	DATS	8	0	Begin date of reduction for replaced worker
71	ASSIN	☐	P12_APPLPERNR	PERNR	NUMC	8	0	Social security ID number of applicant (00093)
72	CORIG	☐	P12_CERTORIG	P12_CERTORIG	NUMC	3	0	Place of issue of certificate (00094)
73	RFSCH	☐	P12_REFPERS_WSCHED	SCHKN	CHAR	8	0	Reference person's working schedule	*
74	LOCUN	☐	P12_LOCUN	NUM10	NUMC	10	0	Local unit ID
75	RSKAC	☐	P12_RISKACT	P12_ACTCODE	NUMC	3	0	Activity with risk (00041)	*
76	ALLCD	☐	P12_ALLCD	RSZWG	CHAR	2	0	Allowance code	*
77	ALLST	☐	P12_ALLST	DATUM	DATS	8	0	Allowance start date
78	BVCOA	☐	P12_BVCOA	XFELD	CHAR	1	0	Legal cohabitation
79	MARBR	☐	P12_MARIBEL	P12_MARIBEL	NUMC	2	0	DMFA: Social Maribel (00794)
80	NACEC	☐	P12P_ONSSAPLCODE76	P12P_ONSSAPLCODE76	NUMC	5	0	Employee Activity Code (NACE) (00228)	*
81	OLDRR	☐	OLDRR	NUM11	NUMC	11	0	Old national ID number
82	EERST	☐	P12_EE_RED_START	P12_EE_RED_START	DATS	8	0	Start date for employee's restructuration reduction
83	RDCST	☐	P12_RED_CONT_START	DATUM	DATS	8	0	Reduced SI contibution start date
84	REMTY	☐	P12_REMES_TYPE	P12_REMES_TYPE	CHAR	2	0	Reorganization measure type
85	CAPEX	☐	P12_CAPELO_EXEMPTED	P12_CAPELO_EXEMPTED	CHAR	1	0	Capelo Eligibility (01012)
86	DISPD	☐	P12_DISPD	XFELD	CHAR	1	0	Dismissal period
87	CFWPT	☐	P12_CFWPT	NUMC1	NUMC	1	0	Counter Former Work Placement Trainee

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PC280	BECAO	T5B6B	BECAO
2	PC280	BEGPC	T5B6C	BEGPC
3	PC280	BEREG	T5B73	BEREG	KEY	1	CN
4	PC280	BERGM	T5B72	BERGM	KEY	1	CN
5	PC280	BESTE	T5B71	BESTE	KEY	1	CN
6	PC280	BTRTL	T001P	BTRTL	KEY	1	CN
7	PC280	BUKRS	T001	BUKRS	KEY	1	CN
8	PC280	BVFAM	T5B14	BVFAM	KEY	1	CN
9	PC280	CTTYP	T547V	CTTYP	KEY	1	CN
10	PC280	PERSG	T501	PERSG	KEY	1	CN
11	PC280	PERSK	T503K	PERSK	KEY	1	CN
12	PC280	RSZBL	T5B0F	BELDK	KEY	1	CN
13	PC280	RSZCA	T5B02	RSZCA	KEY	1	CN
14	PC280	RSZFF	T5B05	RSZFF	KEY	1	CN
15	PC280	RSZGL	T5B0F	BELDK	KEY	1	CN
16	PC280	RSZKE	T5B07	RSZKE	KEY	1	CN
17	PC280	RSZKN	T5B01	RSZKN	KEY	1	CN
18	PC280	RSZNA	T5B08	BENAT	KEY	1	CN
19	PC280	RSZNO	T5B04	RSZNO	KEY	1	CN
20	PC280	RSZSP	T5B03	RSZSP	KEY	1	CN
21	PC280	RSZWG	T5B09	RSZWG	KEY	1	CN
22	PC280	SCHKZ	T508A	SCHKZ
23	PC280	WAERS	TCURC	WAERS
24	PC280	WERKS	T500P	PERSA	KEY	1	CN
25	PC280	ZTERF	T555V	ZTERF	KEY	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in