SAP ABAP Table T71JPR08 (Survey Statistical 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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T71JPR08	Table Relationship Diagram
Short Description	Survey Statistical Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PROVIDER	☑	ECM_PROVIDER	ECM_PROVIDER	CHAR	4	0	Survey Provider Code	T71JPR01
3	SURVEY	☑	ECM_SURVEY	ECM_SURVEY	CHAR	4	0	Survey Code	T71JPR02
4	SURVEYDATE	☑	ECM_SURVEYDATE	DATUM	DATS	8	0	Survey Date
5	AGEDATE	☑	ECM_AGEDATE	DATUM	DATS	8	0	Age Date
6	JOBCODE	☑	ECM_JOBCODE	ECM_JOBCODE	CHAR	8	0	Job Code	T71JPR03
7	JOBLEVEL	☑	ECM_JOBLEVEL	CHAR2	CHAR	2	0	Job Level
8	COUNTRY	☑	INTCA	INTCA	CHAR	2	0	Country ISO code	T71JPR10
9	INDUSTRY	☑	ECM_INDUSTRY	ECM_INDUSTRY	CHAR	4	0	Survey Industry Code	T71JPR12
10	REGION	☑	ECM_REGION	ECM_REGION	CHAR	4	0	Survey Region Code	T71JPR14
11	REVSIZE	☑	ECM_REVSIZE	ECM_REVSIZE	CHAR	4	0	Survey Revenue Size Code	T71JPR16
12	COMSIZE	☑	ECM_COMSIZE	ECM_COMSIZE	CHAR	4	0	Survey Company Size Code	T71JPR18
13	COMTYPE	☑	ECM_COMTYPE	ECM_COMTYPE	CHAR	4	0	Survey Company Type Code	T71JPR20
14	SERVICE	☑	ECM_SERVICE	ECM_SERVICE	CHAR	4	0	Length of Service Code	T71JPR22
15	STATSTYPE	☑	ECM_STATSTYPE	ECM_STATSTYPE	CHAR	2	0	Pay Category	T71JPR23
16	NUMINCUMBENTS	☐	ECM_NUMINCUMBENTS	DEC7	DEC	7	0	Number of Incumbents Contributing to Survey Data
17	NUMCOMPANIES	☐	ECM_NUMCOMPANIES	DEC7	DEC	7	0	Number of Companies Contributing to Survey Data
18	NUMEMPLOYEES	☐	ECM_NUMEMPLOYEES	DEC7	DEC	7	0	Number of Employees Contributing to Survey Data
19	AVERAGE	☐	ECM_AVERAGE	P_AMT08	CURR	15	2	Average
20	AVERAGEINCS	☐	ECM_AVERAGEINCS	P_AMT08	CURR	15	2	Average of Salary Weighted by Incumbents
21	AVERAGECOS	☐	ECM_AVERAGECOS	P_AMT08	CURR	15	2	Average of Salary Weighted by Companies
22	AVERAGEPCT	☐	ECM_AVERAGEPCT	DEC3_2	DEC	5	2	Average of Salary Expressed as Percentage of Base Salary
23	TARGETPCT	☐	ECM_TARGETPCT	DEC3_2	DEC	5	2	Target Bonus Expressed as Percentage of Base Salary
24	ACTUALPCT	☐	ECM_ACTUALPCT	DEC3_2	DEC	5	2	Actual Bonus Expressed as Percentage of Base Salary
25	PERCENTILE10	☐	ECM_PERCENTILE10	P_AMT08	CURR	15	2	10th Percentile (10% of Employees are below value)
26	PERCENTILE25	☐	ECM_PERCENTILE25	P_AMT08	CURR	15	2	25th Percentile (25% of Employees are below value)
27	PERCENTILE50	☐	ECM_PERCENTILE50	P_AMT08	CURR	15	2	50th Percentile (50% of Employees are below value)
28	PERCENTILE60	☐	ECM_PERCENTILE60	P_AMT08	CURR	15	2	60th Percentile (60% of Employees are below value)
29	PERCENTILE75	☐	ECM_PERCENTILE75	P_AMT08	CURR	15	2	75th Percentile (75% of Employees are below value)
30	PERCENTILE90	☐	ECM_PERCENTILE90	P_AMT08	CURR	15	2	90th Percentile (90% of Employees are below value)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T71JPR08	COMSIZE	T71JPR18	COMSIZE	KEY	C	CN
2	T71JPR08	COMTYPE	T71JPR20	COMTYPE	KEY	C	CN
3	T71JPR08	COUNTRY	T71JPR10	COUNTRY	KEY	C	CN
4	T71JPR08	INDUSTRY	T71JPR12	INDUSTRY	KEY	C	CN
5	T71JPR08	JOBCODE	T71JPR03	JOBCODE	KEY	1	CN
6	T71JPR08	MANDT	T000	MANDT	KEY	1	CN
7	T71JPR08	PROVIDER	T71JPR01	PROVIDER	KEY	1	CN
8	T71JPR08	REGION	T71JPR14	REGION	KEY	C	CN
9	T71JPR08	REVSIZE	T71JPR16	REVSIZE	KEY	C	CN
10	T71JPR08	SERVICE	T71JPR22	SERVICE	KEY	C	CN
11	T71JPR08	STATSTYPE	T71JPR23	STATSTYPE	KEY	1	CN
12	T71JPR08	SURVEY	T71JPR02	SURVEY	KEY	1	CN

History

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