1. Home
  2. Resources
  3. SAP Tables
  4. HRP1271 - DB Table for Infotype 1271

SAP Table HRP1271

DB Table for Infotype 1271

HRP1271 (DB Table for Infotype 1271) 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 HRP1271 to other SAP tables.

HRP1271 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PLVAR Plan Version PLVAR T778P CHAR 2 0
OTYPE Object Type OTYPE T778O CHAR 2 0
OBJID Object ID HROBJID PLOGI NUMC 8 0
SUBTY Subtype SUBTYP CHAR 4 0
ISTAT Planning Status ISTAT_D T778S CHAR 1 0
BEGDA Start Date BEGDATUM DATS 8 0
ENDDA End Date ENDDATUM DATS 8 0
VARYF Variation Field for File PLOG VARYF CHAR 10 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
INFTY Infotype INFOTYP T778T CHAR 4 0
OTJID Concatenation of Object Type and Object ID OTJID CHAR 10 0
AEDTM Changed on AEDTM DATS 8 0
UNAME User Name USRNAME CHAR 12 0
REASN Reason REASN CHAR 2 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXNR Text Module for Infotype ITXNR NUMC 8 0
CMPRS Survey Composite Result ECM_CMPRS T71JPR26 CHAR 4 0
STATSTYPE Pay Category ECM_STATSTYPE T71JPR23 CHAR 2 0
CURRENCY Currency Key WAERS TCURC CUKY 5 0
FREQU Unit of Time ECM_FREQU NUMC 2 0
01 Monthly
02 Semi-monthly
03 Weekly
04 Bi-weekly
05 Every four weeks
06 Annually
07 Quarterly
08 Half-yearly
AVERAGE Average ECM_AVERAGE CURR 15 2
AVERAGEPCT Average of Salary Expressed as Percentage of Base Salary ECM_AVERAGEPCT DEC 5 2
TARGETPCT Target Bonus Expressed as Percentage of Base Salary ECM_TARGETPCT DEC 5 2
ACTUALPCT Actual Bonus Expressed as Percentage of Base Salary ECM_ACTUALPCT DEC 5 2
PERCENTILE10 10th Percentile (10% of Employees are below value) ECM_PERCENTILE10 CURR 15 2
PERCENTILE25 25th Percentile (25% of Employees are below value) ECM_PERCENTILE25 CURR 15 2
PERCENTILE50 50th Percentile (50% of Employees are below value) ECM_PERCENTILE50 CURR 15 2
PERCENTILE60 60th Percentile (60% of Employees are below value) ECM_PERCENTILE60 CURR 15 2
PERCENTILE75 75th Percentile (75% of Employees are below value) ECM_PERCENTILE75 CURR 15 2
PERCENTILE90 90th Percentile (90% of Employees are below value) ECM_PERCENTILE90 CURR 15 2

HRP1271 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
HRP1271 CMPRS HRP1271 CMPRS T71JPR26 Survey Composite Result CMPRS
HRP1271 CMPRS SYST MANDT T71JPR26 Survey Composite Result MANDT
HRP1271 CURRENCY SYST MANDT TCURC Currency Codes MANDT
HRP1271 CURRENCY HRP1271 CURRENCY TCURC Currency Codes WAERS
HRP1271 INFTY HRP1271 MANDT T778T Infotypes MANDT
HRP1271 INFTY HRP1271 INFTY T778T Infotypes INFTY
HRP1271 ISTAT HRP1271 ISTAT T778S Planning Status ISTAT
HRP1271 ISTAT HRP1271 MANDT T778S Planning Status MANDT
HRP1271 MANDT HRP1271 MANDT T000 Clients MANDT
HRP1271 OBJID HRP1271 OBJID PLOGI Table Index HRP* OBJID
HRP1271 OBJID HRP1271 MANDT PLOGI Table Index HRP* MANDT
HRP1271 OBJID HRP1271 PLVAR PLOGI Table Index HRP* PLVAR
HRP1271 OBJID HRP1271 OTYPE PLOGI Table Index HRP* OTYPE
HRP1271 OTYPE HRP1271 MANDT T778O Object Types MANDT
HRP1271 OTYPE HRP1271 OTYPE T778O Object Types OTYPE
HRP1271 PLVAR HRP1271 MANDT T778P Plan Versions MANDT
HRP1271 PLVAR HRP1271 PLVAR T778P Plan Versions PLVAR
HRP1271 STATSTYPE SYST MANDT T71JPR23 Pay Category MANDT
HRP1271 STATSTYPE HRP1271 STATSTYPE T71JPR23 Pay Category STATSTYPE