PA0213

Transparent Table Application Table
52 Fields 2 CDS Views

Additional family information - Malaysia

PA0213 is an SAP database table in S/4HANA. Additional family information - Malaysia. It contains 52 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_MY_HCMFamilyMemberSupplement view_entity from EXTENSION MY HCM Family Member - Extension
I_MY_HCMFamilyMemberSupplement view_entity from BASIC MY Family Member CDS supplement view

Fields (52)

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
icnum ICNUM IC Number
stltx STLTX Job Title
tnoee P14_TNOEE EE Tax number
semps P14_SEMPS Spouse employed
spemr P14_SPEMR Spouse employer
stxof P14_STXOF Spouse tax off
pasnr P14_PASNR Passport Number
bthid P14_BTHID Birth cert. Id
hanch P14_HANCH Handicap Chld.
chcus P14_CHCUS Child custody
marst P14_MARST Married
stras STRAS Street/House
locat LOCAT 2nd add.line
ort02 ORT02 District
pstlz PSTLZ_HR P.code/city
ort01 ORT01 City
state REGIO Region
land1 LAND1 Country/Reg.
name2 CONAM c/o
telnr TELNR Telephone No.
com01 COMKY Type
num01 COMNR Number
com02 COMKY Type
num02 COMNR Number
com03 COMKY Type
num03 COMNR Number
com04 COMKY Type
num04 COMNR Number
chhal P14_CHHAL Half Child All.

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.

-- Additional family information - Malaysia
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0213 (
    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]
    ICNUM,  -- IC Number [ICNUM]
    STLTX,  -- Job Title [STLTX]
    TNOEE,  -- EE Tax number [P14_TNOEE]
    SEMPS,  -- Spouse employed [P14_SEMPS]
    SPEMR,  -- Spouse employer [P14_SPEMR]
    STXOF,  -- Spouse tax off [P14_STXOF]
    PASNR,  -- Passport Number [P14_PASNR]
    BTHID,  -- Birth cert. Id [P14_BTHID]
    HANCH,  -- Handicap Chld. [P14_HANCH]
    CHCUS,  -- Child custody [P14_CHCUS]
    MARST,  -- Married [P14_MARST]
    STRAS,  -- Street/House [STRAS]
    LOCAT,  -- 2nd add.line [LOCAT]
    ORT02,  -- District [ORT02]
    PSTLZ,  -- P.code/city [PSTLZ_HR]
    ORT01,  -- City [ORT01]
    STATE,  -- Region [REGIO]
    LAND1,  -- Country/Reg. [LAND1]
    NAME2,  -- c/o [CONAM]
    TELNR,  -- Telephone No. [TELNR]
    COM01,  -- Type [COMKY]
    NUM01,  -- Number [COMNR]
    COM02,  -- Type [COMKY]
    NUM02,  -- Number [COMNR]
    COM03,  -- Type [COMKY]
    NUM03,  -- Number [COMNR]
    COM04,  -- Type [COMKY]
    NUM04,  -- Number [COMNR]
    CHHAL,  -- Half Child All. [P14_CHHAL]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More