SAP ABAP Table PA3297 (HR Master Record: Infotype 3297)

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PA-PA-GB (Application Component) Great Britain
     ⤷ PB08 (Package) HR master data: UK

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA3297	Table Relationship Diagram
Short Description	HR Master Record: Infotype 3297

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in