PYC_D_MSGTY_T

Transparent Table Control Table (SAP+Cust)

Message Type Text

PYC_D_MSGTY_T is an SAP database table in S/4HANA. Message Type Text. It contains 4 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
hrpy_pcc_bpcm_ee view left_outer Employee Related BPC Messages
HRPY_PCC_BPCM_gen view left_outer Employee Related BPC Messages
hrpy_pcc_py_msg view left_outer PCC Payroll Messages
HRPY_PCC_PY_MSG_GEN view left_outer PCC Generic Payroll Messages

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sprsl SPRAS Language
KEY msgty SYMSGTY Message Type
name PYD_NAME_DB Name in DB

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.

-- Message Type Text
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PYC_D_MSGTY_T (
    MANDT,  -- Client [MANDT]
    SPRSL,  -- Language [SPRAS]
    MSGTY,  -- Message Type [SYMSGTY]
    NAME,   -- Name in DB [PYD_NAME_DB]
    PRIMARY KEY (MANDT, SPRSL, MSGTY)
);