PA0003

Transparent Table Application Table
8 Fields 3 CDS Views

Personal-Stammsatz Infotyp 0003 (Abrechnungsstatus)

PA0003 is an SAP database table in S/4HANA. Personal-Stammsatz Infotyp 0003 (Abrechnungsstatus). It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_EmployeeOp view from BASIC Employee CDS view for OP
P_EmploymentOp view from BASIC Employment for OnPremise
P_O_HrPersWrkAgrmt view from BASIC Internal for HCM, search view N_PERSONWORKAGREEMENT_1

Fields (8)

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.

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.

-- Personal-Stammsatz Infotyp 0003 (Abrechnungsstatus)
-- 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]
    PRIMARY KEY (MANDT, PERNR)
);

Learn More