PA0344

Transparent Table Application Table
71 Fields 2 CDS Views

HR Master Record: Infotype 0344 (Familiy members HK)

PA0344 is an SAP database table in S/4HANA. HR Master Record: Infotype 0344 (Familiy members HK). It contains 71 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_HK_HCMFamilyMemberSupplement view_entity from EXTENSION HK HCM Family Member - Extension
I_HK_HCMFamilyMemberSupplement view_entity from Hongkong Family Member CDS supplement view

Fields (71)

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
name2 CONAM c/o
stras STRAS Street/House
locat STRAS Street/House
ort01 ORT01 City
counc COUNC County Code
state REGIO Region
land1 LAND1 Country/Reg.
pstlz PSTLZ_HR P.code/city
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
com05 COMKY Type
num05 COMNR Number
com06 COMKY Type
num06 COMNR Number
anred ANRDE FOA key
sepdt PHK_SEPDT Separation date
famst FAMST Marital stat.
gbdep GBDEP State
occup PHK_OCCUP Occupations
eames PHK_EAMES Occupation status
ernam PHK_ERNAM Employer name
namt1 NAMTP Name Type
vorn1 VORNA First Name
nach1 NACHN Last Name
namt2 NAMTP Name Type
vorn2 VORNA First Name
nach2 NACHN Last Name
icty1 ICTYP ID Type
icnm1 ICNUM IC Number
auth1 PHK_AUTH1 Issuing Authority
fpdt1 PHK_FPDAT Issuing date
expd1 EXPID Expiry date
idct1 PHK_IDCOT C/R of ID
isct1 PHK_ISCOT C/R of issue
icty2 ICTYP ID Type
icnm2 ICNUM IC Number
auth2 PHK_AUTH1 Issuing Authority
fpdt2 PHK_FPDAT Issuing date
expd2 EXPID Expiry date
idct2 PHK_IDCOT C/R of ID
isct2 PHK_ISCOT C/R of issue

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 0344 (Familiy members HK)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0344 (
    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]
    NAME2,  -- c/o [CONAM]
    STRAS,  -- Street/House [STRAS]
    LOCAT,  -- Street/House [STRAS]
    ORT01,  -- City [ORT01]
    COUNC,  -- County Code [COUNC]
    STATE,  -- Region [REGIO]
    LAND1,  -- Country/Reg. [LAND1]
    PSTLZ,  -- P.code/city [PSTLZ_HR]
    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]
    COM05,  -- Type [COMKY]
    NUM05,  -- Number [COMNR]
    COM06,  -- Type [COMKY]
    NUM06,  -- Number [COMNR]
    ANRED,  -- FOA key [ANRDE]
    SEPDT,  -- Separation date [PHK_SEPDT]
    FAMST,  -- Marital stat. [FAMST]
    GBDEP,  -- State [GBDEP]
    OCCUP,  -- Occupations [PHK_OCCUP]
    EAMES,  -- Occupation status [PHK_EAMES]
    ERNAM,  -- Employer name [PHK_ERNAM]
    NAMT1,  -- Name Type [NAMTP]
    VORN1,  -- First Name [VORNA]
    NACH1,  -- Last Name [NACHN]
    NAMT2,  -- Name Type [NAMTP]
    VORN2,  -- First Name [VORNA]
    NACH2,  -- Last Name [NACHN]
    ICTY1,  -- ID Type [ICTYP]
    ICNM1,  -- IC Number [ICNUM]
    AUTH1,  -- Issuing Authority [PHK_AUTH1]
    FPDT1,  -- Issuing date [PHK_FPDAT]
    EXPD1,  -- Expiry date [EXPID]
    IDCT1,  -- C/R of ID [PHK_IDCOT]
    ISCT1,  -- C/R of issue [PHK_ISCOT]
    ICTY2,  -- ID Type [ICTYP]
    ICNM2,  -- IC Number [ICNUM]
    AUTH2,  -- Issuing Authority [PHK_AUTH1]
    FPDT2,  -- Issuing date [PHK_FPDAT]
    EXPD2,  -- Expiry date [EXPID]
    IDCT2,  -- C/R of ID [PHK_IDCOT]
    ISCT2,  -- C/R of issue [PHK_ISCOT]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More