P0865 SAP (HR Master Record: Infotype 0865 (Mobility)) Structure details

Dictionary Type: Structure
Description: HR Master Record: Infotype 0865 (Mobility)




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




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

P0865 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: Infotype 0865 (Mobility)" 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_P0865 TYPE P0865.

The P0865 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0865 (Mobility) 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 P0865 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
MOBIDRecord Name P_99S_MOBIDCHAR30P_99S_MOBID
VWEEKRecord is Valid Full Time P_99S_VWEEKCHAR1XFELD
VMONDValid on Mondays P_99S_VMONDCHAR1
VTUESValid on Tuesdays P_99S_VTUESCHAR1
VWENDValid on Wednesdays P_99S_VWENDCHAR1
VTHURValid on Thursdays P_99S_VTHURCHAR1
VFRIDValid on Fridays P_99S_VFRIDCHAR1
VSATUValid on Saturdays P_99S_VSATUCHAR1
VSUNDValid on Sundays P_99S_VSUNDCHAR1
VALIDRecord Validity: Amount P_99S_VALIDNUMC6P_99S_VALID
VUNITRecord Validity: Percentage or Days P_99S_VUNITCHAR1P_99S_VUNIT
DISTNTotal Home-Work Distance calculated by the system P_99S_DISTNDEC5P_99S_DISTN
NAME1ID for Sub-Route in Mobility Record P_99S_MNAMECHAR5P_99S_RNAME
MOBM1Means of Transport P_99S_MOBMECHAR4T5F99M1P_99S_MOBME
DSTN1Distance Traveled with Means of Transport P_99S_TMDSNDEC5P_99S_DISTN
RULE1Reimbursement Rule P_99S_CRULECHAR4T5F99M2P_99S_CRULE
TYPE1Cost Type P_99S_CTYPECHAR4T5F99M3P_99S_CTYPE
PANZ1Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL1Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
DEFL1Indicator: Use Defaults or Manual Input P_99S_DEFLDCHAR1XFELD
CAMT1HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER1Currency Key WAERSCUKY5TCURCWAERSFWS
PERC1Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE1Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
COMA1Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
PAYM1Payment Frequency P_99S_PERIONUMC1P_99S_PERIO
PAYD1First payment date DZDATEDATS8DATUM
REGN1License plate number P_KFZKZCHAR10CHAR10
MAMT1Paid Mobility Reimbursement Amount P_99S_MPAMTCURR15(2) PRBETRG
NAME2ID for Sub-Route in Mobility Record P_99S_MNAMECHAR5P_99S_RNAME
MOBM2Means of Transport P_99S_MOBMECHAR4Assigned to domainP_99S_MOBME
DSTN2Distance Traveled with Means of Transport P_99S_TMDSNDEC5P_99S_DISTN
RULE2Reimbursement Rule P_99S_CRULECHAR4T5F99M2P_99S_CRULE
TYPE2Cost Type P_99S_CTYPECHAR4T5F99M3P_99S_CTYPE
PANZ2Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL2Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
DEFL2Indicator: Use Defaults or Manual Input P_99S_DEFLDCHAR1XFELD
CAMT2HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER2Currency Key WAERSCUKY5TCURCWAERSFWS
PERC2Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE2Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
COMA2Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
PAYM2Payment Frequency P_99S_PERIONUMC1P_99S_PERIO
PAYD2First payment date DZDATEDATS8DATUM
REGN2License plate number P_KFZKZCHAR10CHAR10
MAMT2Paid Mobility Reimbursement Amount P_99S_MPAMTCURR15(2) PRBETRG
NAME3ID for Sub-Route in Mobility Record P_99S_MNAMECHAR5P_99S_RNAME
MOBM3Means of Transport P_99S_MOBMECHAR4T5F99M1P_99S_MOBME
DSTN3Distance Traveled with Means of Transport P_99S_TMDSNDEC5P_99S_DISTN
RULE3Reimbursement Rule P_99S_CRULECHAR4T5F99M2P_99S_CRULE
TYPE3Cost Type P_99S_CTYPECHAR4T5F99M3P_99S_CTYPE
PANZ3Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL3Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
DEFL3Indicator: Use Defaults or Manual Input P_99S_DEFLDCHAR1XFELD
CAMT3HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER3Currency Key WAERSCUKY5TCURCWAERSFWS
PERC3Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE3Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
COMA3Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
PAYM3Payment Frequency P_99S_PERIONUMC1P_99S_PERIO
PAYD3First payment date DZDATEDATS8DATUM
REGN3License plate number P_KFZKZCHAR10CHAR10
MAMT3Paid Mobility Reimbursement Amount P_99S_MPAMTCURR15(2) PRBETRG
NAME4ID for Sub-Route in Mobility Record P_99S_MNAMECHAR5P_99S_RNAME
MOBM4Means of Transport P_99S_MOBMECHAR4T5F99M1P_99S_MOBME
DSTN4Distance Traveled with Means of Transport P_99S_TMDSNDEC5P_99S_DISTN
RULE4Reimbursement Rule P_99S_CRULECHAR4T5F99M2P_99S_CRULE
TYPE4Cost Type P_99S_CTYPECHAR4T5F99M3P_99S_CTYPE
PANZ4Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL4Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
DEFL4Indicator: Use Defaults or Manual Input P_99S_DEFLDCHAR1XFELD
CAMT4HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER4Currency Key WAERSCUKY5TCURCWAERSFWS
PERC4Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE4Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
COMA4Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
PAYM4Payment Frequency P_99S_PERIONUMC1P_99S_PERIO
PAYD4First payment date DZDATEDATS8DATUM
REGN4License plate number P_KFZKZCHAR10CHAR10
MAMT4Paid Mobility Reimbursement Amount P_99S_MPAMTCURR15(2) PRBETRG
NAME5ID for Sub-Route in Mobility Record P_99S_MNAMECHAR5P_99S_RNAME
MOBM5Means of Transport P_99S_MOBMECHAR4T5F99M1P_99S_MOBME
DSTN5Distance Traveled with Means of Transport P_99S_TMDSNDEC5P_99S_DISTN
RULE5Reimbursement Rule P_99S_CRULECHAR4T5F99M2P_99S_CRULE
TYPE5Cost Type P_99S_CTYPECHAR4T5F99M3P_99S_CTYPE
PANZ5Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL5Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
DEFL5Indicator: Use Defaults or Manual Input P_99S_DEFLDCHAR1XFELD
CAMT5HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER5Currency Key WAERSCUKY5TCURCWAERSFWS
PERC5Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE5Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
COMA5Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
PAYM5Payment Frequency P_99S_PERIONUMC1P_99S_PERIO
PAYD5First payment date DZDATEDATS8DATUM
REGN5License plate number P_KFZKZCHAR10CHAR10
MAMT5Paid Mobility Reimbursement Amount P_99S_MPAMTCURR15(2) PRBETRG
NAME6ID for Sub-Route in Mobility Record P_99S_MNAMECHAR5P_99S_RNAME
MOBM6Means of Transport P_99S_MOBMECHAR4T5F99M1P_99S_MOBME
DSTN6Distance Traveled with Means of Transport P_99S_TMDSNDEC5P_99S_DISTN
RULE6Reimbursement Rule P_99S_CRULECHAR4T5F99M2P_99S_CRULE
TYPE6Cost Type P_99S_CTYPECHAR4T5F99M3P_99S_CTYPE
PANZ6Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL6Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
DEFL6Indicator: Use Defaults or Manual Input P_99S_DEFLDCHAR1XFELD
CAMT6HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER6Currency Key WAERSCUKY5TCURCWAERSFWS
PERC6Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE6Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
COMA6Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
PAYM6Payment Frequency P_99S_PERIONUMC1P_99S_PERIO
PAYD6First payment date DZDATEDATS8DATUM
REGN6License plate number P_KFZKZCHAR10CHAR10
MAMT6Paid Mobility Reimbursement Amount P_99S_MPAMTCURR15(2) PRBETRG
NAME7ID for Sub-Route in Mobility Record P_99S_MNAMECHAR5P_99S_RNAME
MOBM7Means of Transport P_99S_MOBMECHAR4T5F99M1P_99S_MOBME
DSTN7Distance Traveled with Means of Transport P_99S_TMDSNDEC5P_99S_DISTN
RULE7Reimbursement Rule P_99S_CRULECHAR4T5F99M2P_99S_CRULE
TYPE7Cost Type P_99S_CTYPECHAR4T5F99M3P_99S_CTYPE
PANZ7Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL7Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
DEFL7Indicator: Use Defaults or Manual Input P_99S_DEFLDCHAR1XFELD
CAMT7HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER7Currency Key WAERSCUKY5TCURCWAERSFWS
PERC7Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE7Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
COMA7Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
PAYM7Payment Frequency P_99S_PERIONUMC1P_99S_PERIO
PAYD7First payment date DZDATEDATS8DATUM
REGN7License plate number P_KFZKZCHAR10CHAR10

Key field Non-key field



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

As P0865 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 P0865 as there is no data to select.

How to access SAP table P0865

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