SAP ABAP Table HRECM00SALSTRUCOMPARETEXT (Comare Salary Structure with market data)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ PA-EC-JP (Application Component) Job Pricing
     ⤷ PAOC_ECM_JPR_UI (Package) Job Pricing - User Interface

Basic Data

Table Category	INTTAB	Structure
Structure	HRECM00SALSTRUCOMPARETEXT	Table Relationship Diagram
Short Description	Comare Salary Structure with 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	.INCLUDE	☐				0	0	Salary Structure Values
2	.INCLUDE	☐				0	0	Pay Grade Levels
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	T500L
5	SLTYP	☐	P_SLTYP	TRFAR	CHAR	2	0	Pay Grade Type	T510A
6	SLREG	☐	P_SLREG	TRFGB	CHAR	2	0	Pay Grade Area	T510G
7	SLGRP	☐	P_SLGRP	TRFGR	CHAR	8	0	Pay grade	T710A
8	SLLVL	☐	P_SLLVL	CHAR2	CHAR	2	0	Pay Grade Level
9	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
10	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
11	SLMIN	☐	P_SLMIN	P_AMT07V	CURR	13	2	Lower limit of pay grade level
12	SLMAX	☐	P_SLMAX	P_AMT07V	CURR	13	2	Upper limit of pay grade level
13	SLREF	☐	CMP_SLREF	P_AMT07V	CURR	13	2	Reference salary of grade level
14	JOBGROUP	☐	ECM_CJOBGRP	ECM_CJOBGRP	CHAR	8	0	Compensation Job Group	*
15	NUMBER_OF_JOBS	☐	INT4	INT4	INT4	10	0	Natural number
16	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
17	FREQUENCY	☐	ECM_FREQU	PFREQ	NUMC	2	0	Unit of Time
18	MIDPOINT	☐	MIDPT	WERT6	CURR	11	2	Mean value
19	TRFKZ	☐	TRFKZ	CHAR1	CHAR	1	0	ES grouping for collective agreement provision
20	MARKET_MIN	☐	ECM_MARKET_MIN	P_AMT08	CURR	15	2	Minimum of Aggregated Market Values
21	MARKET_MAX	☐	ECM_MARKET_MAX	P_AMT08	CURR	15	2	Maximum of Aggregated Market Values
22	MARKET_AVERAGE	☐	ECM_MARKET_AVERAGE	P_AMT08	CURR	15	2	Average of Aggregated Market Values
23	MARKET_MEDIAN	☐	ECM_MARKET_MEDIAN	P_AMT08	CURR	15	2	Median of Aggregated Market Values
24	NUMBER_MARKET_JOBS	☐	INT4	INT4	INT4	10	0	Natural number
25	DIFF_ABS_MIN	☐	ECM_PERCENTILE10	P_AMT08	CURR	15	2	10th Percentile (10% of Employees are below value)
26	DIFF_PERC_MIN	☐	ECM_DIFF_PERC_MIN	ECM_DIFF_PERC	DEC	14	2	Difference in percentage from Minimum
27	DIFF_ABS_MAX	☐	ECM_PERCENTILE10	P_AMT08	CURR	15	2	10th Percentile (10% of Employees are below value)
28	DIFF_PERC_MAX	☐	ECM_DIFF_PERC_MAX	ECM_DIFF_PERC	DEC	14	2	Difference in percentage from Maximum
29	DIFF_ABS_REF	☐	ECM_PERCENTILE10	P_AMT08	CURR	15	2	10th Percentile (10% of Employees are below value)
30	DIFF_PERC_REF	☐	ECM_DIFF_PERC_REF	ECM_DIFF_PERC	DEC	14	2	Difference in percentage from Reference
31	INCREASE_COSTS	☐	ECM_PERCENTILE10	P_AMT08	CURR	15	2	10th Percentile (10% of Employees are below value)
32	SLMIN_EXTENDED	☐	ECM_SLMIN_EXTENDED	P_AMT08V	CURR	15	2	Current Minimum of Salary Grade Level
33	SLMAX_EXTENDED	☐	ECM_SLMAX_EXTENDED	P_AMT08V	CURR	15	2	Current Maximum of Salary Grade Level
34	SLREF_EXTENDED	☐	ECM_SLREF_EXTENDED	P_AMT08V	CURR	15	2	Current Reference Salary of Salary Grade Level
35	.INCLUDE	☐				0	0	Salary structure text fields
36	COUNTRYGROUPING_TEXT	☐	ECM_TEXT_COUNTRYGRP	TEXT25	CHAR	25	0	Countrygrouping Text
37	SALARYTYPE_TEXT	☐	ECM_TEXT_SALARYTYPE	TEXT20	CHAR	20	0	Salary Type Text
38	SALARYREGION_TEXT	☐	ECM_TEXT_SALARYAREA	TEXT20	CHAR	20	0	Salary Area Text
39	FREQUENCY_TEXT	☐	ECM_TEXT_FREQUENCY	TEXT60	CHAR	60	0	Text of Time Unit

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRECM00SALSTRUCOMPARETEXT	MANDT	T000	MANDT	KEY	1	CN
2	HRECM00SALSTRUCOMPARETEXT	MOLGA	T500L	MOLGA	KEY	1	CN
3	HRECM00SALSTRUCOMPARETEXT	SLGRP	T710A	SLGRP	KEY	1	CN
4	HRECM00SALSTRUCOMPARETEXT	SLREG	T510G	TRFGB	KEY	1	CN
5	HRECM00SALSTRUCOMPARETEXT	SLTYP	T510A	TRFAR	KEY	1	CN

History

Last changed by/on	SAP	20040210
SAP Release Created in	200