PA0394

Transparent Table Application Table
36 Fields 2 CDS Views

Family data: Additional information

PA0394 is an SAP database table in S/4HANA. Family data: Additional information. It contains 36 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_AR_HCMFamilyMemberSupplement view_entity from EXTENSION AR HCM Family Member - Extension
I_AR_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement AR

Fields (36)

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
asfax PAR_ASFAX Allowance child
discp PAR_DISCP Disabled
traba PAR_TRABA Working
estud PAR_ESTUD Student
feinf PAR_FEINF Notificatn date
nadoc PAR_NADOC Certificate
famst FAMST Marital stat.
adhos PAR_ADHOS Member
clase PAR_CLASE Grade/year
ccuil PAR_CCUIL CUIL/CUIT
ictyp PAR_TIPOD Document type
icnum PAR_NUMED Document number
tipoe PAR_TIPOE Schooling Type

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.

-- Family data: Additional information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0394 (
    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]
    ASFAX,  -- Allowance child [PAR_ASFAX]
    DISCP,  -- Disabled [PAR_DISCP]
    TRABA,  -- Working [PAR_TRABA]
    ESTUD,  -- Student [PAR_ESTUD]
    FEINF,  -- Notificatn date [PAR_FEINF]
    NADOC,  -- Certificate [PAR_NADOC]
    FAMST,  -- Marital stat. [FAMST]
    ADHOS,  -- Member [PAR_ADHOS]
    CLASE,  -- Grade/year [PAR_CLASE]
    CCUIL,  -- CUIL/CUIT [PAR_CCUIL]
    ICTYP,  -- Document type [PAR_TIPOD]
    ICNUM,  -- Document number [PAR_NUMED]
    TIPOE,  -- Schooling Type [PAR_TIPOE]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More