P0651 SAP (HR Master Record for Infotype 0651) Structure details

Dictionary Type: Structure
Description: HR Master Record for Infotype 0651




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




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

P0651 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "HR Master Record for Infotype 0651" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_P0651 TYPE P0651.

The P0651 table consists of various fields, each holding specific information or linking keys about HR Master Record for Infotype 0651 data available in SAP. These include PERNR (Personnel Number), INFTY (Infotype), SUBTY (Subtype), OBJPS (Object Identification).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP P0651 structure 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
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
INFTYInfotype INFTYCHAR4T582AINFOTYPITP
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
KVNAMFirst Name of Sick Child P01W_KVNAMCHAR40TEXT40
KNNAMLast Name of Sick Child P01W_KNNAMCHAR40TEXT40
KGDATChild's Date of Birth P01W_KGDATDATS8DATUM
WVLDTStart of Advance Winter Compensation Benefit P01W_WVLDTDATS8DATUM
WALAZAdvance Winter Compensation Benefit in Last Payroll Period P01W_WALAZCHAR1XFELD
STWAGAdvance Winter Compensation Benefit: Number of Hours P01W_STWAGDEC5(2) STDAZ
EFZGDContinued Pay <= 6 Weeks: Reasons P01W_EFZGDCHAR30TEXT30
AEZUSAdditional Remuneration P01W_AEZUSNUMC1P01W_AEZUS
AEBISAdditional Remuneration: To P01W_AEBISDATS8DATUM
ZLRHTPayment Frequency P01W_ZLRHTCHAR1P01W_ZLRHT
ZABRTAdditional Remuneration: Gross P01W_ZABRTCURR13(2) P_AMT07V
ZANTOAdditional Remuneration: Net P01W_ZANTOCURR13(2) P_AMT07V
KDGAMTermination On P01W_KDGAMDATS8DATUM
KDGRDTermination Reason P01W_KDGRDCHAR30TEXT30
KDZUMTermination On P01W_KDZUMDATS8DATUM
VWBETCapital Formation Savings Payment of Employer: Amount P01W_VWBETCURR13(2) P_AMT07V
VWBISCFS Limited To P01W_VWBISDATS8DATUM
VWRHTCFS - Payment Frequency P01W_VWRHTCHAR1P01W_VWRHT
ZUSARAdditional Payments in Kind: Type P01W_ZUSARCHAR30TEXT30
ZSBTGAdditional Payments in Kind: Amount P01W_ZSBTGCURR13(2) P_AMT07V
LABEGBuilding Sector: Wage Compensation From P01W_LABEGDATS8DATUM
LAENDBuilding Sector: Wage Compensation To P01W_LAENDDATS8DATUM
LABE1Building Sector: Wage Compensation From P01W_LABEGDATS8DATUM
LAEN1Building Sector: Wage Compensation To P01W_LAENDDATS8DATUM
FRNTONet Remuneration on First Day of Release from Work P01W_FRNTOCURR13(2) P_AMT07V
FRGKIRelease from Work Due to Same Child P01W_FRGKICHAR1XFELD
KIBE1Release from Work Due to Illness of Same Child: Start Date P01W_KINBGDATS8DATS
KIEN1Release from Work Due to Illness of Same Child: End Date P01W_KINEDDATS8DATS
KIBE2Release from Work Due to Illness of Same Child: Start Date P01W_KINBGDATS8DATS
KIEN2Release from Work Due to Illness of Same Child: End Date P01W_KINEDDATS8DATS
KITA1Release from Work Due to Illness of Same Child: No. of Days P01W_KINTGNUMC2NUMC02
KITA2Release from Work Due to Illness of Same Child: No. of Days P01W_KINTGNUMC2NUMC02
BRTAEWorking Time P01W_BRTAECHAR1P01W_BRTAE
ANGRDEntitlement to Paid Release from Work P01W_ANGRDCHAR1P01W_ANGRD
ANFRTTemporary Entitlement to P01W_ANFRTNUMC2NUMC02
FALNRCase Number P01W_FALNRCHAR12CHAR12
FRABLWork Relationship/Period Expiration P01W_FRABLCHAR1XFELD
FADATDate of Period Expiration P01W_FADATDATS8DATUM
ENTS1Excused Unpaid Working Hours P01W_ENTSCDEC5(2) STDAZ
UNTS1Unexcused Unpaid Working Hours P01W_UNTSCDEC5(2) STDAZ
ENTS2Excused Unpaid Working Hours P01W_ENTSCDEC5(2) STDAZ
UNTS2Unexcused Unpaid Working Hours P01W_UNTSCDEC5(2) STDAZ
ENTS3Excused Unpaid Working Hours P01W_ENTSCDEC5(2) STDAZ
UNTS3Unexcused Unpaid Working Hours P01W_UNTSCDEC5(2) STDAZ
MON01Date - Month P01W_MONXXCHAR2P01W_MONXX
MON02Date - Month P01W_MONXXCHAR2P01W_MONXX
MON03Date - Month P01W_MONXXCHAR2P01W_MONXX
YEA01Date - Year P01W_YEAXXCHAR4CHAR4
YEA02Date - Year P01W_YEAXXCHAR4CHAR4
YEA03Date - Year P01W_YEAXXCHAR4CHAR4
WAERSCurrency Key P01W_WAERSCUKY5T500WWAERS
UFTAGAccident Date P01W_UFTAGNUMC8NUMC08
KDGSLTermination Reason P01W_KDGSLCHAR1P01W_KDGSL
AEUEBRemuneration Exceeds Comparison Net by More Than EUR 50 P01W_AEUEBCHAR1XFELD
FRBTOGross Remuneration on First Day of Release from Work P01W_FRBTOCURR13(2) P_AMT07V
UVTRGName of Accident Insurance Institution P01W_UVTRGCHAR30TEXT30
SBRHTHR-DBS: Payments in Kind - Payment Frequency P01W_SBRHTCHAR1P01W_SBRHT
ADRS1Address line LINESCHAR80LINES
ADRS2Address line LINESCHAR80LINES
ADRS3Address line LINESCHAR80LINES
KNDNRChild Number P01_KNDNRCHAR2OBJPS
ABMSNJob-Creating Measure P01_ABMSNCHAR1XFELD
VORERContinued Pay for Less Than 6 Weeks P01_SV_EE_VORERCHAR1P01_SV_EE_KNZJN
BEGVE1Start of Imputable Periods of Preexisting Conditions 1 P01_SV_EE_BEGVE1DATS8P01_SV_EE_DATUM
ENDVE1Imputable Periods of Preexisting Conditions End 1 P01_SV_EE_ENDVE1DATS8P01_SV_EE_DATUM
BEGVE2Start of Imputable Periods of Preexisting Conditions 2 P01_SV_EE_BEGVE2DATS8P01_SV_EE_DATUM
ENDVE2Imputable Periods of Preexisting Conditions End 2 P01_SV_EE_ENDVE2DATS8P01_SV_EE_DATUM
AEVZMONMonthly Full-Time Remuneration in Cal. Month Before Start P01_SV_EE_AEVZMON2CURR8(2)
AEVZSTDHourly Full-Time Remuneration in Cal. Month Before Start P01_SV_EE_AEVZSTD2CURR8(2)
WAZTRFWeekly Working Time Agreed by Collective Agreement P01_SV_EE_WAZTRF2DEC5(2)
BEGTRFCurrently Valid Collective Agreement Of P01_SV_EE_BEGTRFDATS8P01_SV_EE_DATUM
TRFGEMDefining Pay Scale Group/Collective Agreement P01_SV_EE_TRFGEMCHAR20P01_SV_EE_KZ20
MMTRFDefining Pay Scale Group/Collective Agreement P01_SV_EE_MMTRFCHAR1P01_SV_EE_MMTRF
VRGTGRRemuneration/Wage Group P01_SV_EE_VRGTGRCHAR20P01_SV_EE_KZ20
VWLMONMonthly Coll. Agr. Capital Form. Savings Payment of Employer P01_SV_EE_VWLMON2CURR8(2)
EZTRFNon-Recurring Annual Payment Regulated by Collective Agr. P01_SV_EE_EZTRF2CURR8(2)
AEENTTRFRemuneration Corresponds to Collective Agreement Conditions P01_SV_EE_AEENTTRFCHAR1P01_SV_EE_KZJNU
VWLCapital Formation Savings Payment During Bens for Particptn P01_SV_EE_VWL2CURR6(2)
BRUSBGross Cont. Paymts in Kind/Rem. for PT Work in Mnth d. BfP P01_SV_EE_BRUSB2CURR8(2)
NETSBNet Cont. Payments in Kind/Rem. PT Wrk d. BfP in Month P01_SV_EE_NETSB2CURR8(2)
UNFAZAccident Case Number of Relevant Accident Insurance Carrier P01_SV_EE_UNFAZCHAR20P01_SV_EE_UNFAZ
UNFTRInstitute Indicator of Accident Insurance Carrier P01_SV_EE_UNFTRCHAR15P01_SV_EE_UNFTR
BVALSEmployed as P01_SV_EE_BVALSCHAR30P01_SV_EE_BVALS
ABWGRDDifferent Submission Reason P01_SV_EE_ABWGRDNUMC2P01_SV_EE_ABGRD
ABWBEGLinked Absence P01_SV_EE_ABWBEGDATS8P01_SV_EE_DATUM
EAZENDLast Settled Payroll Period 1 End P01_SV_EE_EAZEND1DATS8P01_SV_EE_DATUM
LBTAGLast Paid Day P01_SV_EE_LBTAGDATS8P01_SV_EE_DATUM
UMGEWAERemuneration Conversion P01_SV_EE_UMGEWAE2CURR8(2)
VEBBRUAgreed Gross Remuneration P01_SV_EE_VEBBRU2CURR8(2)
VEBNETNet Remuneration P01_SV_EE_VEBNET2CURR8(2)
EZKVPart of Non-Recurring Payments Liable for Contr. in HI P01_SV_EE_EZKV2CURR8(2)
EZRVPart of Non-Recurring Payments Liable for Contr. in PI P01_SV_EE_EZRV2CURR8(2)
EZAVPart of Non-Recurring Payments Liable for Contr. in UI P01_SV_EE_EZAV2CURR8(2)
ANZTGNumber of Workdays for Payment of Gross Remuneration P01_SV_EE_ANZTGNUMC2P01_SV_EE_ANZTG
ANZATNumber of Workdays in Release from Work Period P01_SV_EE_ANZATNUMC2P01_SV_EE_ATANZ
FRTAG01Additional Release from Work P01_SV_EE_FRTAGZDATS8P01_SV_EE_DATUM
FRTAG02Additional Release from Work P01_SV_EE_FRTAGZDATS8P01_SV_EE_DATUM
ABWAUSTermination During Illness P01_SV_EE_ABWAUSCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure P0651 using ABAP code?

As P0651 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on P0651 as there is no data to select.

How to access SAP table P0651

Within an ECC or HANA version of SAP you can also view further information about P0651 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!