PA0286

Transparent Table Application Table
43 Fields 2 CDS Views

SI child

PA0286 is an SAP database table in S/4HANA. SI child. It contains 43 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_HU_HCMFamilyMemberSupplement view_entity from EXTENSION HU HCM Family Member - Extension
I_HU_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement HU

Fields (43)

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
datm1 P21_DATM1 Time
datm2 P21_DATM2 from
datm3 P21_DATM3 to
ny3mh P21_NY3MH 3-month min. pens.
allpt P21_CPGYA Child status
cspmh P21_CSPMH CB prolonged
gysor P21_GYSOR GYES serial no.
azons KINDN Child no.
esmny P21_ESMNY Event
esmn1 P21_ESMN1 Event
datm4 P21_DATM4 Med. exam. date
anyna NACHN Last Name
anyvo VORNA First Name
waers WAERS Currency
igenc P21_IGENC Correction?
korcs P21_KORCS Nurt. ben. am.
kmod1 P21_KMOD1 IllnessCode1
kmod2 P21_KMOD2 Illness code 2
ikrek P21_IKREK Twin
snevi P21_SNEVI Requiring spec.dev.

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.

-- SI child
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0286 (
    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]
    DATM1,  -- Time [P21_DATM1]
    DATM2,  -- from [P21_DATM2]
    DATM3,  -- to [P21_DATM3]
    NY3MH,  -- 3-month min. pens. [P21_NY3MH]
    ALLPT,  -- Child status [P21_CPGYA]
    CSPMH,  -- CB prolonged [P21_CSPMH]
    GYSOR,  -- GYES serial no. [P21_GYSOR]
    AZONS,  -- Child no. [KINDN]
    ESMNY,  -- Event [P21_ESMNY]
    ESMN1,  -- Event [P21_ESMN1]
    DATM4,  -- Med. exam. date [P21_DATM4]
    ANYNA,  -- Last Name [NACHN]
    ANYVO,  -- First Name [VORNA]
    WAERS,  -- Currency [WAERS]
    IGENC,  -- Correction? [P21_IGENC]
    KORCS,  -- Nurt. ben. am. [P21_KORCS]
    KMOD1,  -- IllnessCode1 [P21_KMOD1]
    KMOD2,  -- Illness code 2 [P21_KMOD2]
    IKREK,  -- Twin [P21_IKREK]
    SNEVI,  -- Requiring spec.dev. [P21_SNEVI]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More