SAP ABAP Table HRP1271 (DB Table for Infotype 1271)
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 | TRANSP | Transparent table |
Transparent table | HRP1271 | Table Relationship Diagram |
Short Description | DB Table for Infotype 1271 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
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 | Extended Key Definition of PD Infotypes | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
4 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
5 | OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | PLOGI | |
6 | SUBTY | SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | * | |
7 | ISTAT | ISTAT_D | ISTAT | CHAR | 1 | 0 | Planning Status | T778S | |
8 | BEGDA | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
9 | ENDDA | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
10 | VARYF | VARYF | CHAR10 | CHAR | 10 | 0 | Variation Field for File PLOG | ||
11 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
12 | INFTY | INFOTYP | INFOTYP | CHAR | 4 | 0 | Infotype | T778T | |
13 | OTJID | OTJID | CHAR10 | CHAR | 10 | 0 | Concatenation of Object Type and Object ID | ||
14 | .INCLUDE | 0 | 0 | Infotype Administration Data | |||||
15 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
16 | UNAME | USRNAME | CHAR12 | CHAR | 12 | 0 | User Name | ||
17 | REASN | REASN | CHAR2 | CHAR | 2 | 0 | Reason | ||
18 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
19 | ITXNR | ITXNR | NUM08 | NUMC | 8 | 0 | Text Module for Infotype | ||
20 | .INCLUDE | 0 | 0 | Fields for Infotype 1271 (Job Pricing Composite Results) | |||||
21 | CMPRS | ECM_CMPRS | ECM_CMPRS | CHAR | 4 | 0 | Survey Composite Result | T71JPR26 | |
22 | STATSTYPE | ECM_STATSTYPE | ECM_STATSTYPE | CHAR | 2 | 0 | Pay Category | T71JPR23 | |
23 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
24 | FREQU | ECM_FREQU | PFREQ | NUMC | 2 | 0 | Unit of Time | ||
25 | AVERAGE | ECM_AVERAGE | P_AMT08 | CURR | 15 | 2 | Average | ||
26 | AVERAGEPCT | ECM_AVERAGEPCT | DEC3_2 | DEC | 5 | 2 | Average of Salary Expressed as Percentage of Base Salary | ||
27 | TARGETPCT | ECM_TARGETPCT | DEC3_2 | DEC | 5 | 2 | Target Bonus Expressed as Percentage of Base Salary | ||
28 | ACTUALPCT | ECM_ACTUALPCT | DEC3_2 | DEC | 5 | 2 | Actual Bonus Expressed as Percentage of Base Salary | ||
29 | PERCENTILE10 | ECM_PERCENTILE10 | P_AMT08 | CURR | 15 | 2 | 10th Percentile (10% of Employees are below value) | ||
30 | PERCENTILE25 | ECM_PERCENTILE25 | P_AMT08 | CURR | 15 | 2 | 25th Percentile (25% of Employees are below value) | ||
31 | PERCENTILE50 | ECM_PERCENTILE50 | P_AMT08 | CURR | 15 | 2 | 50th Percentile (50% of Employees are below value) | ||
32 | PERCENTILE60 | ECM_PERCENTILE60 | P_AMT08 | CURR | 15 | 2 | 60th Percentile (60% of Employees are below value) | ||
33 | PERCENTILE75 | ECM_PERCENTILE75 | P_AMT08 | CURR | 15 | 2 | 75th Percentile (75% of Employees are below value) | ||
34 | PERCENTILE90 | ECM_PERCENTILE90 | P_AMT08 | CURR | 15 | 2 | 90th Percentile (90% of Employees are below value) | ||
35 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HRP1271 | CMPRS | T71JPR26 | CMPRS | KEY | 1 | CN |
2 | HRP1271 | CURRENCY | TCURC | WAERS | REF | 1 | CN |
3 | HRP1271 | INFTY | T778T | INFTY | KEY | 1 | CN |
4 | HRP1271 | ISTAT | T778S | ISTAT | KEY | 1 | CN |
5 | HRP1271 | MANDT | T000 | MANDT | KEY | 1 | CN |
6 | HRP1271 | OBJID | PLOGI | OBJID | KEY | 1 | CN |
7 | HRP1271 | OTYPE | T778O | OTYPE | KEY | 1 | CN |
8 | HRP1271 | PLVAR | T778P | PLVAR | KEY | 1 | CN |
9 | HRP1271 | STATSTYPE | T71JPR23 | STATSTYPE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |