T71JPR08 - Survey Statistical Data
Survey Statistical Data information is stored in SAP table T71JPR08.
It is part of development package PAOC_ECM_JPR_BL in software component PA-EC-JP. This development package consists of objects that can be grouped under "Job Pricing - Business Logic".
It is part of development package PAOC_ECM_JPR_BL in software component PA-EC-JP. This development package consists of objects that can be grouped under "Job Pricing - Business Logic".
Fields for table T71JPR08
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| PROVIDER | Survey Provider Code | X | ECM_PROVIDER | CHAR | 4 | T71JPR01 |
| SURVEY | Survey Code | X | ECM_SURVEY | CHAR | 4 | T71JPR02 |
| SURVEYDATE | Survey Date | X | ECM_SURVEYDATE | DATS | 8 | |
| AGEDATE | Age Date | X | ECM_AGEDATE | DATS | 8 | |
| JOBCODE | Job Code | X | ECM_JOBCODE | CHAR | 8 | T71JPR03 |
| JOBLEVEL | Job Level | X | ECM_JOBLEVEL | CHAR | 2 | |
| COUNTRY | ISO Code of the Country/Region | X | INTCA | CHAR | 2 | T71JPR10 |
| INDUSTRY | Survey Industry Code | X | ECM_INDUSTRY | CHAR | 4 | T71JPR12 |
| REGION | Survey Region Code | X | ECM_REGION | CHAR | 4 | T71JPR14 |
| REVSIZE | Survey Revenue Size Code | X | ECM_REVSIZE | CHAR | 4 | T71JPR16 |
| COMSIZE | Survey Company Size Code | X | ECM_COMSIZE | CHAR | 4 | T71JPR18 |
| COMTYPE | Survey Company Type Code | X | ECM_COMTYPE | CHAR | 4 | T71JPR20 |
| SERVICE | Length of Service Code | X | ECM_SERVICE | CHAR | 4 | T71JPR22 |
| STATSTYPE | Pay Category | X | ECM_STATSTYPE | CHAR | 2 | T71JPR23 |
| NUMINCUMBENTS | Number of Incumbents Contributing to Survey Data | ECM_NUMINCUMBENTS | DEC | 4 | ||
| NUMCOMPANIES | Number of Companies Contributing to Survey Data | ECM_NUMCOMPANIES | DEC | 4 | ||
| NUMEMPLOYEES | Number of Employees Contributing to Survey Data | ECM_NUMEMPLOYEES | DEC | 4 | ||
| AVERAGE | Average | ECM_AVERAGE | CURR | 8 | ||
| AVERAGEINCS | Average of Salary Weighted by Incumbents | ECM_AVERAGEINCS | CURR | 8 | ||
| AVERAGECOS | Average of Salary Weighted by Companies | ECM_AVERAGECOS | CURR | 8 | ||
| AVERAGEPCT | Average of Salary Expressed as Percentage of Base Salary | ECM_AVERAGEPCT | DEC | 3 | ||
| TARGETPCT | Target Bonus Expressed as Percentage of Base Salary | ECM_TARGETPCT | DEC | 3 | ||
| ACTUALPCT | Actual Bonus Expressed as Percentage of Base Salary | ECM_ACTUALPCT | DEC | 3 | ||
| PERCENTILE10 | 10th Percentile (10% of Employees are below value) | ECM_PERCENTILE10 | CURR | 8 | ||
| PERCENTILE25 | 25th Percentile (25% of Employees are below value) | ECM_PERCENTILE25 | CURR | 8 | ||
| PERCENTILE50 | 50th Percentile (50% of Employees are below value) | ECM_PERCENTILE50 | CURR | 8 | ||
| PERCENTILE60 | 60th Percentile (60% of Employees are below value) | ECM_PERCENTILE60 | CURR | 8 | ||
| PERCENTILE75 | 75th Percentile (75% of Employees are below value) | ECM_PERCENTILE75 | CURR | 8 | ||
| PERCENTILE90 | 90th Percentile (90% of Employees are below value) | ECM_PERCENTILE90 | CURR | 8 |