SAP ABAP Table P08_SXP_OXP_HIST_ALV (SxP & OxP history displayed via ALV)

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PY-GB-PS (Application Component) Öffentlicher Dienst
     ⤷ P08P_ABS (Package) HR Public Sector Great Britain Absence Evaluation

Basic Data

Table Category	INTTAB	Structure
Structure	P08_SXP_OXP_HIST_ALV	Table Relationship Diagram
Short Description	SxP & OxP history 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 History on a given date
33	CDATE	☐	DATUM	DATUM	DATS	8	0	Date
34	.INCLUDE	☐				0	0	SxP History on a given date
35	P_RTYPE	☐	P08_SXP_RTYPE	P08_RTYPE	CHAR	1	0	SxP Record Type
36	P_PTYPE	☐	P08_SXP_PRDIN	P08_PRDIN	CHAR	4	0	SxP Period Indicator
37	P_ENDDA	☐	P08_SXP_P_ENDDA	DATUM	DATS	8	0	SxP Period End Date
38	P_LNKDA	☐	P08_SXP_P_LNKDA	DATUM	DATS	8	0	SxP Period Link Date
39	P_EMPTY	☐	P08_SXP_P_EMPTY	CHAR4	CHAR	4	0	SxP Period Empty Field
40	D_RTYPE	☐	P08_SXP_RTYPE	P08_RTYPE	CHAR	1	0	SxP Record Type
41	D_EVCLS	☐	P08_SXP_D_EVCLS	P08_SXP_D_EVCLS	CHAR	2	0	SxP Day Mark
42	D_BEGDA	☐	P08_SXP_D_LNKDA	DATUM	DATS	8	0	SxP Day Link Date
43	D_MPDWK	☐	P08_SXP_D_PDWKN	NUMC2	NUMC	2	0	SxP Day Paid Week Number
44	D_MABWK	☐	P08_SXP_D_ABWKN	NUMC2	NUMC	2	0	SxP Day Absence Week Number
45	D_SWKPD	☐	P08_SXP_D_SWKPD	NUMC6	NUMC	6	0	SxP Day SSP Weeks Paid
46	D_EXCLD	☐	P08_SXP_D_SXPXR	P08_SSPXR	CHAR	2	0	SxP Day Exclusion Reason	*
47	D_EMPTY	☐	P08_SXP_D_EMPTY	CHAR2	CHAR	2	0	SxP Day Empty Field
48	D_EVCTX	☐	P08_SXP_D_KLTXT	TEXT30	CHAR	30	0	SxP Day Mark Description
49	D_SWKPDF	☐	P08_SXP_D_SWKPDF	DEC2_4	DEC	6	4	SxP Day SSP Weeks Paid (formatted)
50	.INCLUDE	☐				0	0	OxP History on a given date
51	CDSEQ	☐	P08_OXP_CDSEQ	CHAR1	CHAR	1	0	OxP Absence Number
52	CDFCT	☐	P08_OXP_CDFCT	CHAR4	CHAR	4	0	OxP Day Factor
53	CRAB1	☐	P08_OXP_CRAB1	CHAR1	CHAR	1	0	OxP Absence Grouping (1st Character)
54	CQUAL	☐	P08_OXP_CQUAL	CHAR1	CHAR	1	0	OxP Qualifying Day
55	CWTDS	☐	P08_OXP_CWTDS	CHAR1	CHAR	1	0	OxP Waiting Day
56	CRAB2	☐	P08_OXP_CRAB2	CHAR1	CHAR	1	0	OxP Absence Grouping (2nd Character)
57	CREVC	☐	P08_OXP_KLBEW	BEWKL	NUMC	2	0	OxP Valuation Class
58	CREXT	☐	P08_OXP_CREXT	CHAR1	CHAR	1	0	OxP Extension or Reduction
59	CFILL	☐	P08_OXP_CFILL	CHAR8	CHAR	8	0	OxP Empty Field
60	EVCTX	☐	P08_OXP_KLTXT	TEXT20	CHAR	20	0	OxP Valuation Class Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P08_SXP_OXP_HIST_ALV	ABKRS	T549A	ABKRS
2	P08_SXP_OXP_HIST_ALV	BTRTL	T001P	BTRTL
3	P08_SXP_OXP_HIST_ALV	ORGEH	T527X	ORGEH
4	P08_SXP_OXP_HIST_ALV	PERSG	T501	PERSG
5	P08_SXP_OXP_HIST_ALV	PERSK	T503K	PERSK
6	P08_SXP_OXP_HIST_ALV	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20041209
SAP Release Created in	470