1. SAP Tutorial
  2. HR Module

T71JPR08 SAP table for – Survey Statistical Data

Here we would like to draw your attention to T71JPR08 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). T71JPR08 is a SAP standard transp table used for storing Survey Statistical Data 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 T71JPR08 table

Table T71JPR08 technical data

TableT71JPR08
Data storingSurvey Statistical Data
ModulePA
Sub ModulePA-EC-JP
SAP PackagePAOC_ECM_JPR_BL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-HRGXX
Table CategoryTRANSP

SAP T71JPR08 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 T71JPR08 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PROVIDER : Survey Provider Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SURVEY : Survey Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SURVEYDATE : Survey Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AGEDATE : Age Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • JOBCODE : Job Code
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • JOBLEVEL : Job Level
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • COUNTRY : Country ISO code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • INDUSTRY : Survey Industry Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • REGION : Survey Region Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • REVSIZE : Survey Revenue Size Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • COMSIZE : Survey Company Size Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • COMTYPE : Survey Company Type Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SERVICE : Length of Service Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • STATSTYPE : Pay Category
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • NUMINCUMBENTS : Number of Incumbents Contributing to Survey Data
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • NUMCOMPANIES : Number of Companies Contributing to Survey Data
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • NUMEMPLOYEES : Number of Employees Contributing to Survey Data
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • AVERAGE : Average
    Its data type is CURR (Currency Field) with field length 15
  • AVERAGEINCS : Average of Salary Weighted by Incumbents
    Its data type is CURR (Currency Field) with field length 15
  • AVERAGECOS : Average of Salary Weighted by Companies
    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

    • T71JPR08 related tables

    • T71JPR09 : Survey Job / Internal Job Matching Data
    • T71JPR19 : Survey Company Type
    • T71JPR26T : Survey Composite Result Text
    • T71JPR24 : Survey Data Fields Mapping
    • T71JPR02 : Survey
    • T71JPR22T : Survey Length of Service Code Text
    • HRP5050 : DB Table for Infotype 5050
    • T71JPR25 : Salary Range Adjustment
    • T71JPR13 : Survey Region
    • T71JPR21 : Survey Length of Service
    • T71JPR12T : Survey Industry Code Text
    • T71JPR07 : Survey General Data
    • T71JPR17 : Survey Company Size
    • T71JPR12 : Survey Industry Code
    • T71JPR14 : Survey Region Code
    • T71JPR27T : Salary Adjustment Version Text
    • T71JPR11 : Survey Industry
    • HRP1271 : DB Table for Infotype 1271
    • T71JPR23T : Pay Category Text
    • T71JPR28T : Compensation Job Group Text

    T71JPR08 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

    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...

    T71JPR24 SAP table for – Survey Data Fields Mapping

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

    T71JPR06 SAP table for – Survey Header Data

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

    PECM_QUERY_SURVEY SAP tcode for – Data Extraction for Salary Survey

    PECM_QUERY_SURVEY tcode in SAP HR PA (Enterprise Compensation Management in PA) module. This transaction code is used for Data Extraction...

    T71JPR09 SAP table for – Survey Job / Internal Job Matching Data

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

    T71JPR02 SAP table for – Survey

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

    T71JPR02T SAP table for – Survey Name

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

    «
    »