PA0106

Transparent Table Application Table
63 Fields 5 CDS Views

HR Master Record: Infotype 0106 (Related Persons NA)

PA0106 is an SAP database table in S/4HANA. HR Master Record: Infotype 0106 (Related Persons NA). It contains 63 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_CA_HCMFamilyMemberSupplement view_entity from EXTENSION CA Family Member Suppl - Extension
E_US_HCMFamilyMemberSupplement view_entity from EXTENSION US Family Member Suppl - Extension
I_CA_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement CA
I_RU_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement RU
I_US_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement US

Fields (63)

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
permo PIDMO Pers.ID mod.
perid PRDNI ID number
ben01 BEN01 Not Used
ben02 BEN02 Not Used
ben03 BEN03 Student Indic.
ben04 BEN04 COBRA Indicator
ben05 BEN05 Smoker
stras STRAS Street/House
locat STRAS Street/House
ort01 ORT01 City
state REGIO Region
pstlz PSTLZ Postal Code
land1 LAND1 Country/Reg.
telnr TELNR Telephone No.
sepdt SEPDT Separation Date
docnm BEN_DOCNAM Physician Name
docid BEN_DOCID Physician ID
docn2 BEN_DOCNAM Physician Name
doci2 BEN_DOCID Physician ID
disab DISABTY Disability
disdt DISDT Disability Date
disle DISLE Date Learned
depin BEN_DEPIN Dependent
medic BEN_MEDIC Medicare
smoke BEN_SMOKER Smoker
famst FAMST Marital stat.
provi BEN_PROVID Provider number
polnr BEN_POLNR Policy no.
taxnb TAXID Tax ID
pmres PMRES Residency typ
racky RACKY Ethnic origin
spems SPEMS Employ.Status
milsv BEN_MILSV Military Serv.
finin BEN_FININ Fin. Indep.
nontx BEN_NONTX Non-taxable
pmadt BEN_PMADT Proof of Med Abs Dt
legid BEN_LEGID Proof submission Ind
legdt BEN_LEGDT Proof submission Dat
idcod HRPAY99US_PERID Person ID
p0106_ei_dummy DUMMY Dummy function in length 1

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 0106 (Related Persons NA)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0106 (
    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]
    PERMO,           -- Pers.ID mod. [PIDMO]
    PERID,           -- ID number [PRDNI]
    BEN01,           -- Not Used [BEN01]
    BEN02,           -- Not Used [BEN02]
    BEN03,           -- Student Indic. [BEN03]
    BEN04,           -- COBRA Indicator [BEN04]
    BEN05,           -- Smoker [BEN05]
    STRAS,           -- Street/House [STRAS]
    LOCAT,           -- Street/House [STRAS]
    ORT01,           -- City [ORT01]
    STATE,           -- Region [REGIO]
    PSTLZ,           -- Postal Code [PSTLZ]
    LAND1,           -- Country/Reg. [LAND1]
    TELNR,           -- Telephone No. [TELNR]
    SEPDT,           -- Separation Date [SEPDT]
    DOCNM,           -- Physician Name [BEN_DOCNAM]
    DOCID,           -- Physician ID [BEN_DOCID]
    DOCN2,           -- Physician Name [BEN_DOCNAM]
    DOCI2,           -- Physician ID [BEN_DOCID]
    DISAB,           -- Disability [DISABTY]
    DISDT,           -- Disability Date [DISDT]
    DISLE,           -- Date Learned [DISLE]
    DEPIN,           -- Dependent [BEN_DEPIN]
    MEDIC,           -- Medicare [BEN_MEDIC]
    SMOKE,           -- Smoker [BEN_SMOKER]
    FAMST,           -- Marital stat. [FAMST]
    PROVI,           -- Provider number [BEN_PROVID]
    POLNR,           -- Policy no. [BEN_POLNR]
    TAXNB,           -- Tax ID [TAXID]
    PMRES,           -- Residency typ [PMRES]
    RACKY,           -- Ethnic origin [RACKY]
    SPEMS,           -- Employ.Status [SPEMS]
    MILSV,           -- Military Serv. [BEN_MILSV]
    FININ,           -- Fin. Indep. [BEN_FININ]
    NONTX,           -- Non-taxable [BEN_NONTX]
    PMADT,           -- Proof of Med Abs Dt [BEN_PMADT]
    LEGID,           -- Proof submission Ind [BEN_LEGID]
    LEGDT,           -- Proof submission Dat [BEN_LEGDT]
    IDCOD,           -- Person ID [HRPAY99US_PERID]
    P0106_EI_DUMMY,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More