PYC_D_PY_MSG

Transparent Table Application Table
52 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 52 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 (52)

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
funco FUNCO Function name
fnumb INUMB Int.number
parm1 PARM1 Par.1
parm2 PARM2 Par.2
parm3 PARM3 Par.3
parm4 PARM4 Par.4
proto PPROT Log
skip SKIP3 Offset
as_text CHAR40 Char
msgid SYMSGID Message Class
msgty SYMSGTY Message Type
msgno SYMSGNO Message Number
msgv1 SYMSGV Message Variable
msgv2 SYMSGV Message Variable
msgv3 SYMSGV Message Variable
msgv4 SYMSGV Message Variable
tlevel SEU_LEVEL Level
message PLOG_CROSS Message
text1 PLOG_TXT Job title
tlength1 PLOG_LEN Txt lngth PLOG_TXT
tintensiv1 SEU_INTENS Intensity of display
text2 PLOG_TXT Job title
tlength2 PLOG_LEN Txt lngth PLOG_TXT
tintensiv2 SEU_INTENS Intensity of display
text3 PLOG_TXT Job title
tlength3 PLOG_LEN Txt lngth PLOG_TXT
tintensiv3 SEU_INTENS Intensity of display
text4 PLOG_TXT Job title
tlength4 PLOG_LEN Txt lngth PLOG_TXT
tintensiv4 SEU_INTENS Intensity of display
empty_lines EMPTYLINES No.of blank lines
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]
    FUNCO,        -- Function name [FUNCO]
    FNUMB,        -- Int.number [INUMB]
    PARM1,        -- Par.1 [PARM1]
    PARM2,        -- Par.2 [PARM2]
    PARM3,        -- Par.3 [PARM3]
    PARM4,        -- Par.4 [PARM4]
    PROTO,        -- Log [PPROT]
    SKIP,         -- Offset [SKIP3]
    AS_TEXT,      -- Char [CHAR40]
    MSGID,        -- Message Class [SYMSGID]
    MSGTY,        -- Message Type [SYMSGTY]
    MSGNO,        -- Message Number [SYMSGNO]
    MSGV1,        -- Message Variable [SYMSGV]
    MSGV2,        -- Message Variable [SYMSGV]
    MSGV3,        -- Message Variable [SYMSGV]
    MSGV4,        -- Message Variable [SYMSGV]
    TLEVEL,       -- Level [SEU_LEVEL]
    MESSAGE,      -- Message [PLOG_CROSS]
    TEXT1,        -- Job title [PLOG_TXT]
    TLENGTH1,     -- Txt lngth PLOG_TXT [PLOG_LEN]
    TINTENSIV1,   -- Intensity of display [SEU_INTENS]
    TEXT2,        -- Job title [PLOG_TXT]
    TLENGTH2,     -- Txt lngth PLOG_TXT [PLOG_LEN]
    TINTENSIV2,   -- Intensity of display [SEU_INTENS]
    TEXT3,        -- Job title [PLOG_TXT]
    TLENGTH3,     -- Txt lngth PLOG_TXT [PLOG_LEN]
    TINTENSIV3,   -- Intensity of display [SEU_INTENS]
    TEXT4,        -- Job title [PLOG_TXT]
    TLENGTH4,     -- Txt lngth PLOG_TXT [PLOG_LEN]
    TINTENSIV4,   -- Intensity of display [SEU_INTENS]
    EMPTY_LINES,  -- No.of blank lines [EMPTYLINES]
    LC_USER,      -- User Name [SYUNAME]
    LC_DT,        -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, PERNR, IABKR, IAPER, IENDD, INPTY, INPID, TEST_RES, SEQNR)
);

Learn More