PYT_D_ALERT
PCC: Activity Alert
PYT_D_ALERT is an SAP database table in S/4HANA. PCC: Activity Alert. It contains 6 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| HRPY_PCC_ALERT | view_entity | from | Alerts | |
| hrpy_pcc_alert_ee | view_entity | from | Employee Alerts |
Fields (6)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | ref_id | pyc_uuid | PCC UUID | |||
| status | pyt_alert_status | Alert Status | ||||
| acl_act_ref_id | pyc_uuid | PCC UUID | ||||
| pol_ref_id | pyc_uuid | PCC UUID | ||||
| 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]
STATUS, -- Alert Status [pyt_alert_status]
ACL_ACT_REF_ID, -- PCC UUID [pyc_uuid]
POL_REF_ID, -- PCC UUID [pyc_uuid]
IS_MDC_ALLOWED, -- TRUE [boole_d]
PRIMARY KEY (MANDT, REF_ID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA