PA0352

Transparent Table Application Table
49 Fields 2 CDS Views

NHI for Family member (TW)

PA0352 is an SAP database table in S/4HANA. NHI for Family member (TW). It contains 49 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TW_HCMFamilyMemberSupplement view_entity from EXTENSION TW HCM Family Member - Extension
I_TW_HCMFamilyMemberSupplement view_entity from BASIC Additional Family Information (TW)

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
farel PTW_FAREL Relationship
idnum PTW_IDNUM ID Number
idchk PTW_IDCHK ID no. error
nhifa PTW_NHIFA NHI for family
nhist PTW_NHIST NHI status
nhisr PTW_NHISR Status reason
disab PTW_DISAB Disability grade
nhiex PTW_NHIEX NHI exempt by law
exrsn PTW_EXRSN Exempt reason
land1 LAND1 Country/Reg.
pstlz PSTLZ_HR P.code/city
telnr TELNR Telephone No.
state REGIO Region
counc COUNC County Code
town PTW_TOWN Town
villa PTW_VILLA Village
neigh PTW_NEIGH Neighborhood
adrtw PTW_ADRTW Full address
alnam ALNAM Alternate Name
vadat PTW_VADAT Premium from
restm NUM1 NUM
restu NUM1 NUM
stmdt DATUM Date
studt DATUM Date
listr PTW_LISTR Listed on report
vafrm PTW_VAFRM Start Month of NHI

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.

-- NHI for Family member (TW)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0352 (
    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]
    FAREL,  -- Relationship [PTW_FAREL]
    IDNUM,  -- ID Number [PTW_IDNUM]
    IDCHK,  -- ID no. error [PTW_IDCHK]
    NHIFA,  -- NHI for family [PTW_NHIFA]
    NHIST,  -- NHI status [PTW_NHIST]
    NHISR,  -- Status reason [PTW_NHISR]
    DISAB,  -- Disability grade [PTW_DISAB]
    NHIEX,  -- NHI exempt by law [PTW_NHIEX]
    EXRSN,  -- Exempt reason [PTW_EXRSN]
    LAND1,  -- Country/Reg. [LAND1]
    PSTLZ,  -- P.code/city [PSTLZ_HR]
    TELNR,  -- Telephone No. [TELNR]
    STATE,  -- Region [REGIO]
    COUNC,  -- County Code [COUNC]
    TOWN,   -- Town [PTW_TOWN]
    VILLA,  -- Village [PTW_VILLA]
    NEIGH,  -- Neighborhood [PTW_NEIGH]
    ADRTW,  -- Full address [PTW_ADRTW]
    ALNAM,  -- Alternate Name [ALNAM]
    VADAT,  -- Premium from [PTW_VADAT]
    RESTM,  -- NUM [NUM1]
    RESTU,  -- NUM [NUM1]
    STMDT,  -- Date [DATUM]
    STUDT,  -- Date [DATUM]
    LISTR,  -- Listed on report [PTW_LISTR]
    VAFRM,  -- Start Month of NHI [PTW_VAFRM]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More