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

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