PYC_D_PY_MSG_JOB

Transparent Table Application Table
35 Fields 1 CDS Views

Payroll Control Center: Jobs in Payroll Run

PYC_D_PY_MSG_JOB is an SAP database table in S/4HANA. Payroll Control Center: Jobs in Payroll Run. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
HRPY_PCC_PY_MSG_GEN_WIP view from PCC Generic PY Messages: Pre-processed

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY jobname BTCJOB Job Name
KEY jobcount BTCJOBCNT Job No.
KEY seqnr PYD_SEQNR Payroll Data Souce Sequence
iabkr ABKRS Payroll area
inpty PAYTY Payroll type
inpid PAYID Payroll Identifier
iaper CHAR6 Reserve
ibegd DATS Date
iendd DATS Date
chkdt CHKDT Check Date
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
cr_user SYUNAME User Name
cr_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: Jobs in Payroll Run
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PYC_D_PY_MSG_JOB (
    MANDT,        -- Client [MANDT]
    JOBNAME,      -- Job Name [BTCJOB]
    JOBCOUNT,     -- Job No. [BTCJOBCNT]
    SEQNR,        -- Payroll Data Souce Sequence [PYD_SEQNR]
    IABKR,        -- Payroll area [ABKRS]
    INPTY,        -- Payroll type [PAYTY]
    INPID,        -- Payroll Identifier [PAYID]
    IAPER,        -- Reserve [CHAR6]
    IBEGD,        -- Date [DATS]
    IENDD,        -- Date [DATS]
    CHKDT,        -- Check Date [CHKDT]
    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]
    CR_USER,      -- User Name [SYUNAME]
    CR_DT,        -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, JOBNAME, JOBCOUNT, SEQNR)
);

Learn More