P28_P0528 SAP (HR Master Record: Infotype 0021/0528 (Family/Rel.Person CN)) Structure details

Dictionary Type: Structure
Description: HR Master Record: Infotype 0021/0528 (Family/Rel.Person CN)




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




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

P28_P0528 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: Infotype 0021/0528 (Family/Rel.Person CN)" 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_P28_P0528 TYPE P28_P0528.

The P28_P0528 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0021/0528 (Family/Rel.Person CN) data available in SAP. These include EMPLOYEENO (Personnel Number), SUBTYPE (Subtype), OBJECTID (Object Identification), LOCKINDIC (Lock Indicator for HR Master Data Record).. 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: Not classified


SAP P28_P0528 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
EMPLOYEENOPersonnel Number PERNR_DNUMC8PERNRPER
SUBTYPESubtype SUBTYCHAR4SUBTYSUB
OBJECTIDObject Identification OBJPSCHAR2OBJPSOPS
LOCKINDICLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
VALIDENDEnd Date ENDDADATS8DATUM
VALIDBEGINStart Date BEGDADATS8DATUM
RECORDNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
MEMBERTYPEType of Family Record FAMSACHAR4SUBTY
FIRSTNAMEFirst Name PAD_VORNACHAR40PAD_VORNM
LASTNAMELast Name PAD_NACHNCHAR40PAD_NACHN
DATEOFBIRTHDate of Birth GBDATDATS8PDATEGBDAT
AGEAge PCN_FAAGECHAR3CHAR3
PLACEOFBIRTHBirthplace PAD_GBORTCHAR40PAD_ORT01
LANDOFBIRTHCountry of Birth GBLNDCHAR3Assigned to domainLAND1
NATIONALITYNationality NATSLCHAR3Assigned to domainLAND1NAT
GENDERGender Key GESCHCHAR1GESCH
NAMEOFGENDERShort Description of Repository Objects AS4TEXTCHAR60AS4TEXT
NAMEOFLANDOFBIRTHCountry Name LANDXCHAR15TEXT15
NAMEOFNATIONALITYNationality NATIOCHAR15TEXT15
NAMEOFMEMBERTYPEName of Subtype SBTTXCHAR40TEXT40
ID1TYPEType of identification (IC type) ICTYPCHAR2Assigned to domainICTYP
ID1NUMBERIdentification number PCN_IDNUMCHAR20TEXT20
ID2TYPEType of identification (IC type) ICTYPCHAR2Assigned to domainICTYP
ID2NUMBERIdentification number PCN_IDNUMCHAR20TEXT20
ID3TYPEType of identification (IC type) ICTYPCHAR2Assigned to domainICTYP
ID3NUMBERIdentification number PCN_IDNUMCHAR20TEXT20
ID4TYPEType of identification (IC type) ICTYPCHAR2Assigned to domainICTYP
ID4NUMBERIdentification number PCN_IDNUMCHAR20TEXT20
ID5TYPEType of identification (IC type) ICTYPCHAR2Assigned to domainICTYP
ID5NUMBERIdentification number PCN_IDNUMCHAR20TEXT20
TELEPHONENUMBERTelephone number PCN_TELNRCHAR20CHAR20
SAMECOMPANYINDICIndicator: Work in same company PCN_SAMERCHAR1XFELD
MARITALSTATUSMarital Status Key FAMSTCHAR1Assigned to domainFAMST
MARITALSTATUSSINValid From Date of Current Marital Status FAMDTDATS8DATUM
POLITICALSTATUSPolitical status PCN_PCODECHAR2Assigned to domainPCN_PCODE
OCCUPATIONKEYOccupation PCN_OCCTYCHAR8Assigned to domainPCN_OCCTY
JOBSTATUSKEYJob status PCN_STATUCHAR2Assigned to domainPCN_STATU
FORMOFADDRESSKEYForm-of-Address Key ANRDECHAR1Assigned to domainANRDE
FULLNAMEName of referenced personnel number FEDNMCHAR40TEXT40
NAMEFORMATINDICName Format Indicator for Employee in a List KNZNMNUMC2KNZN2
CONTACT1TYPECommunication Type COMKYCHAR4Assigned to domainCOMKY
CONTACT1NUMBERCommunication Number COMNRCHAR20CHAR20
CONTACT2TYPECommunication Type COMKYCHAR4Assigned to domainCOMKY
CONTACT2NUMBERCommunication Number COMNRCHAR20CHAR20
CONTACT3TYPECommunication Type COMKYCHAR4Assigned to domainCOMKY
CONTACT3NUMBERCommunication Number COMNRCHAR20CHAR20
CONTACT4TYPECommunication Type COMKYCHAR4Assigned to domainCOMKY
CONTACT4NUMBERCommunication Number COMNRCHAR20CHAR20
POSTALCODEPostal Code PSTLZ_HRCHAR10PSTLZ
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
PROVINCESTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
CITYCity PAD_ORT01CHAR40PAD_ORT01
DISTRICTDistrict PAD_ORT02CHAR40PAD_ORT01
STREETStreet and House Number PAD_STRASCHAR60PAD_STRAS
FULLADDRESSFull address PCN_FULLACHAR60TEXT60
EMPLOYERADDRKEYEmployer of Family Member EGAGACHAR8VARGA
NAMEOFCOUNTRYCountry Name LANDXCHAR15TEXT15
NAMEOFPROVINCEDescription BEZEI20CHAR20TEXT20
EMPLOYERADDRESSAddress Text (Name, Street, City, Tel. No.) ADRTXCHAR40TEXT40
NAMEOFOCCUPATIONOccupation text PCN_INLTXCHAR40TEXT40
NAMEOFJOBSTATUSJob status text PCN_STEXTCHAR20TEXT20
NAMEPOLITISTATUSPolitical status text PCN_PTEXTCHAR40TEXT40
NAMEMARITALSTATSMarital Status FATXTCHAR6FATXT
NAMEFORMADDRESForm of address text ANREXCHAR5ANREX
ID1TYPETEXTIC description ICTXTCHAR30TEXT30
ID2TYPETEXTIC description ICTXTCHAR30TEXT30
ID3TYPETEXTIC description ICTXTCHAR30TEXT30
ID4TYPETEXTIC description ICTXTCHAR30TEXT30
ID5TYPETEXTIC description ICTXTCHAR30TEXT30

Key field Non-key field



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

As P28_P0528 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 P28_P0528 as there is no data to select.

How to access SAP table P28_P0528

Within an ECC or HANA version of SAP you can also view further information about P28_P0528 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!