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

Dictionary Type: Table
Description: HR Master Record: Infotype 0442




ABAP Code to SELECT data from PA0442
Related tables to PA0442
Access table PA0442




Table field list including key, data, relationships and ABAP select examples

PA0442 is a standard SAP Table which is used to store HR Master Record: Infotype 0442 data and is available within R/3 SAP systems depending on the version and release level.

The PA0442 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0442 data available in SAP. These include PERNR (Personnel number), SUBTY (Subtype), OBJPS (Object Identification), SPRPS (Lock Indicator for HR Master Data Record).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PA0442 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PERNRPersonnel number PERSNONUMC8PA0003PERSNOPER
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
RGNDARegistration Date P_RGNDADATS8DATUM
BUYDABuy Date P_BUYDADATS8DATUM
FACTOCar manufacturer P_FACTOCHAR2T51C1P_FACTO
MODELCar Model P_MODELCHAR6T51C3P_MODEL
REGNOLicense plate number P_KFZKZCHAR10CHAR10
ASTNOCar Asset Number ANLNRCHAR20ANLNR
REASNUnavailability Reason P_REASNCHAR1T51CCP_REASN
FREEMFree maintenance P_FREEMCHAR1XFELD
INSURIncluding insurance P_INSURCHAR1XFIELD
INCFLIncluding fuel P_INCFLCHAR1XFELD
PRVDRPrivate driving per year P_PRVDRNUMC6NUMC6
DUTDRDuty driving per year P_DUTDRNUMC6NUMC6
LISTPCar List Price P_LISTPCURR15(2) WERT15
DSCNTDiscount in percentage P_DSCNTDEC5(2) P_DSCNT
ACCSSPaid for Accessories P_ACCSSCURR15(2) WERT15
PAIDPCar Paid Price P_PAIDPCURR15(2) WERT15
ONEPDOne time with hold payment P_ONEPDCURR15(2) WERT15
REGPDRegular with hold payment P_REGPDCURR15(2) WERT15
BNFTVBenefit value P_BNFTVCURR15(2) WERT15
CRNCYCurrency Key WAERSCUKY5TCURCWAERSFWS
RANGESequence number P_RANGENUMC1NUMC1
DSTNCDistance to work P_DSTNCDEC3DEC3
DSTN2Distance to home P_ENTKMDEC4DEC4
CALCBCalculate benefit value P_CALCBCHAR1XFELD
CARRGRegulation for taxation of company car P_PKWGLCHAR1T544APKWGL
MNTRLRegulation for maintenance of company car P_MNTRLCHAR1T51C8P_MNTRL
PAYMOPayment Model MODE1CHAR4T549WMODEL
CCSSCCompany car salary sacrifice P_CCSSCCURR15(2) WERT15
TTYPECar transmission types (for UK only) P_TTYPECHAR1T5GC3P_TTYPE
DPLANCar Door plan (for UK only) P_DPLANCHAR4T5GC3P_DPLAN
ADDACFurther Accessories P_ADDACCURR15(2) WERT15
FUELRFuel rule P_FUELRCHAR3P_FUELR
UAVALCar is unavailable P_UAVALCHAR1XFELD
VEHCLVehicle Classification P_VEHCLCHAR4Assigned to domainSUBTY_591A
CO2EMCar C02 Emissions P_CO2EMNUMC3NUMC03
CVPSHVan sharing percentage (for UK only) P_CVPSHDEC5(2) P_CVPSH
CVFSHVan Fuel Sharing (for UK only) P_CVFSHCHAR1XFELD
POLLCPollution Category P_POLLCCHAR2T51CEP_POLLC
LEASCLeasing Category (for NL only) P_LEASCCHAR2T51CFP_LEASC
CMPIDLeasing Company (for NL only) P_CMPIDCHAR4T51CGP_CMPID
P46CDTP46Car issued date P_P46CDTDATS8DATS
P46CIDP46Car has been issued - indicator P_P46CIDCHAR1CHAR1
TOTDSVAT on Discounts P_TOTDSCURR15(2) WERT15

Key field Non-key field



How do I retrieve data from SAP table PA0442 using ABAP code

The following ABAP code Example will allow you to do a basic selection on PA0442 to SELECT all data from the table
DATA: WA_PA0442 TYPE PA0442.

SELECT SINGLE *
FROM PA0442
INTO CORRESPONDING FIELDS OF WA_PA0442
WHERE...

How to access SAP table PA0442

Within an ECC or HANA version of SAP you can also view further information about PA0442 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!