PA0528

Transparent Table Application Table
59 Fields 2 CDS Views

HR Master Record: Infotype 0528 (Family information)

PA0528 is an SAP database table in S/4HANA. HR Master Record: Infotype 0528 (Family information). It contains 59 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CN_HCMFamilyMemberSupplement view_entity from EXTENSION CN HCM Family Member - Extension
I_CN_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement CN

Fields (59)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr PERSNO Personnel No.
KEY subty SUBTY Subtype
KEY objps OBJPS Object ID
KEY sprps SPRPS Lock indicator
KEY endda ENDDA End Date
KEY begda BEGDA Start Date
KEY seqnr SEQNR IT record no.
aedtm AEDAT Changed On
uname AENAM Changed By
histo HISTO Historical rec.
itxex ITXEX Text exists
refex PRFEX Ref. exists
ordex ORDEX Conf.fields ex.
itbld ITBLD Screen control
preas PREAS Change Reason
flag1 NUSED Reserved Field/Unused Field
flag2 NUSED Reserved Field/Unused Field
flag3 NUSED Reserved Field/Unused Field
flag4 NUSED Reserved Field/Unused Field
rese1 NUSED2 Reserved Field/Unused Field of Length 2
rese2 NUSED2 Reserved Field/Unused Field of Length 2
grpvl PCCE_GPVAL Grouping Value
icty1 ICTYP ID Type
idnm1 PCN_IDNUM Id. number
icty2 ICTYP ID Type
idnm2 PCN_IDNUM Id. number
icty3 ICTYP ID Type
idnm3 PCN_IDNUM Id. number
icty4 ICTYP ID Type
idnm4 PCN_IDNUM Id. number
icty5 ICTYP ID Type
idnm5 PCN_IDNUM Id. number
telnr PCN_TELNR Telephone number
samer PCN_SAMER same company
famst FAMST Marital stat.
famdt FAMDT Since
pstat PCN_PCODE Political status
occup PCN_OCCTY Occupation
statu PCN_STATU Job status
anred ANRDE FOA key
com01 COMKY Type
num01 COMNR Number
com02 COMKY Type
num02 COMNR Number
com03 COMKY Type
num03 COMNR Number
com04 COMKY Type
num04 COMNR Number
pstlz PSTLZ_HR P.code/city
land1 LAND1 Country/Reg.
state REGIO Region
city1 PAD_ORT01 City
distr PAD_ORT02 District
stras PAD_STRAS Street/House
cnnam PCN_CNNAM Chinese name
olchd PCN_OLCHD Only Child
olnum PCN_OLNUM Certificate ID
olcdt PCN_OLCDT Certificate Dte

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- HR Master Record: Infotype 0528 (Family information)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0528 (
    MANDT,  -- Client [MANDT]
    PERNR,  -- Personnel No. [PERSNO]
    SUBTY,  -- Subtype [SUBTY]
    OBJPS,  -- Object ID [OBJPS]
    SPRPS,  -- Lock indicator [SPRPS]
    ENDDA,  -- End Date [ENDDA]
    BEGDA,  -- Start Date [BEGDA]
    SEQNR,  -- IT record no. [SEQNR]
    AEDTM,  -- Changed On [AEDAT]
    UNAME,  -- Changed By [AENAM]
    HISTO,  -- Historical rec. [HISTO]
    ITXEX,  -- Text exists [ITXEX]
    REFEX,  -- Ref. exists [PRFEX]
    ORDEX,  -- Conf.fields ex. [ORDEX]
    ITBLD,  -- Screen control [ITBLD]
    PREAS,  -- Change Reason [PREAS]
    FLAG1,  -- Reserved Field/Unused Field [NUSED]
    FLAG2,  -- Reserved Field/Unused Field [NUSED]
    FLAG3,  -- Reserved Field/Unused Field [NUSED]
    FLAG4,  -- Reserved Field/Unused Field [NUSED]
    RESE1,  -- Reserved Field/Unused Field of Length 2 [NUSED2]
    RESE2,  -- Reserved Field/Unused Field of Length 2 [NUSED2]
    GRPVL,  -- Grouping Value [PCCE_GPVAL]
    ICTY1,  -- ID Type [ICTYP]
    IDNM1,  -- Id. number [PCN_IDNUM]
    ICTY2,  -- ID Type [ICTYP]
    IDNM2,  -- Id. number [PCN_IDNUM]
    ICTY3,  -- ID Type [ICTYP]
    IDNM3,  -- Id. number [PCN_IDNUM]
    ICTY4,  -- ID Type [ICTYP]
    IDNM4,  -- Id. number [PCN_IDNUM]
    ICTY5,  -- ID Type [ICTYP]
    IDNM5,  -- Id. number [PCN_IDNUM]
    TELNR,  -- Telephone number [PCN_TELNR]
    SAMER,  -- same company [PCN_SAMER]
    FAMST,  -- Marital stat. [FAMST]
    FAMDT,  -- Since [FAMDT]
    PSTAT,  -- Political status [PCN_PCODE]
    OCCUP,  -- Occupation [PCN_OCCTY]
    STATU,  -- Job status [PCN_STATU]
    ANRED,  -- FOA key [ANRDE]
    COM01,  -- Type [COMKY]
    NUM01,  -- Number [COMNR]
    COM02,  -- Type [COMKY]
    NUM02,  -- Number [COMNR]
    COM03,  -- Type [COMKY]
    NUM03,  -- Number [COMNR]
    COM04,  -- Type [COMKY]
    NUM04,  -- Number [COMNR]
    PSTLZ,  -- P.code/city [PSTLZ_HR]
    LAND1,  -- Country/Reg. [LAND1]
    STATE,  -- Region [REGIO]
    CITY1,  -- City [PAD_ORT01]
    DISTR,  -- District [PAD_ORT02]
    STRAS,  -- Street/House [PAD_STRAS]
    CNNAM,  -- Chinese name [PCN_CNNAM]
    OLCHD,  -- Only Child [PCN_OLCHD]
    OLNUM,  -- Certificate ID [PCN_OLNUM]
    OLCDT,  -- Certificate Dte [PCN_OLCDT]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More