PYT_D_ALERT

Transparent Table Application Table
16 Fields 2 CDS Views

PCC: Activity Alert

PYT_D_ALERT is an SAP database table in S/4HANA. PCC: Activity Alert. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
HRPY_PCC_ALERT view_entity from Alerts
hrpy_pcc_alert_ee view_entity from Employee Alerts

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ref_id PYC_UUID PCC UUID
vr_ref_id PYC_UUID PCC UUID
recurrence PYC_UUID PCC UUID
alert_entity abap.char
id abap.char
status PYT_ALERT_STATUS Alert Status
acl_act_ref_id PYC_UUID PCC UUID
pol_ref_id PYC_UUID PCC UUID
cr_user SYUNAME User Name
cr_dt TIMESTAMP Time Stamp
lc_user SYUNAME User Name
lc_dt TIMESTAMP Time Stamp
team_ref_id PYC_UUID PCC UUID
user_id UNAME User Name
is_mdc_allowed BOOLE_D TRUE

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.

-- PCC: Activity Alert
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PYT_D_ALERT (
    MANDT,           -- Client [MANDT]
    REF_ID,          -- PCC UUID [PYC_UUID]
    VR_REF_ID,       -- PCC UUID [PYC_UUID]
    RECURRENCE,      -- PCC UUID [PYC_UUID]
    ALERT_ENTITY,    -- abap.char
    ID,              -- abap.char
    STATUS,          -- Alert Status [PYT_ALERT_STATUS]
    ACL_ACT_REF_ID,  -- PCC UUID [PYC_UUID]
    POL_REF_ID,      -- PCC UUID [PYC_UUID]
    CR_USER,         -- User Name [SYUNAME]
    CR_DT,           -- Time Stamp [TIMESTAMP]
    LC_USER,         -- User Name [SYUNAME]
    LC_DT,           -- Time Stamp [TIMESTAMP]
    TEAM_REF_ID,     -- PCC UUID [PYC_UUID]
    USER_ID,         -- User Name [UNAME]
    IS_MDC_ALLOWED,  -- TRUE [BOOLE_D]
    PRIMARY KEY (MANDT, REF_ID)
);

Learn More