SAP ABAP Table PA0845 (HR Master Record Infotype 0845 (Work Relationships))

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE-PS-VA (Application Component) Pension Administration
     ⤷ P01PBSVAVG_DDIC (Package) HR-VADM: Public Sector Pensions Act (DDIC, User Interface)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0845	Table Relationship Diagram
Short Description	HR Master Record Infotype 0845 (Work Relationships)

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	Work Relationships
27	RGRND	☐	PDE_PBSVAVG_ERST_RGRND	PDE_PBSVAVG_ERST_RGRND	CHAR	2	0	Legal Basis for Reimbursements	*
28	TRGER	☐	PDE_PBSVAVG_FRUEHERE_DIENSTH	CHAR2	CHAR	2	0	Previous Public Sector Employer
29	TRFAR	☐	TRFAR	TRFAR	CHAR	2	0	Pay scale type	T510A
30	TRFGB	☐	TRFGB	TRFGB	CHAR	2	0	Pay Scale Area	T510G
31	TRFGR	☐	TRFGR	TRFGR	CHAR	8	0	Pay Scale Group	T510
32	TRFST	☐	TRFST	TRFST	CHAR	2	0	Pay Scale Level	T510
33	REFNR	☐	PDE_PBSVAVG_ERST_REFNR		CHAR	2	0	Reference Number for Uniqueness from Infotype 0845
34	ERH_ABFINDUNG	☐	PDE_PBS_VLTSV_ERHALT_ABFINDUNG	P_AMT07V	CURR	13	2	Received Severance Pay
35	ERH_ABF_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	T500W
36	ERH_ABF_EINGANG	☐	PDE_PBS_VLTSV_DATE_ERH_ABF	DATUM	DATS	8	0	Incoming Payments of Received Severance Payment
37	DH_FRUEHER	☐	PDE_PBS_VLTSV_FRUEHERER_DH	ANSSL	CHAR	8	0	Previous Public Sector Employer	T536C
38	DH_NEU	☐	PDE_PBS_VLTSV_P10_DH_NEU	ANSSL	CHAR	8	0	New Public Sector Employer	T536C
39	ART	☐	PDE_PBS_VLTSV_P10_ART	PDE_PBS_VLTSV_P10_ART	NUMC	1	0	Own Role Regarding Change of Public Sector Employer
40	AZ_ERST_P10	☐	PDE_PBS_VLTSV_P10_AZ	TEXT20	CHAR	20	0	Case Number
41	BETRG_ERST_P10	☐	PDE_PBS_VLTSV_P10_ERSTBETRG	BETRG	CURR	9	2	Stipulated Reimbursement Amount
42	ERST_TYP	☐	PDE_PBS_VLTSV_P10_SUBTY_ERST	SUBTY_591A	CHAR	4	0	Subtype of Reimbursement	T591A
43	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0845	DH_FRUEHER	T536C	ANKEY	KEY	1	CN
2	PA0845	DH_NEU	T536C	ANKEY	KEY	1	CN
3	PA0845	ERH_ABF_WAERS	T500W	WAERS
4	PA0845	ERST_TYP	T591A	SUBTY	KEY	1	CN
5	PA0845	PERNR	PA0003	PERNR
6	PA0845	PREAS	T530E	PREAS
7	PA0845	TRFAR	T510A	TRFAR
8	PA0845	TRFGB	T510G	TRFGB
9	PA0845	TRFGR	T510	TRFGR
10	PA0845	TRFST	T510	TRFST

History

Last changed by/on	SAP	20131127
SAP Release Created in	600