Q0865 SAP (Screen Fields Infotype 0865) Structure details

Dictionary Type: Structure
Description: Screen Fields Infotype 0865




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




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

Q0865 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 "Screen Fields Infotype 0865" 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_Q0865 TYPE Q0865.

The Q0865 table consists of various fields, each holding specific information or linking keys about Screen Fields Infotype 0865 data available in SAP. These include CCOMI (HR Payroll: Amount), WAERS (Currency Key), SBEGD (Start Date for Mobility Reimbursement Simulation), SENDD (End Date for Mobility Reimbursement Simulation).. 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 Q0865 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
CCOMTHR Payroll: Amount MAXBTCURR15(2) PRBETRG
CCOMIHR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SBEGDStart Date for Mobility Reimbursement Simulation P_99S_SBEGDDATS8
SENDDEnd Date for Mobility Reimbursement Simulation P_99S_SENDDDATS8
DUNI1Unit of distance (km) P_99S_DUNITCHAR7P_99S_DUNIT
PAYA1HR Payroll: Amount MAXBTCURR15(2) PRBETRG
DUNITUnit of distance (km) P_99S_DUNITCHAR7P_99S_DUNIT
PWAE1Currency Key WAERSCUKY5Assigned to domainWAERSFWS
MOBM1Means of Transport P_99S_MOBMECHAR4Assigned to domainP_99S_MOBME
DSTN1Total Home-Work Distance calculated by the system P_99S_DISTNDEC5P_99S_DISTN
RULE1Reimbursement Rule P_99S_CRULECHAR4Assigned to domainP_99S_CRULE
TYPE1Cost Type P_99S_CTYPECHAR4Assigned to domainP_99S_CTYPE
PANZ1Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL1Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
CAMT1HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER1Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PERC1Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE1Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
RWAE1Unit of Reimbursement Rate P_99S_RWAERCUKY5
COMA1Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
CWAE1Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PAYM1Payment Model P_99S_PAYMONUMC3P_99S_PAYMO
PAYD1First payment date DZDATEDATS8DATUM
LINK1Link to Company Car Data P_99S_LINKCHAR1P_99S_LINK
REGN1License plate number P_KFZKZCHAR10CHAR10
DUNI2Unit of distance (km) P_99S_DUNITCHAR7P_99S_DUNIT
PAYA2HR Payroll: Amount MAXBTCURR15(2) PRBETRG
PWAE2Currency Key WAERSCUKY5Assigned to domainWAERSFWS
MOBM2Means of Transport P_99S_MOBMECHAR4Assigned to domainP_99S_MOBME
DSTN2Total Home-Work Distance calculated by the system P_99S_DISTNDEC5P_99S_DISTN
RULE2Reimbursement Rule P_99S_CRULECHAR4Assigned to domainP_99S_CRULE
TYPE2Cost Type P_99S_CTYPECHAR4Assigned to domainP_99S_CTYPE
PANZ2Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL2Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
CAMT2HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER2Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PERC2Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE2Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
RWAE2Unit of Reimbursement Rate P_99S_RWAERCUKY5
COMA2Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
CWAE2Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PAYM2Payment Model P_99S_PAYMONUMC3P_99S_PAYMO
PAYD2First payment date DZDATEDATS8DATUM
DUNI3Unit of distance (km) P_99S_DUNITCHAR7P_99S_DUNIT
PAYA3HR Payroll: Amount MAXBTCURR15(2) PRBETRG
PWAE3Currency Key WAERSCUKY5Assigned to domainWAERSFWS
MOBM3Means of Transport P_99S_MOBMECHAR4Assigned to domainP_99S_MOBME
DSTN3Total Home-Work Distance calculated by the system P_99S_DISTNDEC5P_99S_DISTN
RULE3Reimbursement Rule P_99S_CRULECHAR4Assigned to domainP_99S_CRULE
TYPE3Cost Type P_99S_CTYPECHAR4Assigned to domainP_99S_CTYPE
PANZ3Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL3Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
CAMT3HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER3Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PERC3Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE3Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
RWAE3Unit of Reimbursement Rate P_99S_RWAERCUKY5
COMA3Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
CWAE3Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PAYM3Payment Model P_99S_PAYMONUMC3P_99S_PAYMO
PAYD3First payment date DZDATEDATS8DATUM
LINK3Link to Company Car Data P_99S_LINKCHAR1P_99S_LINK
REGN3License plate number P_KFZKZCHAR10CHAR10
DUNI4Unit of distance (km) P_99S_DUNITCHAR7P_99S_DUNIT
PAYA4HR Payroll: Amount MAXBTCURR15(2) PRBETRG
PWAE4Currency Key WAERSCUKY5Assigned to domainWAERSFWS
MOBM4Means of Transport P_99S_MOBMECHAR4Assigned to domainP_99S_MOBME
DSTN4Total Home-Work Distance calculated by the system P_99S_DISTNDEC5P_99S_DISTN
RULE4Reimbursement Rule P_99S_CRULECHAR4Assigned to domainP_99S_CRULE
TYPE4Cost Type P_99S_CTYPECHAR4Assigned to domainP_99S_CTYPE
PANZ4Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL4Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
CAMT4HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER4Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PERC4Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE4Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
RWAE4Unit of Reimbursement Rate P_99S_RWAERCUKY5
COMA4Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
CWAE4Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PAYM4Payment Model P_99S_PAYMONUMC3P_99S_PAYMO
PAYD4First payment date DZDATEDATS8DATUM
LINK4Link to Company Car Data P_99S_LINKCHAR1P_99S_LINK
REGN4License plate number P_KFZKZCHAR10CHAR10
DUNI5Unit of distance (km) P_99S_DUNITCHAR7P_99S_DUNIT
PAYA5HR Payroll: Amount MAXBTCURR15(2) PRBETRG
PWAE5Currency Key WAERSCUKY5Assigned to domainWAERSFWS
MOBM5Means of Transport P_99S_MOBMECHAR4Assigned to domainP_99S_MOBME
DSTN5Total Home-Work Distance calculated by the system P_99S_DISTNDEC5P_99S_DISTN
RULE5Reimbursement Rule P_99S_CRULECHAR4Assigned to domainP_99S_CRULE
TYPE5Cost Type P_99S_CTYPECHAR4Assigned to domainP_99S_CTYPE
PANZ5Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL5Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
CAMT5HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER5Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PERC5Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE5Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
RWAE5Unit of Reimbursement Rate P_99S_RWAERCUKY5
COMA5Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
CWAE5Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PAYM5Payment Model P_99S_PAYMONUMC3P_99S_PAYMO
PAYD5First payment date DZDATEDATS8DATUM
LINK5Link to Company Car Data P_99S_LINKCHAR1P_99S_LINK
REGN5License plate number P_KFZKZCHAR10CHAR10
DUNI6Unit of distance (km) P_99S_DUNITCHAR7P_99S_DUNIT
PAYA6HR Payroll: Amount MAXBTCURR15(2) PRBETRG
PWAE6Currency Key WAERSCUKY5Assigned to domainWAERSFWS
MOBM6Means of Transport P_99S_MOBMECHAR4Assigned to domainP_99S_MOBME
DSTN6Total Home-Work Distance calculated by the system P_99S_DISTNDEC5P_99S_DISTN
RULE6Reimbursement Rule P_99S_CRULECHAR4Assigned to domainP_99S_CRULE
TYPE6Cost Type P_99S_CTYPECHAR4Assigned to domainP_99S_CTYPE
PANZ6Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL6Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
CAMT6HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER6Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PERC6Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE6Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
RWAE6Unit of Reimbursement Rate P_99S_RWAERCUKY5
COMA6Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
CWAE6Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PAYM6Payment Model P_99S_PAYMONUMC3P_99S_PAYMO
PAYD6First payment date DZDATEDATS8DATUM
LINK6Link to Company Car Data P_99S_LINKCHAR1P_99S_LINK
REGN6License plate number P_KFZKZCHAR10CHAR10
DUNI7Unit of distance (km) P_99S_DUNITCHAR7P_99S_DUNIT
PAYA7HR Payroll: Amount MAXBTCURR15(2) PRBETRG
PWAE7Currency Key WAERSCUKY5Assigned to domainWAERSFWS
MOBM7Means of Transport P_99S_MOBMECHAR4Assigned to domainP_99S_MOBME
DSTN7Total Home-Work Distance calculated by the system P_99S_DISTNDEC5P_99S_DISTN
RULE7Reimbursement Rule P_99S_CRULECHAR4Assigned to domainP_99S_CRULE
TYPE7Cost Type P_99S_CTYPECHAR4Assigned to domainP_99S_CTYPE
PANZ7Cost Interval Number P_99S_PANZLNUMC3P_99S_PANZL
CVAL7Cost Interval Unit P_99S_UCVALNUMC3P_99S_PAYMO
CAMT7HR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAER7Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PERC7Reimbursement Percentage P_99S_CPERCDEC5P_99S_CPERC
RATE7Reimbursement Rate per Kilometer P_99S_CRATECURR10(2) P_99S_CRATE
RWAE7Unit of Reimbursement Rate P_99S_RWAERCUKY5
COMA7Fixed Reimbursement P_99S_CFIXECURR10(2) P_99S_CFIXE
CWAE7Currency Key WAERSCUKY5Assigned to domainWAERSFWS
PAYM7Payment Model P_99S_PAYMONUMC3P_99S_PAYMO
PAYD7First payment date DZDATEDATS8DATUM
LINK7Link to Company Car Data P_99S_LINKCHAR1P_99S_LINK
REGN7License plate number P_KFZKZCHAR10CHAR10
VALID_DAYSCheckbox RP_XFELDCHAR1XFELD
VALID_UNITCheckbox RP_XFELDCHAR1XFELD

Key field Non-key field



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

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

How to access SAP table Q0865

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