PA3254

Transparent Table Application Table
45 Fields 1 CDS Views

HR Master Record: Infotype 3254

PA3254 is an SAP database table in S/4HANA. HR Master Record: Infotype 3254. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SA_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement SA

Fields (45)

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
arfnm P24_ARFNM Arabic First Name
arsnm P24_ARSNM Arabic Second Name
artnm P24_ARTNM Arabic Third Name
arlnm P24_ARLNM Arabic Last Name
hirdt P24_HIRDT Hijri Birth Date
schnm P24_SCHNM School Name
drlnb P24_DRLNB Drivers License No.
dlepd PSAP_DLEPD Drivers License Exp.
vsnum P24_VSNUM Visa Number
vsepd P24_VSEPD Visa Expire Date
pspnm P24_PSPNM Passport Number
psped P24_PSPED Passport Expire Date
iqnum P24_IQNUM Iqama Number
iqepd P24_IQEPD Iqama Expire Date
blgrp P24_BLGRP Blood Group
bordr P24_BORDR Border Entry No.
eport P24_EPORT Port of Entry
entrd P24_ENTRD Date of Entry
lpapd P24_LPAPD Leave Passage Elig.
ktart P24_KTART Quota Type
fdelg PSAP_FDELG Travel Ticket
spoid PSAP_SPOID Spouse ID

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 3254
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA3254 (
    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]
    ARFNM,  -- Arabic First Name [P24_ARFNM]
    ARSNM,  -- Arabic Second Name [P24_ARSNM]
    ARTNM,  -- Arabic Third Name [P24_ARTNM]
    ARLNM,  -- Arabic Last Name [P24_ARLNM]
    HIRDT,  -- Hijri Birth Date [P24_HIRDT]
    SCHNM,  -- School Name [P24_SCHNM]
    DRLNB,  -- Drivers License No. [P24_DRLNB]
    DLEPD,  -- Drivers License Exp. [PSAP_DLEPD]
    VSNUM,  -- Visa Number [P24_VSNUM]
    VSEPD,  -- Visa Expire Date [P24_VSEPD]
    PSPNM,  -- Passport Number [P24_PSPNM]
    PSPED,  -- Passport Expire Date [P24_PSPED]
    IQNUM,  -- Iqama Number [P24_IQNUM]
    IQEPD,  -- Iqama Expire Date [P24_IQEPD]
    BLGRP,  -- Blood Group [P24_BLGRP]
    BORDR,  -- Border Entry No. [P24_BORDR]
    EPORT,  -- Port of Entry [P24_EPORT]
    ENTRD,  -- Date of Entry [P24_ENTRD]
    LPAPD,  -- Leave Passage Elig. [P24_LPAPD]
    KTART,  -- Quota Type [P24_KTART]
    FDELG,  -- Travel Ticket [PSAP_FDELG]
    SPOID,  -- Spouse ID [PSAP_SPOID]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More