SAP ABAP Table P08_SXP_OXP_ENTS_ALV (SxP & OxP band changes displayed via ALV)
Hierarchy
☛
SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
⤷ PY-GB (Application Component) United Kingdom
⤷ PC08 (Package) HR accounting: GB
⤷ PY-GB (Application Component) United Kingdom
⤷ PC08 (Package) HR accounting: GB
Basic Data
Table Category | INTTAB | Structure |
Structure | P08_SXP_OXP_ENTS_ALV | Table Relationship Diagram |
Short Description | SxP & OxP band changes displayed via ALV |
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 | Absence Reporting Header | |||||
2 | .INCLUDE | 0 | 0 | HR-GB: General List output header | |||||
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
5 | WERKS | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | T500P | |
6 | NAME1 | PBTXT | TEXT30 | CHAR | 30 | 0 | Personnel Area Text | ||
7 | BTRTL | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | T001P | |
8 | BTEXT | BTRTX | TEXT15 | CHAR | 15 | 0 | Personnel Subarea Text | ||
9 | PERSG | PERSG | PERSG | CHAR | 1 | 0 | Employee Group | T501 | |
10 | PGTXT | PGTXT | TEXT20 | CHAR | 20 | 0 | Name of Employee Group | ||
11 | PERSK | PERSK | PERSK | CHAR | 2 | 0 | Employee Subgroup | T503K | |
12 | PKTXT | PKTXT | TEXT20 | CHAR | 20 | 0 | Name of Employee Subgroup | ||
13 | ORGEH | ORGEH | ORGEH | NUMC | 8 | 0 | Organizational Unit | T527X | |
14 | ORGTX | ORGTX | TEXT25 | CHAR | 25 | 0 | Short Text of Organizational Unit | ||
15 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
16 | KOSTT | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
17 | ABKRS | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | T549A | |
18 | ABKTX | ABKTX | TEXT20 | CHAR | 20 | 0 | Payroll Area Text | ||
19 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
20 | ENAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
21 | GBDAT | GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
22 | GESCH | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
23 | .INCLUDE | 0 | 0 | Absence Reporting Detail | |||||
24 | BEGDA | P08_AB_BEGDA | DATUM | DATS | 8 | 0 | Absence Start Date | ||
25 | ENDDA | P08_AB_ENDDA | DATUM | DATS | 8 | 0 | Absence End Date | ||
26 | AWART | P08_AB_AWART | AWART | CHAR | 4 | 0 | Absence Type | * | |
27 | AWATX | P08_AB_ABWTXT | TEXT25 | CHAR | 25 | 0 | Absence Type Description | ||
28 | ABSTY | P08_AB_ABSTY | ABSTY | CHAR | 2 | 0 | Absence Category | * | |
29 | ABSTX | P08_AB_ABSTXT | TEXT20 | CHAR | 20 | 0 | Absence Category Description | ||
30 | UMSKD | P08_AB_UMSKD | CHAR6 | CHAR | 6 | 0 | Absence Illness Code | ||
31 | UMSCH | P08_AB_UMSCH | TEXT20 | CHAR | 20 | 0 | Absence Illness Code Description | ||
32 | .INCLUDE | 0 | 0 | SxP and OxP band changes on a given date | |||||
33 | .INCLUDE | 0 | 0 | SxP Entitlements Left | |||||
34 | SXPEV | P08_SXP_SXPKL | P08_SXP_D_EVCLS | CHAR | 2 | 0 | SxP Entitlement Band | ||
35 | SXPET | P08_SXP_SXPKT | TEXT30 | CHAR | 30 | 0 | SxP Entitlement Band Description | ||
36 | SXPMX | P08_SXP_SXPMX | P08_SXP_WEEKS | DEC | 4 | 1 | SxP Entitlement Maximum in Weeks | ||
37 | SXPST | P08_SXP_SXPST | P08_SXP_WEEKS | DEC | 4 | 1 | SxP Entitlement Starting in Weeks | ||
38 | SXPUS | P08_SXP_SXPUS | P08_SXP_WEEKS | DEC | 4 | 1 | SxP Entitlement Used in Weeks | ||
39 | SXPLE | P08_SXP_SXPLE | P08_SXP_WEEKS | DEC | 4 | 1 | SxP Entitlement Left in Weeks | ||
40 | .INCLUDE | 0 | 0 | Int. Seniority Band | |||||
41 | MOLGA | P08_OXP_MOLGA | MOLGA | CHAR | 2 | 0 | OxP Scheme Country Grouping | * | |
42 | COVPA | P08_OXP_COVPA | COVPA | CHAR | 10 | 0 | OxP Scheme Identifier | ||
43 | COVRU | P08_OXP_COVRU | COVRU | CHAR | 10 | 0 | OxP Scheme Rule Identifier | ||
44 | TEXT0 | P08_OXP_COVTX | TEXT30 | CHAR | 30 | 0 | OxP Scheme Description | ||
45 | SEBEG | P08_OXP_SEBEG | CHAR5 | CHAR | 5 | 0 | OxP Scheme Seniority Band Start | ||
46 | SEEND | P08_OXP_SEEND | CHAR5 | CHAR | 5 | 0 | OxP Scheme Seniority Band End | ||
47 | SEUNI | P08_OXP_SUNIT | RPMSH | CHAR | 3 | 0 | OxP Scheme Seniority Time Unit | * | |
48 | TEXT1 | P08_OXP_SUNTX | TEXT20 | CHAR | 20 | 0 | OxP Scheme Seniority Time Unit Description | ||
49 | AGBEG | P08_OXP_AGBEG | CHAR5 | CHAR | 5 | 0 | OxP Scheme Age Band Start | ||
50 | AGEND | P08_OXP_AGEND | CHAR5 | CHAR | 5 | 0 | OxP Scheme Age Band End | ||
51 | AGUNI | P08_OXP_AUNIT | RPMSH | CHAR | 3 | 0 | OxP Scheme Age Time Unit | * | |
52 | TEXT2 | P08_OXP_AUNTX | TEXT20 | CHAR | 20 | 0 | OxP Scheme Age Time Unit Description | ||
53 | .INCLUDE | 0 | 0 | OxP Entitlements Left | |||||
54 | OXPEV | P08_OXP_OXPKL | BEWKL | NUMC | 2 | 0 | OxP Entitlement Band | ||
55 | OXPET | P08_OXP_OXPKT | TEXT20 | CHAR | 20 | 0 | OxP Entitlement Band Description | ||
56 | OXPMX | P08_OXP_OXPMX | P08_OSP_DEC7_1 | DEC | 8 | 2 | OxP Entitlement Maximum | ||
57 | OXPST | P08_OXP_OXPST | P08_OSP_DEC7_1 | DEC | 8 | 2 | OxP Entitlement Starting | ||
58 | OXPUS | P08_OXP_OXPUS | P08_OSP_DEC7_1 | DEC | 8 | 2 | OxP Entitlement Used | ||
59 | OXPLE | P08_OXP_OXPLE | P08_OSP_DEC7_1 | DEC | 8 | 2 | OxP Entitlement Left | ||
60 | OXPUN | P08_OXP_OXPUN | RPMSH | CHAR | 3 | 0 | OxP Entitlement Unit | * | |
61 | OXPUT | P08_OXP_OXPUT | TEXT20 | CHAR | 20 | 0 | OxP Entitlement Unit Description | ||
62 | OXPNO | P08_OXP_OXPNO | SEQNO | CHAR | 3 | 0 | OxP Entitlement Sequence Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | P08_SXP_OXP_ENTS_ALV | ABKRS | T549A | ABKRS | |||
2 | P08_SXP_OXP_ENTS_ALV | BTRTL | T001P | BTRTL | |||
3 | P08_SXP_OXP_ENTS_ALV | ORGEH | T527X | ORGEH | |||
4 | P08_SXP_OXP_ENTS_ALV | PERSG | T501 | PERSG | |||
5 | P08_SXP_OXP_ENTS_ALV | PERSK | T503K | PERSK | |||
6 | P08_SXP_OXP_ENTS_ALV | WERKS | T500P | PERSA |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 470 |