PA0187

Transparent Table Application Table
49 Fields 2 CDS Views

Additional family data

PA0187 is an SAP database table in S/4HANA. Additional family data. It contains 49 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TH_HCMFamilyMemberSupplement view_entity from EXTENSION TH HCM Family Member - Extension
I_TH_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement TH

Fields (49)

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
anred ANRDE FOA key
stras PTH_STRAS Add. No./Soi Trok
ort01 PTH_TORT1 Province
ort02 PTH_TORT2 District
pstlz PSTLZ_HR P.code/city
land1 LAND1 Country/Reg.
telnr TELNR Telephone No.
locat PTH_LOCAT Street Road/Tambol
com01 COMKY Type
num01 COMNR Number
com02 COMKY Type
num02 COMNR Number
com03 COMKY Type
num03 COMNR Number
com04 COMKY Type
num04 COMNR Number
aldec PTH_ALDEC Deceased
jobtl STLTX Job Title
efaml PTH_EFAML ER Fmly. Mmbr.
ftxid PTH_FTXID Father ID Number
mtxid PTH_MTXID Mother ID Number
stxid PTH_STXID Spouse ID No
sfxid PTH_SFXID Sp. Father ID
smxid PTH_SMXID Sp. Mother ID
chxid PTH_CHDID Child ID Number
chxal PTH_CHDAL Child/Education All.

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.

-- Additional family data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0187 (
    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]
    ANRED,  -- FOA key [ANRDE]
    STRAS,  -- Add. No./Soi Trok [PTH_STRAS]
    ORT01,  -- Province [PTH_TORT1]
    ORT02,  -- District [PTH_TORT2]
    PSTLZ,  -- P.code/city [PSTLZ_HR]
    LAND1,  -- Country/Reg. [LAND1]
    TELNR,  -- Telephone No. [TELNR]
    LOCAT,  -- Street Road/Tambol [PTH_LOCAT]
    COM01,  -- Type [COMKY]
    NUM01,  -- Number [COMNR]
    COM02,  -- Type [COMKY]
    NUM02,  -- Number [COMNR]
    COM03,  -- Type [COMKY]
    NUM03,  -- Number [COMNR]
    COM04,  -- Type [COMKY]
    NUM04,  -- Number [COMNR]
    ALDEC,  -- Deceased [PTH_ALDEC]
    JOBTL,  -- Job Title [STLTX]
    EFAML,  -- ER Fmly. Mmbr. [PTH_EFAML]
    FTXID,  -- Father ID Number [PTH_FTXID]
    MTXID,  -- Mother ID Number [PTH_MTXID]
    STXID,  -- Spouse ID No [PTH_STXID]
    SFXID,  -- Sp. Father ID [PTH_SFXID]
    SMXID,  -- Sp. Mother ID [PTH_SMXID]
    CHXID,  -- Child ID Number [PTH_CHDID]
    CHXAL,  -- Child/Education All. [PTH_CHDAL]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More