PA0397

Transparent Table Application Table
56 Fields 2 CDS Views

Infotype 0021 Family

PA0397 is an SAP database table in S/4HANA. Infotype 0021 Family. It contains 56 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BR_HCMFamilyMemberSupplement view_entity from EXTENSION BR HCM Family Member - Extension
I_BR_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement BR

Fields (56)

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
ufbot REGIO Region
stinv PBR_STINV Challenged dep.
escol PBR_FASAR Education level
salfa PBR_SALFA Child allowance
irflg PBR_IRFLG Income tax
serie PBR_SERIE Grade
moden PBR_MODEN Specification
escoa PBR_ESCOA School
dtcvc PBR_DTCVC Vac.card exp.
saled PBR_SALED Educ.allowance
estud PBR_STUDE Student
fuman PBR_FUMAN Smoker
carto PBR_CARTO Pub.notary name
noreg PBR_NOREG Record number
noliv PBR_NOLIV Ledger number
nofol PBR_NOFOL Sheet number
dtent PBR_DTENT Cert.dt.deliv.
dtbai PBR_DTBAI Sick leave date
ictyp PBR_ICTYP Identif.doc.type
icnum PBR_IDNUM CPF no.
pensi PBR_PENSI Pensioner indic.
movor PAD_VORNA First Name
monam PAD_NACHN Last Name
mona2 PAD_NACH2 Second name
minit INITS Initials
mothe PBR_MOTHE Mother full name
excep PBR_EXCEP Depend.ChallengPers.
sbart SBART Challenge type
noreu PBR_NOREU Register
lbcnr PBR_LBCNR Live Birth Certif.
nhcnr PBR_NHCNR Health National Card
healthplan_ind HRPADBR_HEALTH_PLAN_IND Dep.priv.health plan
dependency_descr HRPADBR_DEPENDENCY_DESCRIPTION Depend.description

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.

-- Infotype 0021 Family
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0397 (
    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]
    UFBOT,             -- Region [REGIO]
    STINV,             -- Challenged dep. [PBR_STINV]
    ESCOL,             -- Education level [PBR_FASAR]
    SALFA,             -- Child allowance [PBR_SALFA]
    IRFLG,             -- Income tax [PBR_IRFLG]
    SERIE,             -- Grade [PBR_SERIE]
    MODEN,             -- Specification [PBR_MODEN]
    ESCOA,             -- School [PBR_ESCOA]
    DTCVC,             -- Vac.card exp. [PBR_DTCVC]
    SALED,             -- Educ.allowance [PBR_SALED]
    ESTUD,             -- Student [PBR_STUDE]
    FUMAN,             -- Smoker [PBR_FUMAN]
    CARTO,             -- Pub.notary name [PBR_CARTO]
    NOREG,             -- Record number [PBR_NOREG]
    NOLIV,             -- Ledger number [PBR_NOLIV]
    NOFOL,             -- Sheet number [PBR_NOFOL]
    DTENT,             -- Cert.dt.deliv. [PBR_DTENT]
    DTBAI,             -- Sick leave date [PBR_DTBAI]
    ICTYP,             -- Identif.doc.type [PBR_ICTYP]
    ICNUM,             -- CPF no. [PBR_IDNUM]
    PENSI,             -- Pensioner indic. [PBR_PENSI]
    MOVOR,             -- First Name [PAD_VORNA]
    MONAM,             -- Last Name [PAD_NACHN]
    MONA2,             -- Second name [PAD_NACH2]
    MINIT,             -- Initials [INITS]
    MOTHE,             -- Mother full name [PBR_MOTHE]
    EXCEP,             -- Depend.ChallengPers. [PBR_EXCEP]
    SBART,             -- Challenge type [SBART]
    NOREU,             -- Register [PBR_NOREU]
    LBCNR,             -- Live Birth Certif. [PBR_LBCNR]
    NHCNR,             -- Health National Card [PBR_NHCNR]
    HEALTHPLAN_IND,    -- Dep.priv.health plan [HRPADBR_HEALTH_PLAN_IND]
    DEPENDENCY_DESCR,  -- Depend.description [HRPADBR_DEPENDENCY_DESCRIPTION]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More