SAP ABAP Table P0861 (HR Master Record for Infotype 0861)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PY-XX-RS (Application Component) Reuse Services for Country Development
     ⤷ P99S (Package) Southern Europe Basis

Basic Data

Table Category	INTTAB	Structure
Structure	P0861	Table Relationship Diagram
Short Description	HR Master Record for Infotype 0861

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	Award Information
28	MOTIF	☐	P_99S_MOTIF	CHAR4	CHAR	4	0	Reason	T5F99A1
29	BEPRO	☐	P_99S_BEPRO	DATS	DATS	8	0	Award Proposal Date
30	AWADG	☐	P_99S_AWADG	CHAR4	CHAR	4	0	Award Group	T5F99A5
31	AWADT	☐	P_99S_AWADT	CHAR4	CHAR	4	0	Award Type	T5F99A0
32	AUTHO	☐	P_99S_AUTHO	CHAR4	CHAR	4	0	Authority	T5F99A2
33	COLLE	☐	P_99S_COLLE	XFIELD	CHAR	1	0	Collective
34	TITLE	☐	P_99S_TITLE	CHAR4	CHAR	4	0	Granting Type	T5F99A3
35	DCDAT	☐	P_99S_DCDAT	DATS	DATS	8	0	Award Decision Date
36	STATU	☐	P_99S_STATU	CHAR4	CHAR	4	0	Status	T5F99A4
37	DADAT	☐	P_99S_DADAT	DATS	DATS	8	0	Date of Award Ceremony
38	GRADE	☐	P06P_DEGRA	CHAR4	CHAR	4	0		T5FPBSA2
39	NIVAU	☐	P06P_NIVAU	P06P_NIVAU	CHAR	1	0
40	ORTYP	☐	P06P_ORTYP	CHAR2	CHAR	2	0		T5FPBSA5
41	ORNID	☐	P06P_ORNID	CHAR4	CHAR	4	0		T5FPBSA4
42	AUTGV	☐	P_99S_AUTGV	CHAR4	CHAR	4	0	Authority awarding	T5F99A2
43	PAYRR	☐	P_99S_PAYRR	P_99S_PAYRR	CHAR	1	0	Payroll-Relevant
44	LGTXT	☐	P_99S_LGTXT	TDOBNAME	CHAR	70	0	Prefix for Long Text IDs
45	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0861	AUTGV	T5F99A2	AUTHO	KEY	1	CN
2	P0861	AUTHO	T5F99A2	AUTHO		1	CN
3	P0861	AWADG	T5F99A5	AWADG	KEY	1	CN
4	P0861	AWADT	T5F99A0	AWADT	KEY	1	CN
5	P0861	GRADE	T5FPBSA2	GRADE	KEY	1	CN
6	P0861	INFTY	T582A	INFTY
7	P0861	MOTIF	T5F99A1	MOTIF		1	CN
8	P0861	ORNID	T5FPBSA4	ORNID	KEY	1	CN
9	P0861	ORTYP	T5FPBSA5	ORTYP	KEY	1	CN
10	P0861	PREAS	T530E	PREAS
11	P0861	STATU	T5F99A4	STATU		1	CN
12	P0861	TITLE	T5F99A3	TITLE		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	500