SAP ABAP Table PA0623 (HR Master Record: Infotype 0623)

Hierarchy

☛ SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
   ⤷ PY-BE-PS (Application Component) Öffentlicher Dienst
     ⤷ P12P1 (Package) Human Resources Belgium: Public Sector

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0623	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0623

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	*
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	Career History (Public Sector Belgium)
27	SECTOR	☐	P12P_SECTOR	SUBTY_591A	CHAR	4	0	Sector	T591A
28	EMPLOYER	☐	VORAG	TEXT60	CHAR	60	0	Name of employer
29	SERVICE	☐	P12P_SERVICE		CHAR	20	0	Service of Belgian Public Sector	*
30	CITY	☐	PAD_ORT01	PAD_ORT01	CHAR	40	0	City
31	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
32	WT_NOM	☐	P12P_NOM	P12P_FRACTION	DEC	4	2	Working time fraction (numerator)
33	WT_DENOM	☐	P12P_DENOM	P12P_FRACTION	DEC	4	2	Working time fraction (denominator)
34	STATUTE	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
35	GRADE	☐	P12P_DEGREE	P12P_DEGREE	NUMC	8	0	Grade ID	T5BPBS13G
36	PAYSCALE	☐	TRFGR	TRFGR	CHAR	8	0	Pay Scale Group	T5BPBS01
37	PSEN_Y	☐	P12P_PSEN_Y	P12P_SEN_Y	NUMC	2	0	Pay seniority (years)
38	PSEN_M	☐	P12P_PSEN_M	P12P_SEN_M	NUMC	2	0	Pay seniority (months)
39	SCSEN_Y	☐	P12P_SCSEN_Y	P12P_SEN_Y	NUMC	2	0	Scale seniority (years)
40	SCSEN_M	☐	P12P_SCSEN_M	P12P_SEN_M	NUMC	2	0	Scale seniority (months)
41	GRSEN_Y	☐	P12P_GRSEN_Y	P12P_SEN_Y	NUMC	2	0	Grade seniority (years)
42	GRSEN_M	☐	P12P_GRSEN_M	P12P_SEN_M	NUMC	2	0	Grade seniority (months)
43	SERSEN_Y	☐	P12P_SERSEN_Y	P12P_SEN_Y	NUMC	2	0	Service seniority (years)
44	SERSEN_M	☐	P12P_SERSEN_M	P12P_SEN_M	NUMC	2	0	Service seniority (months)
45	LSEN_Y	☐	P12P_LSEN_Y	P12P_SEN_Y	NUMC	2	0	Level seniority (years)
46	LSEN_M	☐	P12P_LSEN_M	P12P_SEN_M	NUMC	2	0	Level seniority (months)
47	ABS_TYPE	☐	AWART	AWART	CHAR	4	0	Attendance or Absence Type	T554S
48	COMM1	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
49	COMM2	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
50	COMM3	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
51	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0623	ABS_TYPE	T554S	SUBTY
2	PA0623	COUNTRY	T005	LAND1
3	PA0623	GRADE	T5BPBS13G	DEGID
4	PA0623	PAYSCALE	T5BPBS01	TRFGR
5	PA0623	PERNR	PA0003	PERNR
6	PA0623	PREAS	T530E	PREAS
7	PA0623	SECTOR	T591A	SUBTY
8	PA0623	STATUTE	T501	PERSG

History

Last changed by/on	SAP	20130529
SAP Release Created in	462A