SAP ABAP Table PA0100 (HR Master Record: Infotype 0100 (SI B))

Hierarchy

☛ SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
   ⤷ PA-PA-BE (Application Component) Belgium
     ⤷ PB12 (Package) HR Master Data: Belgium

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0100	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0100 (SI B)

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key for HR Master Data
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
4	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
5	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
6	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
9	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
10	.INCLUDE	☐				0	0	HR Master Record: Control Field
11	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
14	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
15	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
16	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
17	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
18	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
19	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
24	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
26	.INCLUDE	☐				0	0	HR Master Record: Infotype 0100 (Social Insurance B)
27	RSZSP	☐	RSZSP	RSZSP	CHAR	2	0	Employee specification	T5B03
28	RSZNO	☐	RSZNO	RSZNO	CHAR	1	0	Employee notification (00053)	T5B04
29	RSZKE	☐	RSZKE	RSZKE	NUMC	3	0	Profession group	T5B07
30	RSZCA	☐	RSZCA	RSZCA	CHAR	3	0	Employer class (SI employer category)	T5B02
31	RSZKN	☐	RSZKN	RSZKN	CHAR	3	0	Worker code (SI employee category)	T5B01
32	RSZFF	☐	RSZFF	RSZFF	CHAR	2	0	SI Position Code (00057)	T5B05
33	RSZLM	☐	RSZLM	XFELD	CHAR	1	0	Wage reduction
34	RSZFS	☐	RSZFS	P12_RSZFS	CHAR	2	0	Factory shutdown fund	*
35	RSZRR	☐	RSZRR	NUM11	NUMC	11	0	INSS - National ID number (00024)
36	RSZPN	☐	RSZPN	CHAR10	CHAR	10	0	Pension number
37	RSZVW	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
38	RSZGL	☐	RSZGL	RSZLD	CHAR	4	0	Place/country of birth (00169)	T5B0F
39	RSZBL	☐	RSZBL	RSZLD	CHAR	4	0	Obsolete: SI/Belcotax country	T5B0F
40	RSZNA	☐	RSZNA	RSZNA	CHAR	1	0	Obsolete: SI Nationality	T5B08
41	RSZWG	☐	RSZWG	RSZWG	CHAR	2	0	SI contribution reduction	T5B09
42	RSZLA	☐	RSZLA	SPRAS	LANG	1	0	Official language	T002
43	EMPLP	☐	P12_EMPLPROM	P12_EMPLPROM	NUMC	3	0	Employment promotion measure (00052)
44	APTYP	☐	P12_APPRTYPE	P12_APPRTYPE	NUMC	1	0	Apprenticeship type (00055)
45	RETIR	☐	P12_RETIRED	P12_RETIRED	CHAR	1	0	Retired (00054)
46	RSKAC	☐	P12_RISKACT	P12_ACTCODE	NUMC	3	0	Activity with risk (00041)	*
47	MODRM	☐	P12_MODEREM	P12_MODEREM	NUMC	1	0	Remuneration method (00056)
48	REDST	☐	P12_REDSTART	DATUM	DATS	8	0	Start date for for employer's deduction (00090)
49	OSSIN	☐	P12_ORIGPERNR	PERNR	NUMC	8	0	Social security number of replaced worker (00092)
50	OREDD	☐	P12_ORIGREDD	DATUM	DATS	8	0	Begin date of reduction for replaced worker
51	ASSIN	☐	P12_APPLPERNR	PERNR	NUMC	8	0	Social security ID number of applicant (00093)
52	CORIG	☐	P12_CERTORIG	P12_CERTORIG	NUMC	3	0	Place of issue of certificate (00094)
53	ALLCD	☐	P12_ALLCD	RSZWG	CHAR	2	0	Allowance code	T5B09
54	ALLST	☐	P12_ALLST	DATUM	DATS	8	0	Allowance start date
55	EERST	☐	P12_EE_RED_START	P12_EE_RED_START	DATS	8	0	Start date for employee's restructuration reduction
56	MARBR	☐	P12_MARIBEL	P12_MARIBEL	NUMC	2	0	DMFA: Social Maribel (00794)
57	OLDRR	☐	OLDRR	NUM11	NUMC	11	0	Old national ID number
58	CAPEX	☐	P12_CAPELO_EXEMPTED	P12_CAPELO_EXEMPTED	CHAR	1	0	Capelo Eligibility (01012)
59	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0100	ALLCD	T5B09	RSZWG	KEY	1	CN
2	PA0100	MANDT	T000	MANDT	KEY	1	CN
3	PA0100	PERNR	PA0003	PERNR	KEY	1	CN
4	PA0100	PREAS	T530E	PREAS	REF	C	CN
5	PA0100	RSZBL	T5B0F	BELDK	REF	C	CN
6	PA0100	RSZCA	T5B02	RSZCA	REF	C	CN
7	PA0100	RSZFF	T5B05	RSZFF	REF	C	CN
8	PA0100	RSZGL	T5B0F	BELDK	REF	C	CN
9	PA0100	RSZKE	T5B07	RSZKE
10	PA0100	RSZKN	T5B01	RSZKN	REF	C	CN
11	PA0100	RSZLA	T002	SPRAS	REF	C	CN
12	PA0100	RSZNA	T5B08	BENAT	REF	C	CN
13	PA0100	RSZNO	T5B04	RSZNO	REF	C	CN
14	PA0100	RSZSP	T5B03	RSZSP	REF	C	CN
15	PA0100	RSZWG	T5B09	RSZWG	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in