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