SAP Table PA0442
HR Master Record: Infotype 0442
PA0442 (HR Master Record: Infotype 0442) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PA0442 to other SAP tables.
PA0442 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| PERNR | Personnel number | PERSNO | PA0003 | NUMC | 8 | 0 | ||||||||
| SUBTY | Subtype | SUBTY | CHAR | 4 | 0 | |||||||||
| OBJPS | Object Identification | OBJPS | CHAR | 2 | 0 | |||||||||
| SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||||
| AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||||
| UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||||
| ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||||
| PREAS | Reason for Changing Master Data | PREAS | T530E | CHAR | 2 | 0 | ||||||||
| FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
| RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
| RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
| GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | 0 | |||||||||
| RGNDA | Registration Date | P_RGNDA | DATS | 8 | 0 | |||||||||
| BUYDA | Buy Date | P_BUYDA | DATS | 8 | 0 | |||||||||
| FACTO | Car manufacturer | P_FACTO | T51C1 | CHAR | 2 | 0 | ||||||||
| MODEL | Car Model | P_MODEL | T51C3 | CHAR | 6 | 0 | ||||||||
| REGNO | License plate number | P_KFZKZ | CHAR | 10 | 0 | |||||||||
| ASTNO | Car Asset Number | ANLNR | CHAR | 20 | 0 | |||||||||
| REASN | Unavailability Reason | P_REASN | T51CC | CHAR | 1 | 0 | ||||||||
| FREEM | Free maintenance | P_FREEM | CHAR | 1 | 0 |
Possible values
|
||||||||
| INSUR | Including insurance | P_INSUR | CHAR | 1 | 0 |
Possible values
|
||||||||
| INCFL | Including fuel | P_INCFL | CHAR | 1 | 0 |
Possible values
|
||||||||
| PRVDR | Private driving per year | P_PRVDR | NUMC | 6 | 0 | |||||||||
| DUTDR | Duty driving per year | P_DUTDR | NUMC | 6 | 0 | |||||||||
| LISTP | Car List Price | P_LISTP | CURR | 15 | 2 | |||||||||
| DSCNT | Discount in percentage | P_DSCNT | DEC | 5 | 2 |
Possible values
|
||||||||
| ACCSS | Paid for Accessories | P_ACCSS | CURR | 15 | 2 | |||||||||
| PAIDP | Car Paid Price | P_PAIDP | CURR | 15 | 2 | |||||||||
| ONEPD | One time with hold payment | P_ONEPD | CURR | 15 | 2 | |||||||||
| REGPD | Regular with hold payment | P_REGPD | CURR | 15 | 2 | |||||||||
| BNFTV | Benefit value | P_BNFTV | CURR | 15 | 2 | |||||||||
| CRNCY | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||
| RANGE | Sequence number | P_RANGE | NUMC | 1 | 0 |
Possible values
|
||||||||
| DSTNC | Distance to work | P_DSTNC | DEC | 3 | 0 | |||||||||
| DSTN2 | Distance to home | P_ENTKM | DEC | 4 | 0 | |||||||||
| CALCB | Calculate benefit value | P_CALCB | CHAR | 1 | 0 |
Possible values
|
||||||||
| CARRG | Regulation for taxation of company car | P_PKWGL | T544A | CHAR | 1 | 0 | ||||||||
| MNTRL | Regulation for maintenance of company car | P_MNTRL | T51C8 | CHAR | 1 | 0 | ||||||||
| PAYMO | Payment Model | MODE1 | T549W | CHAR | 4 | 0 | ||||||||
| CCSSC | Company car salary sacrifice | P_CCSSC | CURR | 15 | 2 | |||||||||
| TTYPE | Car transmission types (for UK only) | P_TTYPE | T5GC3 | CHAR | 1 | 0 | ||||||||
| DPLAN | Car Door plan (for UK only) | P_DPLAN | T5GC3 | CHAR | 4 | 0 | ||||||||
| ADDAC | Further Accessories | P_ADDAC | CURR | 15 | 2 | |||||||||
| FUELR | Fuel rule | P_FUELR | CHAR | 3 | 0 |
Possible values
|
||||||||
| UAVAL | Car is unavailable | P_UAVAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| VEHCL | Vehicle Classification | P_VEHCL | CHAR | 4 | 0 | |||||||||
| CO2EM | Car C02 Emissions | P_CO2EM | NUMC | 3 | 0 | |||||||||
| CVPSH | Van sharing percentage (for UK only) | P_CVPSH | DEC | 5 | 2 |
Possible values
|
||||||||
| CVFSH | Van Fuel Sharing (for UK only) | P_CVFSH | CHAR | 1 | 0 |
Possible values
|
||||||||
| POLLC | Pollution Category | P_POLLC | T51CE | CHAR | 2 | 0 | ||||||||
| LEASC | Leasing Category (for NL only) | P_LEASC | T51CF | CHAR | 2 | 0 | ||||||||
| CMPID | Leasing Company (for NL only) | P_CMPID | T51CG | CHAR | 4 | 0 | ||||||||
| P46CDT | P46Car issued date | P_P46CDT | DATS | 8 | 0 | |||||||||
| P46CID | P46Car has been issued - indicator | P_P46CID | CHAR | 1 | 0 | |||||||||
| TOTDS | VAT on Discounts | P_TOTDS | CURR | 15 | 2 | |||||||||
PA0442 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PA0442 | CARRG | PA0442 | CARRG | T544A | Car rule | PKWRG |
| PA0442 | CARRG | SYST | MANDT | T544A | Car rule | MANDT |
| PA0442 | CARRG | T001P | MOLGA | T544A | Car rule | MOLGA |
| PA0442 | CMPID | SYST | MANDT | T51CG | Leasing Companies for Company Cars | MANDT |
| PA0442 | CMPID | T001P | MOLGA | T51CG | Leasing Companies for Company Cars | MOLGA |
| PA0442 | CMPID | PA0442 | CMPID | T51CG | Leasing Companies for Company Cars | CMPID |
| PA0442 | CMPID | * | T51CG | Leasing Companies for Company Cars | ENDDA | |
| PA0442 | CRNCY | PA0442 | CRNCY | TCURC | Currency Codes | WAERS |
| PA0442 | CRNCY | SY | MANDT | TCURC | Currency Codes | MANDT |
| PA0442 | DPLAN | PA0442 | MODEL | T5GC3 | GB Company car C02 emmissions | MODEL |
| PA0442 | DPLAN | PA0442 | TTYPE | T5GC3 | GB Company car C02 emmissions | TTYPE |
| PA0442 | DPLAN | PA0442 | DPLAN | T5GC3 | GB Company car C02 emmissions | DPLAN |
| PA0442 | DPLAN | * | T5GC3 | GB Company car C02 emmissions | ENDDA | |
| PA0442 | DPLAN | SYST | MANDT | T5GC3 | GB Company car C02 emmissions | MANDT |
| PA0442 | DPLAN | PA0442 | FACTO | T5GC3 | GB Company car C02 emmissions | FACTO |
| PA0442 | FACTO | SY | MANDT | T51C1 | Car factory definition table | MANDT |
| PA0442 | FACTO | PA0442 | FACTO | T51C1 | Car factory definition table | FACTO |
| PA0442 | LEASC | PA0442 | LEASC | T51CF | Leasing Categories for Company Cars | LEASC |
| PA0442 | LEASC | * | T51CF | Leasing Categories for Company Cars | ENDDA | |
| PA0442 | LEASC | SYST | MANDT | T51CF | Leasing Categories for Company Cars | MANDT |
| PA0442 | LEASC | T001P | MOLGA | T51CF | Leasing Categories for Company Cars | MOLGA |
| PA0442 | MNTRL | PA0442 | MNTRL | T51C8 | Car maintenance rule | MNTRL |
| PA0442 | MNTRL | SYST | MANDT | T51C8 | Car maintenance rule | MANDT |
| PA0442 | MNTRL | T001P | MOLGA | T51C8 | Car maintenance rule | MOLGA |
| PA0442 | MODEL | SY | MANDT | T51C3 | Car model definition table | MANDT |
| PA0442 | MODEL | PA0442 | FACTO | T51C3 | Car model definition table | FACTO |
| PA0442 | MODEL | PA0442 | MODEL | T51C3 | Car model definition table | MODEL |
| PA0442 | MODEL | * | T51C3 | Car model definition table | ENDDA | |
| PA0442 | PAYMO | SYST | MANDT | T549W | Recurr. Pymts/Deducs: Payment Models | MANDT |
| PA0442 | PAYMO | PA0442 | PAYMO | T549W | Recurr. Pymts/Deducs: Payment Models | MODEL |
| PA0442 | PERNR | SYST | MANDT | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
| PA0442 | PERNR | PA0442 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
| PA0442 | POLLC | T001P | MOLGA | T51CE | Pollution Categories for Company Cars | MOLGA |
| PA0442 | POLLC | PA0442 | POLLC | T51CE | Pollution Categories for Company Cars | POLLC |
| PA0442 | POLLC | * | T51CE | Pollution Categories for Company Cars | ENDDA | |
| PA0442 | POLLC | SYST | MANDT | T51CE | Pollution Categories for Company Cars | MANDT |
| PA0442 | PREAS | SYST | MANDT | T530E | Reasons for Changes | MANDT |
| PA0442 | PREAS | PSKEY | INFTY | T530E | Reasons for Changes | INFTY |
| PA0442 | PREAS | PA0442 | PREAS | T530E | Reasons for Changes | PREAS |
| PA0442 | REASN | SYST | MANDT | T51CC | Company car unavailability reason | MANDT |
| PA0442 | REASN | T001P | MOLGA | T51CC | Company car unavailability reason | MOLGA |
| PA0442 | REASN | PA0442 | REASN | T51CC | Company car unavailability reason | REASN |
| PA0442 | TTYPE | PA0442 | MODEL | T5GC3 | GB Company car C02 emmissions | MODEL |
| PA0442 | TTYPE | PA0442 | TTYPE | T5GC3 | GB Company car C02 emmissions | TTYPE |
| PA0442 | TTYPE | * | T5GC3 | GB Company car C02 emmissions | DPLAN | |
| PA0442 | TTYPE | * | T5GC3 | GB Company car C02 emmissions | ENDDA | |
| PA0442 | TTYPE | SYST | MANDT | T5GC3 | GB Company car C02 emmissions | MANDT |
| PA0442 | TTYPE | PA0442 | FACTO | T5GC3 | GB Company car C02 emmissions | FACTO |
