SAP ABAP Table P08_PAE_ALL (Pension Auto Enrolment 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_PAE_ALL	Table Relationship Diagram
Short Description	Pension Auto Enrolment 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	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
2	ANREX	☐	ANREX	ANREX	CHAR	5	0	Form of address text
3	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
4	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
5	NAME2	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
6	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
7	STLTX	☐	STLTX	TEXT25	CHAR	25	0	Job Title
8	PLSTX	☐	PLSTX	TEXT25	CHAR	25	0	Short Text of Position
9	LINE0	☐	P08_ADRS1	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 1
10	LINE1	☐	P08_ADRS2	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 2
11	LINE2	☐	P08_ADRS3	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 3
12	LINE3	☐	P08_ADRS4	CHAR80	CHAR	80	0	HR-GB: Legal reporting Address line 4
13	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
14	SPOOL	☐	P08_PAE_SPOOL	CHAR2	CHAR	2	0	Separate Spool File Identifier
15	SFORM	☐	P08_SMARTFORM	TDSFNAME	CHAR	30	0	Smartform Name	*
16	SNAME	☐	P08_SMARTFORM_FM	FUNCNAME	CHAR	30	0	Smartform Function Module	*
17	EMAIL	☐	P08_EMAIL_REQUIRED	XFELD	CHAR	1	0	Email Required
18	EMAIL_ID	☐	P08_EMAIL_ADDRRESS	COMM_ID_LONG	CHAR	241	0	Email Address
19	STNOT	☐	P08_PAE_NOTICE	P08_STNOT	NUMC	3	0	PAE: Noticification Type
20	ENFLG	☐	P08_PAE_ENROLMENT_TYPE	P08_ENFLG	CHAR	2	0	PAE: Enrolment Type
21	STOP	☐	P08_PAE_STOP	P08_PAE_STOP	CHAR	1	0	PAE: Indicator to stop notifications from being sent
22	AGE1	☐	P08_PAE_AGE_THRESHOLD1	P08_AGE	NUMC	3	0	PAE: Statutory Age Threshold 1
23	AGE2	☐	P08_PAE_AGE_THRESHOLD2	P08_AGE	NUMC	3	0	PAE: Statutory Age Threshold 2
24	AGE3	☐	P08_PAE_AGE_THRESHOLD3	P08_AGE	NUMC	3	0	PAE: Statutory Age Threshold 3
25	AGE4	☐	P08_PAE_AGE_THRESHOLD4	P08_AGE	NUMC	3	0	PAE: Statutory Age Threshold 4
26	EARN1	☐	P08_PAE_EARNINGS_THRESHOLD1	DEC7_2	DEC	9	2	PAE: Statutory Earnings Threshold 1
27	EARN2	☐	P08_PAE_EARNINGS_THRESHOLD2	DEC7_2	DEC	9	2	PAE: Statutory Earnings Threshold 2
28	EARN3	☐	P08_PAE_EARNINGS_THRESHOLD3	DEC7_2	DEC	9	2	PAE: Statutory Earnings Threshold 3
29	.INCLUDE	☐				0	0	Pension Auto Enrolment
30	NOTUK	☐	P08_NOTUK	XFELD	CHAR	1	0	PAE: Not working in UK
31	NOTWK	☐	P08_NOTWK	XFELD	CHAR	1	0	PAE: Not a worker
32	STGDT	☐	P08_STGDT	P08_STGDT	DATS	8	0	PAE: Staging Assessment Date
33	STAGE	☐	P08_STAGE	P08_STAGE	NUMC	3	0	PAE: Staging Employee Age
34	STQER	☐	P08_STQER	P08_STQER	CURR	15	2	PAE: Staging Qualifying Earnings
35	STWRC	☐	P08_STWRC	P08_STWRC	CHAR	4	0	PAE: Staging Worker Category
36	STATY	☐	P08_STATY	P08_STATY	CHAR	1	0	PAE: Staging Earnings Assessment Type
37	STQPS	☐	P08_STQPS	P08_SCHID	CHAR	3	0	PAE: Staging Qualifying Pension Scheme	T5G30
38	STDEN	☐	P08_STDEN	P08_STDEN	DATS	8	0	PAE: Staging Date Notice Sent
39	PTNTY	☐	P08_PTNTY	P08_PTNTY	CHAR	3	0	PAE: Staging Postponement Notice Type
40	PTAGE	☐	P08_PTAGE	P08_PTAGE	NUMC	2	0	PAE: Staging Postponement Employee Age
41	PTQER	☐	P08_PTQER	P08_PTQER	CURR	15	2	PAE: Staging Postponement Qualifying Earnings
42	PTWRC	☐	P08_PTWRC	P08_PTWRC	CHAR	4	0	PAE: Staging Postponement Worker Category
43	PTATY	☐	P08_PTATY	P08_PTATY	CHAR	1	0	PAE: Staging Postponement Assessment Type
44	PTQPS	☐	P08_PTQPS	P08_SCHID	CHAR	3	0	PAE: Staging Postponement Qualifying Pension Scheme	T5G30
45	PTDEN	☐	P08_PTDEN	P08_PTDEN	DATS	8	0	PAE: Staging Postponement Date Sent - NOT USED
46	PTDDT	☐	P08_PTDDT	P08_PTDDT	DATS	8	0	PAE: Staging Postponement Date
47	PTDDN	☐	P08_PTDDN	P08_PTDDN	DATS	8	0	PAE: Staging Postponement Date - NOT USED
48	AEGDT	☐	P08_AEGDT	P08_AEGDT	DATS	8	0	PAE: Enrolment Assessment Date
49	AEAGE	☐	P08_AEAGE	P08_AEAGE	NUMC	3	0	PAE: Enrolment Employee Age
50	AEQER	☐	P08_AEQER	P08_AEQER	CURR	15	2	PAE: Enrolment Qualifying Earnings
51	AEWRC	☐	P08_AEWRC	P08_AEWRC	CHAR	4	0	PAE: Enrolment Worker Category
52	AEATY	☐	P08_AEATY	P08_AEATY	CHAR	1	0	PAE: Enrolment Earnings Assessment Type
53	AEQPS	☐	P08_AEQPS	P08_SCHID	CHAR	3	0	PAE: Enrolment Qualifying Pension Scheme	T5G30
54	AEDEN	☐	P08_AEDEN	P08_AEDEN	DATS	8	0	PAE: Enrolment Date Notice Sent
55	APTTY	☐	P08_APNTY	P08_APNTY	CHAR	3	0	PAE: Enrolment Postponement Notice Type
56	APAGE	☐	P08_APAGE	P08_APAGE	NUMC	2	0	PAE: Enrolment Postponement Employee Age
57	APQER	☐	P08_APQER	P08_APQER	CURR	15	2	PAE: Enrolment Postponement Qualifying Earnings
58	APWRC	☐	P08_APWRC	P08_APWRC	CHAR	4	0	PAE: Enrolment Postponement Worker Category
59	APATY	☐	P08_APATY	P08_APATY	CHAR	1	0	PAE: Enrolment Postponement Earnings AssessmentType
60	APQPS	☐	P08_APQPS	P08_SCHID	CHAR	3	0	PAE: Enrolment Postponement Qualifying Pension Scheme	T5G30
61	APDEN	☐	P08_APDEN	P08_APDEN	DATS	8	0	PAE: Enrolment Postponement Date Notice Sent
62	APDDT	☐	P08_APDDT	P08_APDDT	DATS	8	0	PAE: Enrolment Postponement Assessment Postponed Until Date
63	APDDN	☐	P08_APDDN	P08_APDDN	DATS	8	0	PAE: Enrolment Postponement Enrolment Date
64	OIFDT	☐	P08_OIFDT	P08_OIFDT	DATS	8	0	PAE: Opt-In Form Received Date
65	OIVFM	☐	P08_OIVFM	XFELD	CHAR	1	0	PAE: Opt-In Valid Form
66	OIAGE	☐	P08_OIAGE	P08_OIAGE	NUMC	3	0	PAE: Opt-In Employee Age
67	OIQER	☐	P08_OIQER	P08_OIQER	CURR	15	2	PAE: Opt-In Qualifying Earnings
68	OIWRC	☐	P08_OIWRC	P08_OIWRC	CHAR	4	0	PAE: Opt-In Worker Category
69	OIATY	☐	P08_OIATY	P08_OIATY	CHAR	1	0	PAE: Opt-In Earnings Assessment Type
70	OIQPS	☐	P08_OIQPS	P08_SCHID	CHAR	3	0	PAE: Opt-In Qualifying Pension Scheme	T5G30
71	OIDEN	☐	P08_OIDEN	P08_OIDEN	DATS	8	0	PAE: Opt-In Date Notice Sent - NOT USED
72	OOFDT	☐	P08_OOFDT	P08_OOFDT	DATS	8	0	PAE: Opt-Out Form Received Date
73	OOWFM	☐	P08_OOWFM	P08_OOWFM	DATS	8	0	PAE: Opt-Out Window From Date
74	OOAGE	☐	P08_OOAGE	P08_OOAGE	NUMC	3	0	PAE: Opt-Out Employee Age
75	OOQER	☐	P08_OOQER	P08_OOQER	CURR	15	2	PAE: Opt-Out Qualifying Earnings
76	OOWRC	☐	P08_OOWRC	P08_OOWRC	CHAR	4	0	PAE: Opt-Out Worker Category
77	OOVFM	☐	P08_OOVFM	XFELD	CHAR	1	0	PAE: Opt-Out Valid Form
78	OOVTO	☐	P08_OOVTO	P08_OOVTO	DATS	8	0	PAE: Opt-Out Window To Date
79	OOATY	☐	P08_OOATY	P08_OOATY	CHAR	1	0	PAE: Opt-Out Assessment Type
80	OOQPS	☐	P08_OOQPS	P08_SCHID	CHAR	3	0	PAE: Opt-Out Qualifying Pension Scheme	T5G30
81	OODEN	☐	P08_OODEN	P08_OODEN	DATS	8	0	PAE: Opt-Out Date Notice Sent - NOT USED
82	OOPDT	☐	P08_OOPDT	P08_OOPDT	DATS	8	0	PAE: Enrolment Pension Provider Date Membership Achieved
83	TPEMC	☐	P08_TPEMC	P08_TPEMC	CHAR	1	0	PAE: Transitional Period
84	OISCH	☐	P08_OISCH	P08_SCHID	CHAR	3	0	PAE: Opt-In Pension Scheme	T5G30
85	OOSCH	☐	P08_OOSCH	P08_SCHID	CHAR	3	0	PAE: Opt-Out Pension Scheme	T5G30
86	AESCH	☐	P08_AESCH	P08_SCHID	CHAR	3	0	PAE: Auto-Enrolment Scheme	T5G30
87	OONRN	☐	P08_PAE_NEST_ID_OO	CHAR20	CHAR	20	0	PAE: NEST Opt-Out Reference Number
88	.INCLUDE	☐				0	0
89	.INCLUDE	☐				0	0	HR-GB: General List output header
90	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
91	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
92	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
93	NAME1	☐	PBTXT	TEXT30	CHAR	30	0	Personnel Area Text
94	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
95	BTEXT	☐	BTRTX	TEXT15	CHAR	15	0	Personnel Subarea Text
96	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
97	PGTXT	☐	PGTXT	TEXT20	CHAR	20	0	Name of Employee Group
98	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
99	PKTXT	☐	PKTXT	TEXT20	CHAR	20	0	Name of Employee Subgroup
100	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
101	ORGTX	☐	ORGTX	TEXT25	CHAR	25	0	Short Text of Organizational Unit
102	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
103	KOSTT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
104	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	T549A
105	ABKTX	☐	ABKTX	TEXT20	CHAR	20	0	Payroll Area Text
106	PERNR	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P08_PAE_ALL	ABKRS	T549A	ABKRS
2	P08_PAE_ALL	AEQPS	T5G30	SCHID
3	P08_PAE_ALL	AESCH	T5G30	SCHID		1	CN
4	P08_PAE_ALL	APQPS	T5G30	SCHID
5	P08_PAE_ALL	BTRTL	T001P	BTRTL
6	P08_PAE_ALL	OIQPS	T5G30	SCHID
7	P08_PAE_ALL	OISCH	T5G30	SCHID		1	CN
8	P08_PAE_ALL	OOQPS	T5G30	SCHID
9	P08_PAE_ALL	OOSCH	T5G30	SCHID		1	CN
10	P08_PAE_ALL	ORGEH	T527X	ORGEH
11	P08_PAE_ALL	PERSG	T501	PERSG
12	P08_PAE_ALL	PERSK	T503K	PERSK
13	P08_PAE_ALL	PTQPS	T5G30	SCHID
14	P08_PAE_ALL	STQPS	T5G30	SCHID
15	P08_PAE_ALL	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20131127
SAP Release Created in