SAP ABAP Table P0845 (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	INTTAB	Structure
Structure	P0845	Table Relationship Diagram
Short Description	Work Relationships

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	.INCLUDE	☐				0	0	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	Work Relationships
28	RGRND	☐	PDE_PBSVAVG_ERST_RGRND	PDE_PBSVAVG_ERST_RGRND	CHAR	2	0	Legal Basis for Reimbursements	T7DEPBSVAVG05
29	TRGER	☐	PDE_PBSVAVG_FRUEHERE_DIENSTH	CHAR2	CHAR	2	0	Previous Public Sector Employer
30	TRFAR	☐	TRFAR	TRFAR	CHAR	2	0	Pay scale type	T510A
31	TRFGB	☐	TRFGB	TRFGB	CHAR	2	0	Pay Scale Area	T510G
32	TRFGR	☐	TRFGR	TRFGR	CHAR	8	0	Pay Scale Group	T510
33	TRFST	☐	TRFST	TRFST	CHAR	2	0	Pay Scale Level	T510
34	REFNR	☐	PDE_PBSVAVG_ERST_REFNR		CHAR	2	0	Reference Number for Uniqueness from Infotype 0845
35	ERH_ABFINDUNG	☐	PDE_PBS_VLTSV_ERHALT_ABFINDUNG	P_AMT07V	CURR	13	2	Received Severance Pay
36	ERH_ABF_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	T500W
37	ERH_ABF_EINGANG	☐	PDE_PBS_VLTSV_DATE_ERH_ABF	DATUM	DATS	8	0	Incoming Payments of Received Severance Payment
38	DH_FRUEHER	☐	PDE_PBS_VLTSV_FRUEHERER_DH	ANSSL	CHAR	8	0	Previous Public Sector Employer	T536C
39	DH_NEU	☐	PDE_PBS_VLTSV_P10_DH_NEU	ANSSL	CHAR	8	0	New Public Sector Employer	T536C
40	ART	☐	PDE_PBS_VLTSV_P10_ART	PDE_PBS_VLTSV_P10_ART	NUMC	1	0	Own Role Regarding Change of Public Sector Employer
41	AZ_ERST_P10	☐	PDE_PBS_VLTSV_P10_AZ	TEXT20	CHAR	20	0	Case Number
42	BETRG_ERST_P10	☐	PDE_PBS_VLTSV_P10_ERSTBETRG	BETRG	CURR	9	2	Stipulated Reimbursement Amount
43	ERST_TYP	☐	PDE_PBS_VLTSV_P10_SUBTY_ERST	SUBTY_591A	CHAR	4	0	Subtype of Reimbursement	T591A
44	.INCLUDE	☐				0	0

Foreign Keys

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

History

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