PA0148

Transparent Table Application Table
75 Fields 2 CDS Views

HR Master Record: Infotype 0148 (Family JP)

PA0148 is an SAP database table in S/4HANA. HR Master Record: Infotype 0148 (Family JP). It contains 75 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_JP_HCMFamilyMemberSupplement view_entity from EXTENSION JP HCM Family Member - Extension
I_JP_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement JP

Fields (75)

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
famsa FAMSA Family Member
fgbdt GBDAT Birth date
fgbld GBLND C/R Birth
fanat NATSL Nationality
fasex GESCH Gender
favor PAD_VORNA First Name
fanam PAD_NACHN Last Name
gbdep GBDEP State
fgbot GBORT Birthplace
fknzn KNZNM Name Format
kdart KDART Child Type
fnamk P22J_PFNMK 1st name Katakana
lnamk P22J_PLNMK Last name (Katakana)
indrl P22J_INDRL Relationship
dp1id P22J_DEPEN Dependent
dp2id P22J_OLPE2 Ded.for age grp. FM
dp3id P22J_DISA2 Ded.for disab. FM
dp4id P22J_LIWTH Ded.for live with
dphid P22J_DPHID Health ins. ind.
dpfal P22J_DPFAL Family all.
dp5id P22J_DP5ID Ind (dep.for YEA)
death P22J_DEATH Death flag
nonre PJP_DEP_NONRE Non-resident
dpnid P22J_DPNID Nursin ins. ind.
casbt SUBTY Subtype
caobj OBJPS Object ID
cabgd BEGDA Start Date
caedd ENDDA End Date
casqn SEQNR IT record no.
cnsbt SUBTY Subtype
cnobj OBJPS Object ID
chgrs P22J_CHGRS Change Reason
cfdpe P22J_CFDPE Disability Content
rfdpe P22J_RFDPE Disability Reason
stltx STLTX Job Title
incom P22J_SUPIN Income of Depend
sipnr P22J_SIINR Insurance no
midkj P22J_MIDKJ Mdl name (Kanji)
midkk P22J_MIDKK Mdl name (Kana)
midrj PAD_MIDNM Middle name
teltp PJP_TELTP Tel Type
telnr TELNR Telephone No.
adjdp PJP_YEAID Y.E.A. ID
esamt P22J_SUPIN Income of Depend
livhd P22J_DP4ID_TXT Live with Indicator
hrcfm P22J_CHECK Checkbox
uncfm P22J_SIID2 SI Stat for Rp.
dpexp PJP_DPEXP Except.
exrsn PREAS Change Reason
dprid P22J_DPRID Ret. Income Res.
sdiid P22J_TXCOL Spec. Fam. Form
sdamt P22J_SUPIN Income of Depend

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 0148 (Family JP)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0148 (
    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]
    FAMSA,  -- Family Member [FAMSA]
    FGBDT,  -- Birth date [GBDAT]
    FGBLD,  -- C/R Birth [GBLND]
    FANAT,  -- Nationality [NATSL]
    FASEX,  -- Gender [GESCH]
    FAVOR,  -- First Name [PAD_VORNA]
    FANAM,  -- Last Name [PAD_NACHN]
    GBDEP,  -- State [GBDEP]
    FGBOT,  -- Birthplace [GBORT]
    FKNZN,  -- Name Format [KNZNM]
    KDART,  -- Child Type [KDART]
    FNAMK,  -- 1st name Katakana [P22J_PFNMK]
    LNAMK,  -- Last name (Katakana) [P22J_PLNMK]
    INDRL,  -- Relationship [P22J_INDRL]
    DP1ID,  -- Dependent [P22J_DEPEN]
    DP2ID,  -- Ded.for age grp. FM [P22J_OLPE2]
    DP3ID,  -- Ded.for disab. FM [P22J_DISA2]
    DP4ID,  -- Ded.for live with [P22J_LIWTH]
    DPHID,  -- Health ins. ind. [P22J_DPHID]
    DPFAL,  -- Family all. [P22J_DPFAL]
    DP5ID,  -- Ind (dep.for YEA) [P22J_DP5ID]
    DEATH,  -- Death flag [P22J_DEATH]
    NONRE,  -- Non-resident [PJP_DEP_NONRE]
    DPNID,  -- Nursin ins. ind. [P22J_DPNID]
    CASBT,  -- Subtype [SUBTY]
    CAOBJ,  -- Object ID [OBJPS]
    CABGD,  -- Start Date [BEGDA]
    CAEDD,  -- End Date [ENDDA]
    CASQN,  -- IT record no. [SEQNR]
    CNSBT,  -- Subtype [SUBTY]
    CNOBJ,  -- Object ID [OBJPS]
    CHGRS,  -- Change Reason [P22J_CHGRS]
    CFDPE,  -- Disability Content [P22J_CFDPE]
    RFDPE,  -- Disability Reason [P22J_RFDPE]
    STLTX,  -- Job Title [STLTX]
    INCOM,  -- Income of Depend [P22J_SUPIN]
    SIPNR,  -- Insurance no [P22J_SIINR]
    MIDKJ,  -- Mdl name (Kanji) [P22J_MIDKJ]
    MIDKK,  -- Mdl name (Kana) [P22J_MIDKK]
    MIDRJ,  -- Middle name [PAD_MIDNM]
    TELTP,  -- Tel Type [PJP_TELTP]
    TELNR,  -- Telephone No. [TELNR]
    ADJDP,  -- Y.E.A. ID [PJP_YEAID]
    ESAMT,  -- Income of Depend [P22J_SUPIN]
    LIVHD,  -- Live with Indicator [P22J_DP4ID_TXT]
    HRCFM,  -- Checkbox [P22J_CHECK]
    UNCFM,  -- SI Stat for Rp. [P22J_SIID2]
    DPEXP,  -- Except. [PJP_DPEXP]
    EXRSN,  -- Change Reason [PREAS]
    DPRID,  -- Ret. Income Res. [P22J_DPRID]
    SDIID,  -- Spec. Fam. Form [P22J_TXCOL]
    SDAMT,  -- Income of Depend [P22J_SUPIN]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More