P3297 SAP (HR Master Record for Infotype 3297) Structure details

Dictionary Type: Structure
Description: HR Master Record for Infotype 3297




ABAP Code to SELECT data from P3297
Related tables to P3297
Access table P3297




Structure field list including key, data, relationships and ABAP select examples

P3297 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "HR Master Record for Infotype 3297" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_P3297 TYPE P3297.

The P3297 table consists of various fields, each holding specific information or linking keys about HR Master Record for Infotype 3297 data available in SAP. These include PERNR (Personnel Number), INFTY (Infotype), SUBTY (Subtype), OBJPS (Object Identification).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP P3297 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
INFTYInfotype INFTYCHAR4T582AINFOTYPITP
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
NOTUKPAE: Not working in UK P08_NOTUKCHAR1XFELD
NOTWKPAE: Not a worker P08_NOTWKCHAR1XFELD
STGDTPAE: Staging Assessment Date P08_STGDTDATS8P08_STGDT
STAGEPAE: Staging Employee Age P08_STAGENUMC3P08_STAGE
STQERPAE: Staging Qualifying Earnings P08_STQERCURR15(2) P08_STQER
STWRCPAE: Staging Worker Category P08_STWRCCHAR4P08_STWRC
STATYPAE: Staging Earnings Assessment Type P08_STATYCHAR1P08_STATY
STQPSPAE: Staging Qualifying Pension Scheme P08_STQPSCHAR3T5G30P08_SCHID
STDENPAE: Staging Date Notice Sent P08_STDENDATS8P08_STDEN
PTNTYPAE: Staging Postponement Notice Type P08_PTNTYCHAR3P08_PTNTY
PTAGEPAE: Staging Postponement Employee Age P08_PTAGENUMC2P08_PTAGE
PTQERPAE: Staging Postponement Qualifying Earnings P08_PTQERCURR15(2) P08_PTQER
PTWRCPAE: Staging Postponement Worker Category P08_PTWRCCHAR4P08_PTWRC
PTATYPAE: Staging Postponement Assessment Type P08_PTATYCHAR1P08_PTATY
PTQPSPAE: Staging Postponement Qualifying Pension Scheme P08_PTQPSCHAR3T5G30P08_SCHID
PTDENPAE: Staging Postponement Date Sent - NOT USED P08_PTDENDATS8P08_PTDEN
PTDDTPAE: Staging Postponement Date P08_PTDDTDATS8P08_PTDDT
PTDDNPAE: Staging Postponement Date - NOT USED P08_PTDDNDATS8P08_PTDDN
AEGDTPAE: Enrolment Assessment Date P08_AEGDTDATS8P08_AEGDT
AEAGEPAE: Enrolment Employee Age P08_AEAGENUMC3P08_AEAGE
AEQERPAE: Enrolment Qualifying Earnings P08_AEQERCURR15(2) P08_AEQER
AEWRCPAE: Enrolment Worker Category P08_AEWRCCHAR4P08_AEWRC
AEATYPAE: Enrolment Earnings Assessment Type P08_AEATYCHAR1P08_AEATY
AEQPSPAE: Enrolment Qualifying Pension Scheme P08_AEQPSCHAR3T5G30P08_SCHID
AEDENPAE: Enrolment Date Notice Sent P08_AEDENDATS8P08_AEDEN
APTTYPAE: Enrolment Postponement Notice Type P08_APNTYCHAR3P08_APNTY
APAGEPAE: Enrolment Postponement Employee Age P08_APAGENUMC2P08_APAGE
APQERPAE: Enrolment Postponement Qualifying Earnings P08_APQERCURR15(2) P08_APQER
APWRCPAE: Enrolment Postponement Worker Category P08_APWRCCHAR4P08_APWRC
APATYPAE: Enrolment Postponement Earnings AssessmentType P08_APATYCHAR1P08_APATY
APQPSPAE: Enrolment Postponement Qualifying Pension Scheme P08_APQPSCHAR3T5G30P08_SCHID
APDENPAE: Enrolment Postponement Date Notice Sent P08_APDENDATS8P08_APDEN
APDDTPAE: Enrolment Postponement Assessment Postponed Until Date P08_APDDTDATS8P08_APDDT
APDDNPAE: Enrolment Postponement Enrolment Date P08_APDDNDATS8P08_APDDN
OIFDTPAE: Opt-In Form Received Date P08_OIFDTDATS8P08_OIFDT
OIVFMPAE: Opt-In Valid Form P08_OIVFMCHAR1XFIELD
OIAGEPAE: Opt-In Employee Age P08_OIAGENUMC3P08_OIAGE
OIQERPAE: Opt-In Qualifying Earnings P08_OIQERCURR15(2) P08_OIQER
OIWRCPAE: Opt-In Worker Category P08_OIWRCCHAR4P08_OIWRC
OIATYPAE: Opt-In Earnings Assessment Type P08_OIATYCHAR1P08_OIATY
OIQPSPAE: Opt-In Qualifying Pension Scheme P08_OIQPSCHAR3T5G30P08_SCHID
OIDENPAE: Opt-In Date Notice Sent - NOT USED P08_OIDENDATS8P08_OIDEN
OOFDTPAE: Opt-Out Form Received Date P08_OOFDTDATS8P08_OOFDT
OOWFMPAE: Opt-Out Window From Date P08_OOWFMDATS8P08_OOWFM
OOAGEPAE: Opt-Out Employee Age P08_OOAGENUMC3P08_OOAGE
OOQERPAE: Opt-Out Qualifying Earnings P08_OOQERCURR15(2) P08_OOQER
OOWRCPAE: Opt-Out Worker Category P08_OOWRCCHAR4P08_OOWRC
OOVFMPAE: Opt-Out Valid Form P08_OOVFMCHAR1XFIELD
OOVTOPAE: Opt-Out Window To Date P08_OOVTODATS8P08_OOVTO
OOATYPAE: Opt-Out Assessment Type P08_OOATYCHAR1P08_OOATY
OOQPSPAE: Opt-Out Qualifying Pension Scheme P08_OOQPSCHAR3T5G30P08_SCHID
OODENPAE: Opt-Out Date Notice Sent - NOT USED P08_OODENDATS8P08_OODEN
OOPDTPAE: Enrolment Pension Provider Date Membership Achieved P08_OOPDTDATS8P08_OOPDT
TPEMCPAE: Transitional Period P08_TPEMCCHAR1P08_TPEMC
OISCHPAE: Opt-In Pension Scheme P08_OISCHCHAR3T5G30P08_SCHID
OOSCHPAE: Opt-Out Pension Scheme P08_OOSCHCHAR3T5G30P08_SCHID
AESCHPAE: Auto-Enrolment Scheme P08_AESCHCHAR3T5G30P08_SCHID
OONRNPAE: NEST Opt-Out Reference Number P08_PAE_NEST_ID_OOCHAR20CHAR20

Key field Non-key field



How do I retrieve data from SAP structure P3297 using ABAP code?

As P3297 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on P3297 as there is no data to select.

How to access SAP table P3297

Within an ECC or HANA version of SAP you can also view further information about P3297 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!