PA0050

Transparent Table Application Table
39 Fields 1 CDS Views

HR Master Record: Infotype 0050 (Time Recording)

PA0050 is an SAP database table in S/4HANA. HR Master Record: Infotype 0050 (Time Recording). It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HCMTimeEventType view_entity inner BASIC HCM Time Event Types

Fields (39)

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
zausw DZAUSW Time rec.ID no.
zauve DZAUVE ID version
zabar DZABAR TE rule grpg
bdegr BDEGR Grouping
zanbe DZANBE Access group
zdgbe DZDGBE Off-site work
zmail DZMAIL Mail indicator
zpinc DZPINC Pers.code
glmax GLMAX Flextime max.
glmin GLMIN Flextime min.
ztzua DZTZUA Bonus/deduction
zmgen DZMGEN Standard o/time
zuskz DZUSKZ Addnl indicator
pmbde PMBDE Time event grp
grawg GRAWG Grpg. att./abs.
grelg GRELG EE expenses grpng

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 0050 (Time Recording)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0050 (
    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]
    ZAUSW,  -- Time rec.ID no. [DZAUSW]
    ZAUVE,  -- ID version [DZAUVE]
    ZABAR,  -- TE rule grpg [DZABAR]
    BDEGR,  -- Grouping [BDEGR]
    ZANBE,  -- Access group [DZANBE]
    ZDGBE,  -- Off-site work [DZDGBE]
    ZMAIL,  -- Mail indicator [DZMAIL]
    ZPINC,  -- Pers.code [DZPINC]
    GLMAX,  -- Flextime max. [GLMAX]
    GLMIN,  -- Flextime min. [GLMIN]
    ZTZUA,  -- Bonus/deduction [DZTZUA]
    ZMGEN,  -- Standard o/time [DZMGEN]
    ZUSKZ,  -- Addnl indicator [DZUSKZ]
    PMBDE,  -- Time event grp [PMBDE]
    GRAWG,  -- Grpg. att./abs. [GRAWG]
    GRELG,  -- EE expenses grpng [GRELG]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More