SAP ABAP Table P08_PAE_SMARTFORM (PAE Smart form Structure)

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_SMARTFORM	Table Relationship Diagram
Short Description	PAE Smart form Structure

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	HR Master Record for Infotype 3297
2	.INCLUDE	☐				0	0	Headers for Infotype Records
3	.INCLUDE	☐				0	0	Keys for HR Master Data
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
6	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
7	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
8	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
9	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
10	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
11	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
12	.INCLUDE	☐				0	0	HR Master Record: Control Field
13	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
16	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
17	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
18	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
19	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
20	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
21	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
25	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
27	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
28	.INCLUDE	☐				0	0	Pension Auto Enrolment
29	NOTUK	☐	P08_NOTUK	XFELD	CHAR	1	0	PAE: Not working in UK
30	NOTWK	☐	P08_NOTWK	XFELD	CHAR	1	0	PAE: Not a worker
31	STGDT	☐	P08_STGDT	P08_STGDT	DATS	8	0	PAE: Staging Assessment Date
32	STAGE	☐	P08_STAGE	P08_STAGE	NUMC	3	0	PAE: Staging Employee Age
33	STQER	☐	P08_STQER	P08_STQER	CURR	15	2	PAE: Staging Qualifying Earnings
34	STWRC	☐	P08_STWRC	P08_STWRC	CHAR	4	0	PAE: Staging Worker Category
35	STATY	☐	P08_STATY	P08_STATY	CHAR	1	0	PAE: Staging Earnings Assessment Type
36	STQPS	☐	P08_STQPS	P08_SCHID	CHAR	3	0	PAE: Staging Qualifying Pension Scheme	T5G30
37	STDEN	☐	P08_STDEN	P08_STDEN	DATS	8	0	PAE: Staging Date Notice Sent
38	PTNTY	☐	P08_PTNTY	P08_PTNTY	CHAR	3	0	PAE: Staging Postponement Notice Type
39	PTAGE	☐	P08_PTAGE	P08_PTAGE	NUMC	2	0	PAE: Staging Postponement Employee Age
40	PTQER	☐	P08_PTQER	P08_PTQER	CURR	15	2	PAE: Staging Postponement Qualifying Earnings
41	PTWRC	☐	P08_PTWRC	P08_PTWRC	CHAR	4	0	PAE: Staging Postponement Worker Category
42	PTATY	☐	P08_PTATY	P08_PTATY	CHAR	1	0	PAE: Staging Postponement Assessment Type
43	PTQPS	☐	P08_PTQPS	P08_SCHID	CHAR	3	0	PAE: Staging Postponement Qualifying Pension Scheme	T5G30
44	PTDEN	☐	P08_PTDEN	P08_PTDEN	DATS	8	0	PAE: Staging Postponement Date Sent - NOT USED
45	PTDDT	☐	P08_PTDDT	P08_PTDDT	DATS	8	0	PAE: Staging Postponement Date
46	PTDDN	☐	P08_PTDDN	P08_PTDDN	DATS	8	0	PAE: Staging Postponement Date - NOT USED
47	AEGDT	☐	P08_AEGDT	P08_AEGDT	DATS	8	0	PAE: Enrolment Assessment Date
48	AEAGE	☐	P08_AEAGE	P08_AEAGE	NUMC	3	0	PAE: Enrolment Employee Age
49	AEQER	☐	P08_AEQER	P08_AEQER	CURR	15	2	PAE: Enrolment Qualifying Earnings
50	AEWRC	☐	P08_AEWRC	P08_AEWRC	CHAR	4	0	PAE: Enrolment Worker Category
51	AEATY	☐	P08_AEATY	P08_AEATY	CHAR	1	0	PAE: Enrolment Earnings Assessment Type
52	AEQPS	☐	P08_AEQPS	P08_SCHID	CHAR	3	0	PAE: Enrolment Qualifying Pension Scheme	T5G30
53	AEDEN	☐	P08_AEDEN	P08_AEDEN	DATS	8	0	PAE: Enrolment Date Notice Sent
54	APTTY	☐	P08_APNTY	P08_APNTY	CHAR	3	0	PAE: Enrolment Postponement Notice Type
55	APAGE	☐	P08_APAGE	P08_APAGE	NUMC	2	0	PAE: Enrolment Postponement Employee Age
56	APQER	☐	P08_APQER	P08_APQER	CURR	15	2	PAE: Enrolment Postponement Qualifying Earnings
57	APWRC	☐	P08_APWRC	P08_APWRC	CHAR	4	0	PAE: Enrolment Postponement Worker Category
58	APATY	☐	P08_APATY	P08_APATY	CHAR	1	0	PAE: Enrolment Postponement Earnings AssessmentType
59	APQPS	☐	P08_APQPS	P08_SCHID	CHAR	3	0	PAE: Enrolment Postponement Qualifying Pension Scheme	T5G30
60	APDEN	☐	P08_APDEN	P08_APDEN	DATS	8	0	PAE: Enrolment Postponement Date Notice Sent
61	APDDT	☐	P08_APDDT	P08_APDDT	DATS	8	0	PAE: Enrolment Postponement Assessment Postponed Until Date
62	APDDN	☐	P08_APDDN	P08_APDDN	DATS	8	0	PAE: Enrolment Postponement Enrolment Date
63	OIFDT	☐	P08_OIFDT	P08_OIFDT	DATS	8	0	PAE: Opt-In Form Received Date
64	OIVFM	☐	P08_OIVFM	XFELD	CHAR	1	0	PAE: Opt-In Valid Form
65	OIAGE	☐	P08_OIAGE	P08_OIAGE	NUMC	3	0	PAE: Opt-In Employee Age
66	OIQER	☐	P08_OIQER	P08_OIQER	CURR	15	2	PAE: Opt-In Qualifying Earnings
67	OIWRC	☐	P08_OIWRC	P08_OIWRC	CHAR	4	0	PAE: Opt-In Worker Category
68	OIATY	☐	P08_OIATY	P08_OIATY	CHAR	1	0	PAE: Opt-In Earnings Assessment Type
69	OIQPS	☐	P08_OIQPS	P08_SCHID	CHAR	3	0	PAE: Opt-In Qualifying Pension Scheme	T5G30
70	OIDEN	☐	P08_OIDEN	P08_OIDEN	DATS	8	0	PAE: Opt-In Date Notice Sent - NOT USED
71	OOFDT	☐	P08_OOFDT	P08_OOFDT	DATS	8	0	PAE: Opt-Out Form Received Date
72	OOWFM	☐	P08_OOWFM	P08_OOWFM	DATS	8	0	PAE: Opt-Out Window From Date
73	OOAGE	☐	P08_OOAGE	P08_OOAGE	NUMC	3	0	PAE: Opt-Out Employee Age
74	OOQER	☐	P08_OOQER	P08_OOQER	CURR	15	2	PAE: Opt-Out Qualifying Earnings
75	OOWRC	☐	P08_OOWRC	P08_OOWRC	CHAR	4	0	PAE: Opt-Out Worker Category
76	OOVFM	☐	P08_OOVFM	XFELD	CHAR	1	0	PAE: Opt-Out Valid Form
77	OOVTO	☐	P08_OOVTO	P08_OOVTO	DATS	8	0	PAE: Opt-Out Window To Date
78	OOATY	☐	P08_OOATY	P08_OOATY	CHAR	1	0	PAE: Opt-Out Assessment Type
79	OOQPS	☐	P08_OOQPS	P08_SCHID	CHAR	3	0	PAE: Opt-Out Qualifying Pension Scheme	T5G30
80	OODEN	☐	P08_OODEN	P08_OODEN	DATS	8	0	PAE: Opt-Out Date Notice Sent - NOT USED
81	OOPDT	☐	P08_OOPDT	P08_OOPDT	DATS	8	0	PAE: Enrolment Pension Provider Date Membership Achieved
82	TPEMC	☐	P08_TPEMC	P08_TPEMC	CHAR	1	0	PAE: Transitional Period
83	OISCH	☐	P08_OISCH	P08_SCHID	CHAR	3	0	PAE: Opt-In Pension Scheme	T5G30
84	OOSCH	☐	P08_OOSCH	P08_SCHID	CHAR	3	0	PAE: Opt-Out Pension Scheme	T5G30
85	AESCH	☐	P08_AESCH	P08_SCHID	CHAR	3	0	PAE: Auto-Enrolment Scheme	T5G30
86	OONRN	☐	P08_PAE_NEST_ID_OO	CHAR20	CHAR	20	0	PAE: NEST Opt-Out Reference Number
87	.INCLUDE	☐				0	0
88	SFORM	☐	P08_AEFNAME	TDSFNAME	CHAR	30	0	AE Smart Form Name (letter)	*
89	SNAME	☐	RS38L_FNAM	FUNCNAME	CHAR	30	0	Name of Function Module	*
90	EMAIL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
91	EMAIL_ID	☐	COMM_ID_LONG	COMM_ID_LONG	CHAR	241	0	Communication: Long Identification/Number
92	FORMNAME	☐	P08_FORMNAME	CHAR30	CHAR	30	0	AE Smart Form Name
93	FORMTEXT	☐	P08_FORMTEXT	COMM_ID_LONG	CHAR	241	0	AE Smart Form Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P08_PAE_SMARTFORM	AEQPS	T5G30	SCHID
2	P08_PAE_SMARTFORM	AESCH	T5G30	SCHID		1	CN
3	P08_PAE_SMARTFORM	APQPS	T5G30	SCHID
4	P08_PAE_SMARTFORM	INFTY	T582A	INFTY
5	P08_PAE_SMARTFORM	OIQPS	T5G30	SCHID
6	P08_PAE_SMARTFORM	OISCH	T5G30	SCHID		1	CN
7	P08_PAE_SMARTFORM	OOQPS	T5G30	SCHID
8	P08_PAE_SMARTFORM	OOSCH	T5G30	SCHID		1	CN
9	P08_PAE_SMARTFORM	PREAS	T530E	PREAS
10	P08_PAE_SMARTFORM	PTQPS	T5G30	SCHID
11	P08_PAE_SMARTFORM	STQPS	T5G30	SCHID

History

Last changed by/on	SAP	20131127
SAP Release Created in