PA0003

Transparent Table Application Table
48 Fields 9 CDS Views

HR Master Record: Infotype 0003 (Payroll Status)

PA0003 is an SAP database table in S/4HANA. HR Master Record: Infotype 0003 (Payroll Status). It contains 48 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_EmployeeOp view from BASIC Employee CDS view for OP
I_HCMEmployeeAddressBook view from Employee Address Book
I_HCMPayrollStatus view_entity from BASIC HCM Payroll Status
I_HrPersWrkAgrmt view from BASIC Internal for HCM : Donot Use
I_PMPersonResponsible view_entity inner BASIC Plant Maintenance Person Responsible
P_EmploymentOp view from BASIC
P_EmploymentOp_001 view from BASIC
P_HrPersWrkAgrmt view from BASIC
P_O_HrPersWrkAgrmt view from BASIC

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr PERSNO Personnel No.
subty SUBTY Subtype
objps OBJPS Object ID
sprps SPRPS Lock indicator
endda ENDDA End Date
begda BEGDA Start Date
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
abrsp ABRSP Pers.no.locked
abrdt LABRD Acctd to
rrdat RRDAT Earl.MD change
rrdaf RRDAF not in use
koabr PAD_INTERN Internal
prdat PRRDT Earl.pers.rec.date
pkgab PKGAB PersCalendar from
abwd1 ABWD1 Run payr. up to
abwd2 ABWD2 Do not account
bderr BDERR PDC recal.
bder1 BDER1 Effective recal.
kobde KOBDE PDC error indic
timrc TIMRC First PDC entry
dat00 DATP0 Initial input
uhr00 UHR00 Time of Init. Input
inumk CHAR8 char8
werks SBMOD Group
sachz SACHZ Time admin.
sfeld SFELD Sort field
adrun ADRUN Special run
viekn VIEKN IT view ind.
trvfl TRVFL Trips assigned
rcbon RCBON Mast.data chng.bonus
prtev PRTEV Earl.pers.rec.date
blocking_date HRPA_BLOCKING_DATE Blocking 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 0003 (Payroll Status)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0003 (
    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]
    ABRSP,          -- Pers.no.locked [ABRSP]
    ABRDT,          -- Acctd to [LABRD]
    RRDAT,          -- Earl.MD change [RRDAT]
    RRDAF,          -- not in use [RRDAF]
    KOABR,          -- Internal [PAD_INTERN]
    PRDAT,          -- Earl.pers.rec.date [PRRDT]
    PKGAB,          -- PersCalendar from [PKGAB]
    ABWD1,          -- Run payr. up to [ABWD1]
    ABWD2,          -- Do not account [ABWD2]
    BDERR,          -- PDC recal. [BDERR]
    BDER1,          -- Effective recal. [BDER1]
    KOBDE,          -- PDC error indic [KOBDE]
    TIMRC,          -- First PDC entry [TIMRC]
    DAT00,          -- Initial input [DATP0]
    UHR00,          -- Time of Init. Input [UHR00]
    INUMK,          -- char8 [CHAR8]
    WERKS,          -- Group [SBMOD]
    SACHZ,          -- Time admin. [SACHZ]
    SFELD,          -- Sort field [SFELD]
    ADRUN,          -- Special run [ADRUN]
    VIEKN,          -- IT view ind. [VIEKN]
    TRVFL,          -- Trips assigned [TRVFL]
    RCBON,          -- Mast.data chng.bonus [RCBON]
    PRTEV,          -- Earl.pers.rec.date [PRTEV]
    BLOCKING_DATE,  -- Blocking Date [HRPA_BLOCKING_DATE]
    PRIMARY KEY (MANDT, PERNR)
);

Learn More