1. SAP Tutorial
  2. HR Module

HRP1271 SAP table for – DB Table for Infotype 1271

Here we would like to draw your attention to HRP1271 table in SAP. As we know it is being mainly used with the SAP PA-EC (Enterprise Compensation Management in PA) component which is coming under HR (HCM) PA module (Personnel Management). HRP1271 is a SAP standard transp table used for storing DB Table for Infotype 1271 related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PAOC_ECM_JPR_BL.

SAP HRP1271 table

Table HRP1271 technical data

TableHRP1271
Data storingDB Table for Infotype 1271
ModulePA
Sub ModulePA-EC-JP
SAP PackagePAOC_ECM_JPR_BL
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-HRGXX
Table CategoryTRANSP

SAP HRP1271 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in HRP1271 table.

  • .INCLUDE : Extended Key Definition of PD Infotypes
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PLVAR : Plan Version
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OTYPE : Object Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OBJID : Object ID
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • SUBTY : Subtype
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • ISTAT : Planning Status
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • BEGDA : Start Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VARYF : Variation Field for File PLOG
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SEQNR : Number of Infotype Record With Same Key
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • INFTY : Infotype
    Its data type is CHAR (Character String) with field length 4
  • OTJID : Concatenation of Object Type and Object ID
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Infotype Administration Data
  • AEDTM : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • REASN : Reason
    Its data type is CHAR (Character String) with field length 2
  • HISTO : Historical Record Flag
    Its data type is CHAR (Character String) with field length 1
  • ITXNR : Text Module for Infotype
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • .INCLUDE : Fields for Infotype 1271 (Job Pricing Composite Results)
  • CMPRS : Survey Composite Result
    Its data type is CHAR (Character String) with field length 4
  • STATSTYPE : Pay Category
    Its data type is CHAR (Character String) with field length 2
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FREQU : Unit of Time
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • AVERAGE : Average
    Its data type is CURR (Currency Field) with field length 15
  • AVERAGEPCT : Average of Salary Expressed as Percentage of Base Salary
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • TARGETPCT : Target Bonus Expressed as Percentage of Base Salary
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ACTUALPCT : Actual Bonus Expressed as Percentage of Base Salary
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PERCENTILE10 : 10th Percentile (10% of Employees are below value)
    Its data type is CURR (Currency Field) with field length 15
  • PERCENTILE25 : 25th Percentile (25% of Employees are below value)
    Its data type is CURR (Currency Field) with field length 15
  • PERCENTILE50 : 50th Percentile (50% of Employees are below value)
    Its data type is CURR (Currency Field) with field length 15
  • PERCENTILE60 : 60th Percentile (60% of Employees are below value)
    Its data type is CURR (Currency Field) with field length 15
  • PERCENTILE75 : 75th Percentile (75% of Employees are below value)
    Its data type is CURR (Currency Field) with field length 15
  • PERCENTILE90 : 90th Percentile (90% of Employees are below value)
    Its data type is CURR (Currency Field) with field length 15
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • HRP1271 related tables

    • T71JPR18T : Survey Company Size Code Text
    • T71JPR23 : Pay Category
    • T71JPR14T : Survey Region Code Text
    • T71JPR27 : Salary Adjustment Version
    • T71JPR20 : Survey Company Type Code
    • T71JPR29 : Pay Category Attribute
    • T71JPR11 : Survey Industry
    • T71JPR26T : Survey Composite Result Text
    • T71JPR04T : Survey Job Family Text
    • T71JPR15 : Survey Revenue Size
    • T71JPR19 : Survey Company Type
    • T71JPR17 : Survey Company Size
    • T71JPR21 : Survey Length of Service
    • T71JPR03T : Survey Job Text
    • T71JPR06 : Survey Header Data
    • T71JPR23T : Pay Category Text
    • T71JPR02T : Survey Name
    • T71JPR07 : Survey General Data
    • T71JPR04 : Survey Job Family
    • T71JPR01 : Survey Provider

    HRP1271 related transaction codes under SAP package PAOC_ECM_JPR_BL

    • PECM_QUERY_SURVEY : Data Extraction for Salary Survey
    • OOECM_JP : ECM Switches for Job Pricing
    • S_P2H_60000008 : IMG Activity: HR_ECM_00_JP_004
    • PECM_ADJ_SAL_STRU : Update of Pay Grade Amounts

    Related References

    Related Tutorials

    T71JPR08 SAP table for – Survey Statistical Data

    T71JPR08 table in SAP HR PA (Enterprise Compensation Management in PA) module. This table is used for storing data of...

    T71JPR07 SAP table for – Survey General Data

    T71JPR07 table in SAP HR PA (Enterprise Compensation Management in PA) module. This table is used for storing data of...

    PA0371 SAP table for – Master Data: Infotype 0371 (Tax on previous employment)

    PA0371 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of Master...

    HRP5050 SAP table for – DB Table for Infotype 5050

    HRP5050 table in SAP HR PA (Enterprise Compensation Management in PA) module. This table is used for storing data of...

    PB0336 SAP table for – HR Master Data: Infotype 0336 (infotype 2 view – PT)

    PB0336 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    PA0336 SAP table for – HR Master Data: Infotype 0336 (infotype 2 view – PT)

    PA0336 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    PA3542 SAP table for – HR Master Record: Infotype 3542 (Previous Employers KR)

    PA3542 table in SAP HR PA (Personnel Administration in PA) module. This table is used for storing data of HR...

    «
    »