PA0318

Transparent Table Application Table
50 Fields 2 CDS Views

HR Master Record: Infotype Family data for Indonesia (0318)

PA0318 is an SAP database table in S/4HANA. HR Master Record: Infotype Family data for Indonesia (0318). It contains 50 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ID_HCMFamilyMemberSupplement view_entity from EXTENSION ID HCM Family Member - Extension
I_ID_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement Indonesia

Fields (50)

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
pasnr PID_PASNR Passport Number
pasty PID_PASTY Passport Type
issue PID_ISSUE Date of Issue
expir PID_EXPIR Pass. Expiry Date
place PID_PLACE Place of Issue
cntry LAND1 Country/Reg.
telnr TELNR Telephone No.
jobtl STLTX Job Title
spems PID_SPEMS Employer of Fam. Mem
stras STRAS Street/House
locat LOCAT 2nd add.line
ort01 ORT01 City
pstlz PSTLZ_HR P.code/city
ort02 ORT02 District
land1 LAND1 Country/Reg.
deptx PID_DEPTX Dependent for Tax
depsi PID_DEPSI Dependet for SI
benft PID_BENFT Benefits Entitlement
marct PID_MARCT Mar. Cer.
idnum PID_IDNUM ID Card Number
idcty PID_IDCTY ID Card Type
iddat PID_IDDAT Date of Issue
idexp PID_IDEXP Expiry Date of ID
idpla PID_IDPLA Place of Issue
depdp PID_DEPDP BPJS Dep Type
bpjsi P34_BPJSI BPJS ID
becls P34_BECLS Benefit Class

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 Family data for Indonesia (0318)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0318 (
    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]
    PASNR,  -- Passport Number [PID_PASNR]
    PASTY,  -- Passport Type [PID_PASTY]
    ISSUE,  -- Date of Issue [PID_ISSUE]
    EXPIR,  -- Pass. Expiry Date [PID_EXPIR]
    PLACE,  -- Place of Issue [PID_PLACE]
    CNTRY,  -- Country/Reg. [LAND1]
    TELNR,  -- Telephone No. [TELNR]
    JOBTL,  -- Job Title [STLTX]
    SPEMS,  -- Employer of Fam. Mem [PID_SPEMS]
    STRAS,  -- Street/House [STRAS]
    LOCAT,  -- 2nd add.line [LOCAT]
    ORT01,  -- City [ORT01]
    PSTLZ,  -- P.code/city [PSTLZ_HR]
    ORT02,  -- District [ORT02]
    LAND1,  -- Country/Reg. [LAND1]
    DEPTX,  -- Dependent for Tax [PID_DEPTX]
    DEPSI,  -- Dependet for SI [PID_DEPSI]
    BENFT,  -- Benefits Entitlement [PID_BENFT]
    MARCT,  -- Mar. Cer. [PID_MARCT]
    IDNUM,  -- ID Card Number [PID_IDNUM]
    IDCTY,  -- ID Card Type [PID_IDCTY]
    IDDAT,  -- Date of Issue [PID_IDDAT]
    IDEXP,  -- Expiry Date of ID [PID_IDEXP]
    IDPLA,  -- Place of Issue [PID_IDPLA]
    DEPDP,  -- BPJS Dep Type [PID_DEPDP]
    BPJSI,  -- BPJS ID [P34_BPJSI]
    BECLS,  -- Benefit Class [P34_BECLS]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More