GHO_ALERT
Store Network Alerts
GHO_ALERT is an SAP database table in S/4HANA. Store Network Alerts. It contains 19 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_GHONetworkAlerts | view_entity | from | BASIC | Network Alerts |
Fields (19)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | alert_id | GUID_32 | GUID 16 | |||
| net_id | GHO_PFN_ID | Production Flow NW | ||||
| medium | MEDIU | Medium | ||||
| frequency | GHO_ALLOC_FREQNCY | Allocation Frequency | ||||
| prod_date | DATS | Date | ||||
| prod_time | TIMS | Field of type TIMS | ||||
| alloc_type | GHO_ALLOC_TYPE | Allocation Type | ||||
| event_id | GHO_DM_EVENT_ID | Defmt Evt ID | ||||
| tplnr | TPLNR | Functional loc. | ||||
| measmnt | GHO_MEASMNT | Measurement | ||||
| category | SALRTDCAT | Alert Category | ||||
| message | BAPI_MSG | Message Text | ||||
| navigation | CHAR20 | Char20 | ||||
| process_type | GHO_PROCESS_TYPE | Process Type | ||||
| intent | GHO_INTENT | Intent | ||||
| param | abap.char | |||||
| alert_type | GHO_ALERT_TYPE | Alert Type | ||||
| prod_aloc_datetime_utc | GHO_PRODALLOC_UTC_DATETIME | Production UTC Date Time |
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.
-- Store Network Alerts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GHO_ALERT (
MANDT, -- Client [MANDT]
ALERT_ID, -- GUID 16 [GUID_32]
NET_ID, -- Production Flow NW [GHO_PFN_ID]
MEDIUM, -- Medium [MEDIU]
FREQUENCY, -- Allocation Frequency [GHO_ALLOC_FREQNCY]
PROD_DATE, -- Date [DATS]
PROD_TIME, -- Field of type TIMS [TIMS]
ALLOC_TYPE, -- Allocation Type [GHO_ALLOC_TYPE]
EVENT_ID, -- Defmt Evt ID [GHO_DM_EVENT_ID]
TPLNR, -- Functional loc. [TPLNR]
MEASMNT, -- Measurement [GHO_MEASMNT]
CATEGORY, -- Alert Category [SALRTDCAT]
MESSAGE, -- Message Text [BAPI_MSG]
NAVIGATION, -- Char20 [CHAR20]
PROCESS_TYPE, -- Process Type [GHO_PROCESS_TYPE]
INTENT, -- Intent [GHO_INTENT]
PARAM, -- abap.char
ALERT_TYPE, -- Alert Type [GHO_ALERT_TYPE]
PROD_ALOC_DATETIME_UTC, -- Production UTC Date Time [GHO_PRODALLOC_UTC_DATETIME]
PRIMARY KEY (MANDT, ALERT_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