PA2007

Transparent Table Application Table
40 Fields 1 CDS Views

HR Time Record: Infotype 2007 (Attendance Quotas)

PA2007 is an SAP database table in S/4HANA. HR Time Record: Infotype 2007 (Attendance Quotas). It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_HCMAttendanceQuota view_entity from BASIC HCM Attendance Quota

Fields (40)

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
beguz BEGTI Start time
enduz ENDTI End time
vtken VTKEN Previous day
ktart ANWKO Att. quota type
anzhl PTM_QUONUM Quota number
versl VRSCH OT comp. type
kverb PTM_QUODED Deduction
bwtim BWTIM Approval before
awtim AWTIM Approval after
ttime TTIME Appr. full-day
quonr PTM_QUONR Quota counter
desta PTM_DEDSTART Deduction from
deend PTM_DEDEND Deduction to
quosy PTM_DOCSY Log. system
tdlangu TMW_TDLANGU Definition set
tdsubla TMW_TDSUBLA Subset
tdtype TDTYPE 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 Time Record: Infotype 2007 (Attendance Quotas)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA2007 (
    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]
    BEGUZ,    -- Start time [BEGTI]
    ENDUZ,    -- End time [ENDTI]
    VTKEN,    -- Previous day [VTKEN]
    KTART,    -- Att. quota type [ANWKO]
    ANZHL,    -- Quota number [PTM_QUONUM]
    VERSL,    -- OT comp. type [VRSCH]
    KVERB,    -- Deduction [PTM_QUODED]
    BWTIM,    -- Approval before [BWTIM]
    AWTIM,    -- Approval after [AWTIM]
    TTIME,    -- Appr. full-day [TTIME]
    QUONR,    -- Quota counter [PTM_QUONR]
    DESTA,    -- Deduction from [PTM_DEDSTART]
    DEEND,    -- Deduction to [PTM_DEDEND]
    QUOSY,    -- Log. system [PTM_DOCSY]
    TDLANGU,  -- Definition set [TMW_TDLANGU]
    TDSUBLA,  -- Subset [TMW_TDSUBLA]
    TDTYPE,   -- ID [TDTYPE]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More