PA3253

Transparent Table Application Table
75 Fields 1 CDS Views

HR Master Record: Infotype 3253

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AE_HCMFamilyMemberSupplement view_entity from BASIC HCM Family Member Supplement AE

Fields (75)

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
psprt PAE_PSPRT Passport Number
psiss PAE_PSISS Issue Date
psexp PAE_PSEXP Expire Date
visan PAE_VISAN Visa Number
vsiss PAE_VSISS Issue Date
viexp PAE_VIEXP Expire Date
doct1 PAE_DCTTP Document Type
donr1 PAE_DCTNM Number
dois1 PAE_DOTIS Document Issue Date
doex1 PAE_DOTEX Document Expiry Date
doct2 PAE_DCTTP Document Type
donr2 PAE_DCTNM Number
dois2 PAE_DOTIS Document Issue Date
doex2 PAE_DOTEX Document Expiry Date
doct3 PAE_DCTTP Document Type
donr3 PAE_DCTNM Number
dois3 PAE_DOTIS Document Issue Date
doex3 PAE_DOTEX Document Expiry Date
emplm PAE_EMPLM Employed
emplr PAE_EMPLR Employer Name
empdt PAE_EMPDT Employment Date
accen PAE_ACCEN Accom. Entitlement
lpapd PAE_LPAPD Leave Passage
legno PAE_LEGNO Legal Nominee
ktart PAE_KTART Quota Type
arfnm PAE_ARFNM Arabic First Name
arsnm PAE_ARSNM Arabic Second Name
artnm PAE_ARTNM Arabic Third Name
arlnm PAE_ARLNM Arabic Last Name
acddg PAE_ADCDG Academic Degree
specl PAE_SPECL Specialization
spoid PAE_SPOID Spouse ID
doct4 PAE_DCTTP Document Type
donr4 PAE_DCTNM Number
dois4 PAE_DOTIS Document Issue Date
doex4 PAE_DOTEX Document Expiry Date
doct5 PAE_DCTTP Document Type
donr5 PAE_DCTNM Number
dois5 PAE_DOTIS Document Issue Date
doex5 PAE_DOTEX Document Expiry Date
doct6 PAE_DCTTP Document Type
donr6 PAE_DCTNM Number
dois6 PAE_DOTIS Document Issue Date
doex6 PAE_DOTEX Document Expiry Date
doct7 PAE_DCTTP Document Type
donr7 PAE_DCTNM Number
dois7 PAE_DOTIS Document Issue Date
doex7 PAE_DOTEX Document Expiry Date
doct8 PAE_DCTTP Document Type
donr8 PAE_DCTNM Number
dois8 PAE_DOTIS Document Issue Date
doex8 PAE_DOTEX Document Expiry Date

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 3253
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA3253 (
    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]
    PSPRT,  -- Passport Number [PAE_PSPRT]
    PSISS,  -- Issue Date [PAE_PSISS]
    PSEXP,  -- Expire Date [PAE_PSEXP]
    VISAN,  -- Visa Number [PAE_VISAN]
    VSISS,  -- Issue Date [PAE_VSISS]
    VIEXP,  -- Expire Date [PAE_VIEXP]
    DOCT1,  -- Document Type [PAE_DCTTP]
    DONR1,  -- Number [PAE_DCTNM]
    DOIS1,  -- Document Issue Date [PAE_DOTIS]
    DOEX1,  -- Document Expiry Date [PAE_DOTEX]
    DOCT2,  -- Document Type [PAE_DCTTP]
    DONR2,  -- Number [PAE_DCTNM]
    DOIS2,  -- Document Issue Date [PAE_DOTIS]
    DOEX2,  -- Document Expiry Date [PAE_DOTEX]
    DOCT3,  -- Document Type [PAE_DCTTP]
    DONR3,  -- Number [PAE_DCTNM]
    DOIS3,  -- Document Issue Date [PAE_DOTIS]
    DOEX3,  -- Document Expiry Date [PAE_DOTEX]
    EMPLM,  -- Employed [PAE_EMPLM]
    EMPLR,  -- Employer Name [PAE_EMPLR]
    EMPDT,  -- Employment Date [PAE_EMPDT]
    ACCEN,  -- Accom. Entitlement [PAE_ACCEN]
    LPAPD,  -- Leave Passage [PAE_LPAPD]
    LEGNO,  -- Legal Nominee [PAE_LEGNO]
    KTART,  -- Quota Type [PAE_KTART]
    ARFNM,  -- Arabic First Name [PAE_ARFNM]
    ARSNM,  -- Arabic Second Name [PAE_ARSNM]
    ARTNM,  -- Arabic Third Name [PAE_ARTNM]
    ARLNM,  -- Arabic Last Name [PAE_ARLNM]
    ACDDG,  -- Academic Degree [PAE_ADCDG]
    SPECL,  -- Specialization [PAE_SPECL]
    SPOID,  -- Spouse ID [PAE_SPOID]
    DOCT4,  -- Document Type [PAE_DCTTP]
    DONR4,  -- Number [PAE_DCTNM]
    DOIS4,  -- Document Issue Date [PAE_DOTIS]
    DOEX4,  -- Document Expiry Date [PAE_DOTEX]
    DOCT5,  -- Document Type [PAE_DCTTP]
    DONR5,  -- Number [PAE_DCTNM]
    DOIS5,  -- Document Issue Date [PAE_DOTIS]
    DOEX5,  -- Document Expiry Date [PAE_DOTEX]
    DOCT6,  -- Document Type [PAE_DCTTP]
    DONR6,  -- Number [PAE_DCTNM]
    DOIS6,  -- Document Issue Date [PAE_DOTIS]
    DOEX6,  -- Document Expiry Date [PAE_DOTEX]
    DOCT7,  -- Document Type [PAE_DCTTP]
    DONR7,  -- Number [PAE_DCTNM]
    DOIS7,  -- Document Issue Date [PAE_DOTIS]
    DOEX7,  -- Document Expiry Date [PAE_DOTEX]
    DOCT8,  -- Document Type [PAE_DCTTP]
    DONR8,  -- Number [PAE_DCTNM]
    DOIS8,  -- Document Issue Date [PAE_DOTIS]
    DOEX8,  -- Document Expiry Date [PAE_DOTEX]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More