PA0959

Transparent Table Application Table
47 Fields 2 CDS Views

HR Master Record: Infotype 0959

PA0959 is an SAP database table in S/4HANA. HR Master Record: Infotype 0959. It contains 47 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_UN_HCMFamilyMemberSupplement view_entity from EXTENSION UN HCM Family Member - Extension
I_UN_HCMFamilyMemberSupplement view_entity from BASIC UN Family Member supplement

Fields (47)

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
midnm PAD_MIDNM Middle name
famst FAMST Marital stat.
famdt FAMDT Since
irdoa PUN_IRDOA In rec of all. since
betr3 PAD_AMT7S Amount
waers WAERS Currency
lgart LGART Wage Type
opken OPKEN Operation ind.
dthdt PUN_DTHDT Death Date
spwae WAERS Currency
spear PUN_SPOEAR Occu. Earnings
eduat PUN_EDUAT Educational Att.
spods PUN_DSTAT Duty Station
fidep PUN_FIDEP Fin Dependent
sprnr PUN_SPRNR Personel nr.
serty PUN_SERTY Employer Type
serun PUN_UNORG UN Organization
sertx PUN_SERTX Employer Name
ncchl PUN_NCCHL Non Custodial Child
trans_ind PUN_TRANSIND Eligible:Trans.Allow
trans_date PUN_TRANSDATE Trans Eff Date
fsamt PUN_FSAMT Fin Support Amt
fswaer WAERS Currency
arrival_date PUN_ARDAT Dep Arrival date

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 0959
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0959 (
    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]
    MIDNM,         -- Middle name [PAD_MIDNM]
    FAMST,         -- Marital stat. [FAMST]
    FAMDT,         -- Since [FAMDT]
    IRDOA,         -- In rec of all. since [PUN_IRDOA]
    BETR3,         -- Amount [PAD_AMT7S]
    WAERS,         -- Currency [WAERS]
    LGART,         -- Wage Type [LGART]
    OPKEN,         -- Operation ind. [OPKEN]
    DTHDT,         -- Death Date [PUN_DTHDT]
    SPWAE,         -- Currency [WAERS]
    SPEAR,         -- Occu. Earnings [PUN_SPOEAR]
    EDUAT,         -- Educational Att. [PUN_EDUAT]
    SPODS,         -- Duty Station [PUN_DSTAT]
    FIDEP,         -- Fin Dependent [PUN_FIDEP]
    SPRNR,         -- Personel nr. [PUN_SPRNR]
    SERTY,         -- Employer Type [PUN_SERTY]
    SERUN,         -- UN Organization [PUN_UNORG]
    SERTX,         -- Employer Name [PUN_SERTX]
    NCCHL,         -- Non Custodial Child [PUN_NCCHL]
    TRANS_IND,     -- Eligible:Trans.Allow [PUN_TRANSIND]
    TRANS_DATE,    -- Trans Eff Date [PUN_TRANSDATE]
    FSAMT,         -- Fin Support Amt [PUN_FSAMT]
    FSWAER,        -- Currency [WAERS]
    ARRIVAL_DATE,  -- Dep Arrival date [PUN_ARDAT]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More