SAP ABAP Table PA0442 (HR Master Record: Infotype 0442)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PA-PA (Application Component) Personnel Administration
     ⤷ PBCC (Package) HR master data: Company Car

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0442	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0442

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	Company car
27	RGNDA	☐	P_RGNDA	DATUM	DATS	8	0	Registration Date
28	BUYDA	☐	P_BUYDA	DATUM	DATS	8	0	Buy Date
29	FACTO	☐	P_FACTO	P_FACTO	CHAR	2	0	Car manufacturer	T51C1
30	MODEL	☐	P_MODEL	P_MODEL	CHAR	6	0	Car Model	T51C3
31	REGNO	☐	P_KFZKZ	CHAR10	CHAR	10	0	License plate number
32	ASTNO	☐	ANLNR	ANLNR	CHAR	20	0	Car Asset Number
33	REASN	☐	P_REASN	P_REASN	CHAR	1	0	Unavailability Reason	T51CC
34	FREEM	☐	P_FREEM	XFELD	CHAR	1	0	Free maintenance
35	INSUR	☐	P_INSUR	XFIELD	CHAR	1	0	Including insurance
36	INCFL	☐	P_INCFL	XFELD	CHAR	1	0	Including fuel
37	PRVDR	☐	P_PRVDR	NUMC6	NUMC	6	0	Private driving per year
38	DUTDR	☐	P_DUTDR	NUMC6	NUMC	6	0	Duty driving per year
39	LISTP	☐	P_LISTP	WERT15	CURR	15	2	Car List Price
40	DSCNT	☐	P_DSCNT	P_DSCNT	DEC	5	2	Discount in percentage
41	ACCSS	☐	P_ACCSS	WERT15	CURR	15	2	Paid for Accessories
42	PAIDP	☐	P_PAIDP	WERT15	CURR	15	2	Car Paid Price
43	ONEPD	☐	P_ONEPD	WERT15	CURR	15	2	One time with hold payment
44	REGPD	☐	P_REGPD	WERT15	CURR	15	2	Regular with hold payment
45	BNFTV	☐	P_BNFTV	WERT15	CURR	15	2	Benefit value
46	CRNCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
47	RANGE	☐	P_RANGE	NUMC1	NUMC	1	0	Sequence number
48	DSTNC	☐	P_DSTNC	DEC3	DEC	3	0	Distance to work
49	DSTN2	☐	P_ENTKM	DEC4	DEC	4	0	Distance to home
50	CALCB	☐	P_CALCB	XFELD	CHAR	1	0	Calculate benefit value
51	CARRG	☐	P_PKWGL	PKWGL	CHAR	1	0	Regulation for taxation of company car	T544A
52	MNTRL	☐	P_MNTRL	P_MNTRL	CHAR	1	0	Regulation for maintenance of company car	T51C8
53	PAYMO	☐	MODE1	MODEL	CHAR	4	0	Payment Model	T549W
54	CCSSC	☐	P_CCSSC	WERT15	CURR	15	2	Company car salary sacrifice
55	TTYPE	☐	P_TTYPE	P_TTYPE	CHAR	1	0	Car transmission types (for UK only)	T5GC3
56	DPLAN	☐	P_DPLAN	P_DPLAN	CHAR	4	0	Car Door plan (for UK only)	T5GC3
57	ADDAC	☐	P_ADDAC	WERT15	CURR	15	2	Further Accessories
58	FUELR	☐	P_FUELR	P_FUELR	CHAR	3	0	Fuel rule
59	UAVAL	☐	P_UAVAL	XFELD	CHAR	1	0	Car is unavailable
60	VEHCL	☐	P_VEHCL	SUBTY_591A	CHAR	4	0	Vehicle Classification	*
61	CO2EM	☐	P_CO2EM	NUMC03	NUMC	3	0	Car C02 Emissions
62	CVPSH	☐	P_CVPSH	P_CVPSH	DEC	5	2	Van sharing percentage (for UK only)
63	CVFSH	☐	P_CVFSH	XFELD	CHAR	1	0	Van Fuel Sharing (for UK only)
64	POLLC	☐	P_POLLC	P_POLLC	CHAR	2	0	Pollution Category	T51CE
65	LEASC	☐	P_LEASC	P_LEASC	CHAR	2	0	Leasing Category (for NL only)	T51CF
66	CMPID	☐	P_CMPID	P_CMPID	CHAR	4	0	Leasing Company (for NL only)	T51CG
67	P46CDT	☐	P_P46CDT	DATS	DATS	8	0	P46Car issued date
68	P46CID	☐	P_P46CID	CHAR1	CHAR	1	0	P46Car has been issued indicator
69	TOTDS	☐	P_TOTDS	WERT15	CURR	15	2	VAT on Discounts
70	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0442	CARRG	T544A	PKWRG
2	PA0442	CMPID	T51CG	CMPID	KEY	1	CN
3	PA0442	CRNCY	TCURC	WAERS		1	CN
4	PA0442	DPLAN	T5GC3	DPLAN	KEY	1	CN
5	PA0442	FACTO	T51C1	FACTO		1	CN
6	PA0442	LEASC	T51CF	LEASC	KEY	1	CN
7	PA0442	MNTRL	T51C8	MNTRL
8	PA0442	MODEL	T51C3	MODEL		1	CN
9	PA0442	PAYMO	T549W	MODEL	KEY	1	CN
10	PA0442	PERNR	PA0003	PERNR
11	PA0442	POLLC	T51CE	POLLC	KEY	1	CN
12	PA0442	PREAS	T530E	PREAS
13	PA0442	REASN	T51CC	REASN	KEY	1	CN
14	PA0442	TTYPE	T5GC3	TTYPE	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in