SAP ABAP Table P3297 (HR Master Record for 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	INTTAB	Structure
Structure	P3297	Table Relationship Diagram
Short Description	HR Master Record for Infotype 3297

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

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in