SAP ABAP Table HRECM00BW_IS_SVMARKETDATA (BW Extract for Survey Market Data)
Hierarchy
☛
EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
⤷ PA-EC-JP (Application Component) Job Pricing
⤷ PAOC_ECM_JPR_BL (Package) Job Pricing - Business Logic
⤷ PA-EC-JP (Application Component) Job Pricing
⤷ PAOC_ECM_JPR_BL (Package) Job Pricing - Business Logic
Basic Data
Table Category | INTTAB | Structure |
Structure | HRECM00BW_IS_SVMARKETDATA | Table Relationship Diagram |
Short Description | BW Extract for Survey Market Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | PROVIDER | ECM_PROVIDER | ECM_PROVIDER | CHAR | 4 | 0 | Survey Provider Code | * | |
2 | JOBCODE | ECM_JOBCODE | ECM_JOBCODE | CHAR | 8 | 0 | Job Code | * | |
3 | JOBLEVEL | ECM_JOBLEVEL | CHAR2 | CHAR | 2 | 0 | Job Level | ||
4 | SURVEY | ECM_SURVEY | ECM_SURVEY | CHAR | 4 | 0 | Survey Code | * | |
5 | CALDAY | ECM_SURVEYDATE | DATUM | DATS | 8 | 0 | Survey Date | ||
6 | AGEDATE | ECM_AGEDATE | DATUM | DATS | 8 | 0 | Age Date | ||
7 | AGEFAC | ECM_AGEFAC | DEC3_2 | DEC | 5 | 2 | Survey Age Factor in Percent | ||
8 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
9 | FREQU | ECM_FREQU | PFREQ | NUMC | 2 | 0 | Unit of Time | ||
10 | FLSASTAT | ECM_FLSASTAT | CHAR1 | CHAR | 1 | 0 | Job Status according to FLSA | ||
11 | JMATCHPC | ECM_JMATCHPCT | DEC3_2 | DEC | 5 | 2 | Job Matching Percentage | ||
12 | RANGEMIN | ECM_RANGEMIN | P_AMT08 | CURR | 15 | 2 | Salary Range Minimum | ||
13 | RANGEMID | ECM_RANGEMID | P_AMT08 | CURR | 15 | 2 | Salary Range Midpoint | ||
14 | RANGEMAX | ECM_RANGEMAX | P_AMT08 | CURR | 15 | 2 | Salary Range Maximum | ||
15 | PAYCAT | ECM_STATSTYPE | ECM_STATSTYPE | CHAR | 2 | 0 | Pay Category | * | |
16 | COUNTRY | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
17 | INDUSTRY | ECM_INDUSTRY | ECM_INDUSTRY | CHAR | 4 | 0 | Survey Industry Code | * | |
18 | REGION | ECM_REGION | ECM_REGION | CHAR | 4 | 0 | Survey Region Code | * | |
19 | REVSIZE | ECM_REVSIZE | ECM_REVSIZE | CHAR | 4 | 0 | Survey Revenue Size Code | * | |
20 | COMSIZE | ECM_COMSIZE | ECM_COMSIZE | CHAR | 4 | 0 | Survey Company Size Code | * | |
21 | COMTYPE | ECM_COMTYPE | ECM_COMTYPE | CHAR | 4 | 0 | Survey Company Type Code | * | |
22 | SERVICE | ECM_SERVICE | ECM_SERVICE | CHAR | 4 | 0 | Length of Service Code | * | |
23 | NUMINCS | ECM_NUMINCUMBENTS | DEC7 | DEC | 7 | 0 | Number of Incumbents Contributing to Survey Data | ||
24 | NUMCOS | ECM_NUMCOMPANIES | DEC7 | DEC | 7 | 0 | Number of Companies Contributing to Survey Data | ||
25 | NUMEMPL | ECM_NUMEMPLOYEES | DEC7 | DEC | 7 | 0 | Number of Employees Contributing to Survey Data | ||
26 | AVERAGE | ECM_AVERAGE | P_AMT08 | CURR | 15 | 2 | Average | ||
27 | PERC_10 | ECM_PERCENTILE10 | P_AMT08 | CURR | 15 | 2 | 10th Percentile (10% of Employees are below value) | ||
28 | PERC_25 | ECM_PERCENTILE25 | P_AMT08 | CURR | 15 | 2 | 25th Percentile (25% of Employees are below value) | ||
29 | PERC_50 | ECM_PERCENTILE50 | P_AMT08 | CURR | 15 | 2 | 50th Percentile (50% of Employees are below value) | ||
30 | PERC_60 | ECM_PERCENTILE60 | P_AMT08 | CURR | 15 | 2 | 60th Percentile (60% of Employees are below value) | ||
31 | PERC_75 | ECM_PERCENTILE75 | P_AMT08 | CURR | 15 | 2 | 75th Percentile (75% of Employees are below value) | ||
32 | PERC_90 | ECM_PERCENTILE90 | P_AMT08 | CURR | 15 | 2 | 90th Percentile (90% of Employees are below value) |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 200 |