SAP ABAP Table PA0865 (HR Master Record: Infotype 0865)

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	TRANSP	Transparent table
Transparent table	PA0865	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0865

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	Infotype 0865 (Mobility)
27	MOBID	☐	P_99S_MOBID	P_99S_MOBID	CHAR	30	0	Record Name
28	VWEEK	☐	P_99S_VWEEK	XFELD	CHAR	1	0	Record is Valid Full Time
29	VMOND	☐	P_99S_VMOND		CHAR	1	0	Valid on Mondays
30	VTUES	☐	P_99S_VTUES		CHAR	1	0	Valid on Tuesdays
31	VWEND	☐	P_99S_VWEND		CHAR	1	0	Valid on Wednesdays
32	VTHUR	☐	P_99S_VTHUR		CHAR	1	0	Valid on Thursdays
33	VFRID	☐	P_99S_VFRID		CHAR	1	0	Valid on Fridays
34	VSATU	☐	P_99S_VSATU		CHAR	1	0	Valid on Saturdays
35	VSUND	☐	P_99S_VSUND		CHAR	1	0	Valid on Sundays
36	VALID	☐	P_99S_VALID	P_99S_VALID	NUMC	6	0	Record Validity: Amount
37	VUNIT	☐	P_99S_VUNIT	P_99S_VUNIT	CHAR	1	0	Record Validity: Percentage or Days
38	DISTN	☐	P_99S_DISTN	P_99S_DISTN	DEC	5	0	Total Home-Work Distance calculated by the system
39	NAME1	☐	P_99S_MNAME	P_99S_RNAME	CHAR	5	0	ID for Sub-Route in Mobility Record
40	MOBM1	☐	P_99S_MOBME	P_99S_MOBME	CHAR	4	0	Means of Transport	T5F99M1
41	DSTN1	☐	P_99S_TMDSN	P_99S_DISTN	DEC	5	0	Distance Traveled with Means of Transport
42	RULE1	☐	P_99S_CRULE	P_99S_CRULE	CHAR	4	0	Reimbursement Rule	T5F99M2
43	TYPE1	☐	P_99S_CTYPE	P_99S_CTYPE	CHAR	4	0	Cost Type	T5F99M3
44	PANZ1	☐	P_99S_PANZL	P_99S_PANZL	NUMC	3	0	Cost Interval Number
45	CVAL1	☐	P_99S_UCVAL	P_99S_PAYMO	NUMC	3	0	Cost Interval Unit
46	DEFL1	☐	P_99S_DEFLD	XFELD	CHAR	1	0	Indicator: Use Defaults or Manual Input
47	CAMT1	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
48	WAER1	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
49	PERC1	☐	P_99S_CPERC	P_99S_CPERC	DEC	5	0	Reimbursement Percentage
50	RATE1	☐	P_99S_CRATE	P_99S_CRATE	CURR	10	2	Reimbursement Rate per Kilometer
51	COMA1	☐	P_99S_CFIXE	P_99S_CFIXE	CURR	10	2	Fixed Reimbursement
52	PAYM1	☐	P_99S_PERIO	P_99S_PERIO	NUMC	1	0	Payment Frequency
53	PAYD1	☐	DZDATE	DATUM	DATS	8	0	First payment date
54	REGN1	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
55	MAMT1	☐	P_99S_MPAMT	PRBETRG	CURR	15	2	Paid Mobility Reimbursement Amount
56	NAME2	☐	P_99S_MNAME	P_99S_RNAME	CHAR	5	0	ID for Sub-Route in Mobility Record
57	MOBM2	☐	P_99S_MOBME	P_99S_MOBME	CHAR	4	0	Means of Transport	*
58	DSTN2	☐	P_99S_TMDSN	P_99S_DISTN	DEC	5	0	Distance Traveled with Means of Transport
59	RULE2	☐	P_99S_CRULE	P_99S_CRULE	CHAR	4	0	Reimbursement Rule	T5F99M2
60	TYPE2	☐	P_99S_CTYPE	P_99S_CTYPE	CHAR	4	0	Cost Type	T5F99M3
61	PANZ2	☐	P_99S_PANZL	P_99S_PANZL	NUMC	3	0	Cost Interval Number
62	CVAL2	☐	P_99S_UCVAL	P_99S_PAYMO	NUMC	3	0	Cost Interval Unit
63	DEFL2	☐	P_99S_DEFLD	XFELD	CHAR	1	0	Indicator: Use Defaults or Manual Input
64	CAMT2	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
65	WAER2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
66	PERC2	☐	P_99S_CPERC	P_99S_CPERC	DEC	5	0	Reimbursement Percentage
67	RATE2	☐	P_99S_CRATE	P_99S_CRATE	CURR	10	2	Reimbursement Rate per Kilometer
68	COMA2	☐	P_99S_CFIXE	P_99S_CFIXE	CURR	10	2	Fixed Reimbursement
69	PAYM2	☐	P_99S_PERIO	P_99S_PERIO	NUMC	1	0	Payment Frequency
70	PAYD2	☐	DZDATE	DATUM	DATS	8	0	First payment date
71	REGN2	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
72	MAMT2	☐	P_99S_MPAMT	PRBETRG	CURR	15	2	Paid Mobility Reimbursement Amount
73	NAME3	☐	P_99S_MNAME	P_99S_RNAME	CHAR	5	0	ID for Sub-Route in Mobility Record
74	MOBM3	☐	P_99S_MOBME	P_99S_MOBME	CHAR	4	0	Means of Transport	T5F99M1
75	DSTN3	☐	P_99S_TMDSN	P_99S_DISTN	DEC	5	0	Distance Traveled with Means of Transport
76	RULE3	☐	P_99S_CRULE	P_99S_CRULE	CHAR	4	0	Reimbursement Rule	T5F99M2
77	TYPE3	☐	P_99S_CTYPE	P_99S_CTYPE	CHAR	4	0	Cost Type	T5F99M3
78	PANZ3	☐	P_99S_PANZL	P_99S_PANZL	NUMC	3	0	Cost Interval Number
79	CVAL3	☐	P_99S_UCVAL	P_99S_PAYMO	NUMC	3	0	Cost Interval Unit
80	DEFL3	☐	P_99S_DEFLD	XFELD	CHAR	1	0	Indicator: Use Defaults or Manual Input
81	CAMT3	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
82	WAER3	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
83	PERC3	☐	P_99S_CPERC	P_99S_CPERC	DEC	5	0	Reimbursement Percentage
84	RATE3	☐	P_99S_CRATE	P_99S_CRATE	CURR	10	2	Reimbursement Rate per Kilometer
85	COMA3	☐	P_99S_CFIXE	P_99S_CFIXE	CURR	10	2	Fixed Reimbursement
86	PAYM3	☐	P_99S_PERIO	P_99S_PERIO	NUMC	1	0	Payment Frequency
87	PAYD3	☐	DZDATE	DATUM	DATS	8	0	First payment date
88	REGN3	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
89	MAMT3	☐	P_99S_MPAMT	PRBETRG	CURR	15	2	Paid Mobility Reimbursement Amount
90	NAME4	☐	P_99S_MNAME	P_99S_RNAME	CHAR	5	0	ID for Sub-Route in Mobility Record
91	MOBM4	☐	P_99S_MOBME	P_99S_MOBME	CHAR	4	0	Means of Transport	T5F99M1
92	DSTN4	☐	P_99S_TMDSN	P_99S_DISTN	DEC	5	0	Distance Traveled with Means of Transport
93	RULE4	☐	P_99S_CRULE	P_99S_CRULE	CHAR	4	0	Reimbursement Rule	T5F99M2
94	TYPE4	☐	P_99S_CTYPE	P_99S_CTYPE	CHAR	4	0	Cost Type	T5F99M3
95	PANZ4	☐	P_99S_PANZL	P_99S_PANZL	NUMC	3	0	Cost Interval Number
96	CVAL4	☐	P_99S_UCVAL	P_99S_PAYMO	NUMC	3	0	Cost Interval Unit
97	DEFL4	☐	P_99S_DEFLD	XFELD	CHAR	1	0	Indicator: Use Defaults or Manual Input
98	CAMT4	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
99	WAER4	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
100	PERC4	☐	P_99S_CPERC	P_99S_CPERC	DEC	5	0	Reimbursement Percentage
101	RATE4	☐	P_99S_CRATE	P_99S_CRATE	CURR	10	2	Reimbursement Rate per Kilometer
102	COMA4	☐	P_99S_CFIXE	P_99S_CFIXE	CURR	10	2	Fixed Reimbursement
103	PAYM4	☐	P_99S_PERIO	P_99S_PERIO	NUMC	1	0	Payment Frequency
104	PAYD4	☐	DZDATE	DATUM	DATS	8	0	First payment date
105	REGN4	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
106	MAMT4	☐	P_99S_MPAMT	PRBETRG	CURR	15	2	Paid Mobility Reimbursement Amount
107	NAME5	☐	P_99S_MNAME	P_99S_RNAME	CHAR	5	0	ID for Sub-Route in Mobility Record
108	MOBM5	☐	P_99S_MOBME	P_99S_MOBME	CHAR	4	0	Means of Transport	T5F99M1
109	DSTN5	☐	P_99S_TMDSN	P_99S_DISTN	DEC	5	0	Distance Traveled with Means of Transport
110	RULE5	☐	P_99S_CRULE	P_99S_CRULE	CHAR	4	0	Reimbursement Rule	T5F99M2
111	TYPE5	☐	P_99S_CTYPE	P_99S_CTYPE	CHAR	4	0	Cost Type	T5F99M3
112	PANZ5	☐	P_99S_PANZL	P_99S_PANZL	NUMC	3	0	Cost Interval Number
113	CVAL5	☐	P_99S_UCVAL	P_99S_PAYMO	NUMC	3	0	Cost Interval Unit
114	DEFL5	☐	P_99S_DEFLD	XFELD	CHAR	1	0	Indicator: Use Defaults or Manual Input
115	CAMT5	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
116	WAER5	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
117	PERC5	☐	P_99S_CPERC	P_99S_CPERC	DEC	5	0	Reimbursement Percentage
118	RATE5	☐	P_99S_CRATE	P_99S_CRATE	CURR	10	2	Reimbursement Rate per Kilometer
119	COMA5	☐	P_99S_CFIXE	P_99S_CFIXE	CURR	10	2	Fixed Reimbursement
120	PAYM5	☐	P_99S_PERIO	P_99S_PERIO	NUMC	1	0	Payment Frequency
121	PAYD5	☐	DZDATE	DATUM	DATS	8	0	First payment date
122	REGN5	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
123	MAMT5	☐	P_99S_MPAMT	PRBETRG	CURR	15	2	Paid Mobility Reimbursement Amount
124	NAME6	☐	P_99S_MNAME	P_99S_RNAME	CHAR	5	0	ID for Sub-Route in Mobility Record
125	MOBM6	☐	P_99S_MOBME	P_99S_MOBME	CHAR	4	0	Means of Transport	T5F99M1
126	DSTN6	☐	P_99S_TMDSN	P_99S_DISTN	DEC	5	0	Distance Traveled with Means of Transport
127	RULE6	☐	P_99S_CRULE	P_99S_CRULE	CHAR	4	0	Reimbursement Rule	T5F99M2
128	TYPE6	☐	P_99S_CTYPE	P_99S_CTYPE	CHAR	4	0	Cost Type	T5F99M3
129	PANZ6	☐	P_99S_PANZL	P_99S_PANZL	NUMC	3	0	Cost Interval Number
130	CVAL6	☐	P_99S_UCVAL	P_99S_PAYMO	NUMC	3	0	Cost Interval Unit
131	DEFL6	☐	P_99S_DEFLD	XFELD	CHAR	1	0	Indicator: Use Defaults or Manual Input
132	CAMT6	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
133	WAER6	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
134	PERC6	☐	P_99S_CPERC	P_99S_CPERC	DEC	5	0	Reimbursement Percentage
135	RATE6	☐	P_99S_CRATE	P_99S_CRATE	CURR	10	2	Reimbursement Rate per Kilometer
136	COMA6	☐	P_99S_CFIXE	P_99S_CFIXE	CURR	10	2	Fixed Reimbursement
137	PAYM6	☐	P_99S_PERIO	P_99S_PERIO	NUMC	1	0	Payment Frequency
138	PAYD6	☐	DZDATE	DATUM	DATS	8	0	First payment date
139	REGN6	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
140	MAMT6	☐	P_99S_MPAMT	PRBETRG	CURR	15	2	Paid Mobility Reimbursement Amount
141	NAME7	☐	P_99S_MNAME	P_99S_RNAME	CHAR	5	0	ID for Sub-Route in Mobility Record
142	MOBM7	☐	P_99S_MOBME	P_99S_MOBME	CHAR	4	0	Means of Transport	T5F99M1
143	DSTN7	☐	P_99S_TMDSN	P_99S_DISTN	DEC	5	0	Distance Traveled with Means of Transport
144	RULE7	☐	P_99S_CRULE	P_99S_CRULE	CHAR	4	0	Reimbursement Rule	T5F99M2
145	TYPE7	☐	P_99S_CTYPE	P_99S_CTYPE	CHAR	4	0	Cost Type	T5F99M3
146	PANZ7	☐	P_99S_PANZL	P_99S_PANZL	NUMC	3	0	Cost Interval Number
147	CVAL7	☐	P_99S_UCVAL	P_99S_PAYMO	NUMC	3	0	Cost Interval Unit
148	DEFL7	☐	P_99S_DEFLD	XFELD	CHAR	1	0	Indicator: Use Defaults or Manual Input
149	CAMT7	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
150	WAER7	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
151	PERC7	☐	P_99S_CPERC	P_99S_CPERC	DEC	5	0	Reimbursement Percentage
152	RATE7	☐	P_99S_CRATE	P_99S_CRATE	CURR	10	2	Reimbursement Rate per Kilometer
153	COMA7	☐	P_99S_CFIXE	P_99S_CFIXE	CURR	10	2	Fixed Reimbursement
154	PAYM7	☐	P_99S_PERIO	P_99S_PERIO	NUMC	1	0	Payment Frequency
155	PAYD7	☐	DZDATE	DATUM	DATS	8	0	First payment date
156	REGN7	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
157	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0865	MOBM1	T5F99M1	MOBME	KEY
2	PA0865	MOBM3	T5F99M1	MOBME	KEY
3	PA0865	MOBM4	T5F99M1	MOBME	KEY
4	PA0865	MOBM5	T5F99M1	MOBME	KEY
5	PA0865	MOBM6	T5F99M1	MOBME	KEY
6	PA0865	MOBM7	T5F99M1	MOBME	KEY
7	PA0865	PERNR	PA0003	PERNR
8	PA0865	PREAS	T530E	PREAS
9	PA0865	RULE1	T5F99M2	CRULE	KEY
10	PA0865	RULE2	T5F99M2	CRULE	KEY
11	PA0865	RULE3	T5F99M2	CRULE	KEY
12	PA0865	RULE4	T5F99M2	CRULE	KEY
13	PA0865	RULE5	T5F99M2	CRULE	KEY
14	PA0865	RULE6	T5F99M2	CRULE	KEY
15	PA0865	RULE7	T5F99M2	CRULE	KEY
16	PA0865	TYPE1	T5F99M3	CTYPE	KEY
17	PA0865	TYPE2	T5F99M3	CTYPE	KEY
18	PA0865	TYPE3	T5F99M3	CTYPE	KEY
19	PA0865	TYPE4	T5F99M3	CTYPE	KEY
20	PA0865	TYPE5	T5F99M3	CTYPE	KEY
21	PA0865	TYPE6	T5F99M3	CTYPE	KEY
22	PA0865	TYPE7	T5F99M3	CTYPE	KEY
23	PA0865	WAER1	TCURC	WAERS	KEY
24	PA0865	WAER2	TCURC	WAERS	KEY
25	PA0865	WAER3	TCURC	WAERS	KEY
26	PA0865	WAER4	TCURC	WAERS	KEY
27	PA0865	WAER5	TCURC	WAERS	KEY
28	PA0865	WAER6	TCURC	WAERS	KEY
29	PA0865	WAER7	TCURC	WAERS	KEY

History

Last changed by/on	SAP	20080626
SAP Release Created in