PA0007

Transparent Table Application Table
44 Fields 6 CDS Views

HR Master Record: Infotype 0007 (Planned Working Time)

PA0007 is an SAP database table in S/4HANA. HR Master Record: Infotype 0007 (Planned Working Time). It contains 44 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FNDEI_PA0007_BLOCKINGINFO view from Blocking View for table PA0007
FNDEI_PA0007_FILTER view from Filter View for table PA0007
I_HCMPlannedWorkingTime view_entity from BASIC HCM planned working time
I_PersonWorkAgrmtPlndWrkgTime view from BASIC Work Agreement Planned Working time
P_EmployWSDet view from BASIC
P_O_EmployWSDet view from BASIC

Fields (44)

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
schkz SCHKN WS rule
zterf PT_ZTERF Time Mgt status
empct EMPCT Empl. %
mostd MOSTD Monthly hours
wostd WOSTD Weekly work hrs
arbst STDTG Daily wkng hrs
wkwdy WARST Workdays
jrstd JRSTD Annual hours
teilk TEILK Part-time empl.
minta MINTA Min.wrk.hrs/day
maxta MAXTA Max.wrk.hrs/day
minwo MINWO Min.weekly hrs
maxwo MAXWO Max.wrk.hrs/wk
minmo MINMO Min.wrk.hrs/mo.
maxmo MAXMO Max.wrk.hrs/mo.
minja MINJA Min.wrk.hrs/yr.
maxja MAXJA Max.wrk.hrs/yr.
dysch DYSCH Dyn.daily WS
kztim KZTIM Add.ID time
wweek WWEEK Working week
awtyp AWTYP Ref. procedure

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 0007 (Planned Working Time)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0007 (
    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]
    SCHKZ,  -- WS rule [SCHKN]
    ZTERF,  -- Time Mgt status [PT_ZTERF]
    EMPCT,  -- Empl. % [EMPCT]
    MOSTD,  -- Monthly hours [MOSTD]
    WOSTD,  -- Weekly work hrs [WOSTD]
    ARBST,  -- Daily wkng hrs [STDTG]
    WKWDY,  -- Workdays [WARST]
    JRSTD,  -- Annual hours [JRSTD]
    TEILK,  -- Part-time empl. [TEILK]
    MINTA,  -- Min.wrk.hrs/day [MINTA]
    MAXTA,  -- Max.wrk.hrs/day [MAXTA]
    MINWO,  -- Min.weekly hrs [MINWO]
    MAXWO,  -- Max.wrk.hrs/wk [MAXWO]
    MINMO,  -- Min.wrk.hrs/mo. [MINMO]
    MAXMO,  -- Max.wrk.hrs/mo. [MAXMO]
    MINJA,  -- Min.wrk.hrs/yr. [MINJA]
    MAXJA,  -- Max.wrk.hrs/yr. [MAXJA]
    DYSCH,  -- Dyn.daily WS [DYSCH]
    KZTIM,  -- Add.ID time [KZTIM]
    WWEEK,  -- Working week [WWEEK]
    AWTYP,  -- Ref. procedure [AWTYP]
    PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);

Learn More