PYC_D_PY_MSG

Transparent Table Application Table
22 Fields 1 CDS Views

Payroll Control Center: Payroll Messages

PYC_D_PY_MSG is an SAP database table in S/4HANA. Payroll Control Center: Payroll Messages. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
HRPY_PCC_PY_MSG_WIP view from PCC Payroll Messages: Pre-processed

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pernr pernr_d Personnel No.
KEY iabkr abkrs Payroll area
KEY iaper iperi In-Period
KEY iendd endda End Date
KEY inpty payty Payroll type
KEY inpid payid Payroll Identifier
KEY test_res hrdct_is_tpy Payroll Test Results
KEY seqnr pyd_seqnr Payroll Data Souce Sequence
msgpo char1 Single-Character Flag
abkrs abkrs Payroll area
paper char6 Reserve
begda dats Date
endda dats Date
payty payty Payroll type
payid payid Payroll Identifier
ocrsn pay_ocrsn Off-cycle reas.
chkdt chkdt Check Date
personid personid_ext Person ID
as_text char40 Char
lc_user syuname User Name
lc_dt timestampl Time Stamp

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.

-- Payroll Control Center: Payroll Messages
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PYC_D_PY_MSG (
    MANDT,     -- Client [mandt]
    PERNR,     -- Personnel No. [pernr_d]
    IABKR,     -- Payroll area [abkrs]
    IAPER,     -- In-Period [iperi]
    IENDD,     -- End Date [endda]
    INPTY,     -- Payroll type [payty]
    INPID,     -- Payroll Identifier [payid]
    TEST_RES,  -- Payroll Test Results [hrdct_is_tpy]
    SEQNR,     -- Payroll Data Souce Sequence [pyd_seqnr]
    MSGPO,     -- Single-Character Flag [char1]
    ABKRS,     -- Payroll area [abkrs]
    PAPER,     -- Reserve [char6]
    BEGDA,     -- Date [dats]
    ENDDA,     -- Date [dats]
    PAYTY,     -- Payroll type [payty]
    PAYID,     -- Payroll Identifier [payid]
    OCRSN,     -- Off-cycle reas. [pay_ocrsn]
    CHKDT,     -- Check Date [chkdt]
    PERSONID,  -- Person ID [personid_ext]
    AS_TEXT,   -- Char [char40]
    LC_USER,   -- User Name [syuname]
    LC_DT,     -- Time Stamp [timestampl]
    PRIMARY KEY (MANDT, PERNR, IABKR, IAPER, IENDD, INPTY, INPID, TEST_RES, SEQNR)
);

Learn More