PA0288

Transparent Table Application Table
42 Fields 1 CDS Views

HR CH: HR Master Record Infotype 0021 (Suppl. Switzerland)

PA0288 is an SAP database table in S/4HANA. HR CH: HR Master Record Infotype 0021 (Suppl. Switzerland). It contains 42 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CH_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement CH

Fields (42)

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
auszfak P02Z_ZUFAK PayFac FamBo
kzkuerz P02Z_FAKKU Tax ind: FamBon
nahvn P02_NAHVNR SI Number
lcoun P02_FAK_LCOUNTRY C/R Res.
lcant P02_FAK_LCANTON Canton of Resd.
difal P02_FAK_DIFFERENCE_ALLOWANCE Bon P w First Claim
empyn P02_FAK_WORK_CONTRACT_PARTNER PartnerWkContr
wcoun P02_FAK_WORK_COUNTRY_PARTNER Partner
wcant P02_FAK_WORK_CANTON_PARTNER Canton of Work
eradr P02_FAK_EMPLOYER Employer
etrnr P02_FAK_FMZR_REFNR Bon.Ref.No.
etrnz P02_FAK_FMZR_REFNR_POSTFIX Bonus No.
etbeg P02_FAK_FMZR_ENTMT_BEGDA Start Entitlemt
etend P02_FAK_FMZR_ENTMT_ENDDA End Entitlement
whtdeduc P02_ELM40_WHT_DEDUCTION_RIGHT WhT Deduction
paybegda P02_ELM40_WHT_PPAY_BEGDA Valid From
payendda P02_ELM40_WHT_PPAY_ENDDA Valid To
workcomp P02_ELM40_WHT_WORKCOMP Payment
neben P02_ELM_NEBENERW Second Job

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 CH: HR Master Record Infotype 0021 (Suppl. Switzerland)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0288 (
    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]
    AUSZFAK,   -- PayFac FamBo [P02Z_ZUFAK]
    KZKUERZ,   -- Tax ind: FamBon [P02Z_FAKKU]
    NAHVN,     -- SI Number [P02_NAHVNR]
    LCOUN,     -- C/R Res. [P02_FAK_LCOUNTRY]
    LCANT,     -- Canton of Resd. [P02_FAK_LCANTON]
    DIFAL,     -- Bon P w First Claim [P02_FAK_DIFFERENCE_ALLOWANCE]
    EMPYN,     -- PartnerWkContr [P02_FAK_WORK_CONTRACT_PARTNER]
    WCOUN,     -- Partner [P02_FAK_WORK_COUNTRY_PARTNER]
    WCANT,     -- Canton of Work [P02_FAK_WORK_CANTON_PARTNER]
    ERADR,     -- Employer [P02_FAK_EMPLOYER]
    ETRNR,     -- Bon.Ref.No. [P02_FAK_FMZR_REFNR]
    ETRNZ,     -- Bonus No. [P02_FAK_FMZR_REFNR_POSTFIX]
    ETBEG,     -- Start Entitlemt [P02_FAK_FMZR_ENTMT_BEGDA]
    ETEND,     -- End Entitlement [P02_FAK_FMZR_ENTMT_ENDDA]
    WHTDEDUC,  -- WhT Deduction [P02_ELM40_WHT_DEDUCTION_RIGHT]
    PAYBEGDA,  -- Valid From [P02_ELM40_WHT_PPAY_BEGDA]
    PAYENDDA,  -- Valid To [P02_ELM40_WHT_PPAY_ENDDA]
    WORKCOMP,  -- Payment [P02_ELM40_WHT_WORKCOMP]
    NEBEN,     -- Second Job [P02_ELM_NEBENERW]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More