BEL_D_EVENT
Business Event
BEL_D_EVENT is an SAP database table in S/4HANA. Business Event. It contains 34 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BusinessEventLogEvent | view | from | BASIC | Business Event Logging Business Event |
| P_BusEvtLogFieldChange | view_entity | inner | P_BusEvtLogFieldChange | |
| P_BUSINESSEVENTLOGEVENTSDM | view_entity | from | BASIC | Business Event Logging Business Event |
Fields (34)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | event_guid | SWE_EGUID | Event GUID | |||
| KEY | bo_type | SBO_BO_TYPE | SAP Object Type | |||
| KEY | exec_date | BEL_EXEC_DATE | Executed Date | |||
| obj_key | SWO_TYPEID | Key | ||||
| object_node_type | SBO_NODE_TYPE | SAP Obj Node Type | ||||
| bo_task | BEL_TASK_CODE | Business Event Type | ||||
| object_node_id | BEL_OBJECT_NODE_ID | BEL Object Node ID | ||||
| key1 | BEL_KEY1 | BO Key Part (1) | ||||
| key2 | BEL_KEY2 | BO Key Part (2) | ||||
| key3 | BEL_KEY3 | BO Key Part (3) | ||||
| key4 | BEL_KEY4 | BO Key Part (4) | ||||
| key5 | BEL_KEY5 | BO Key Part (5) | ||||
| key6 | BEL_KEY6 | BO Key Part (6) | ||||
| key7 | BEL_KEY7 | BO Key Part (7) | ||||
| key8 | BEL_KEY8 | BO Key Part (8) | ||||
| key1_raw | BEL_KEY1_RAW | Key1 Raw-16 | ||||
| uname | BEL_EXECUTED_BY | Executed By | ||||
| exec_timestamp | BEL_EXEC_TIMESTAMP | Executed Time Stamp | ||||
| exec_time | BEL_EXEC_TIME | Executed Time | ||||
| source_system | LOGSYS | Logical system | ||||
| transaction_id | BEL_TRANSACTION_ID | Transaction ID | ||||
| deleted | BEL_DELETE | Deleted | ||||
| pre_event_guid | SWE_EGUID | Event GUID | ||||
| kpi_duration | BEL_TIME_SINCE_LAST_EVENT | Lead Time | ||||
| kpi_dur_unit | BEL_PROC_KPI_UNIT | Process KPI Unit | ||||
| migration_status | SDM_STATUS_VALUE_DONE | status value done | ||||
| last_changed | LAST_CHANGED | Last Changed | ||||
| processing_status | BEL_PROC_STAT | Processing Status | ||||
| event_version | BEL_EVENT_VER | Evt Version | ||||
| event_source | BEL_EVENT_SRC | Evt Source | ||||
| producer_namespace | BEL_PRODUCER_NAMESPACE | Producer Event Nsps | ||||
| key1_char | BEL_KEY1_CHAR | BO Key Part (1) | ||||
| key_concat | BEL_KEY_CONCAT | BO Key |
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.
-- Business Event
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BEL_D_EVENT (
MANDT, -- Client [MANDT]
EVENT_GUID, -- Event GUID [SWE_EGUID]
BO_TYPE, -- SAP Object Type [SBO_BO_TYPE]
EXEC_DATE, -- Executed Date [BEL_EXEC_DATE]
OBJ_KEY, -- Key [SWO_TYPEID]
OBJECT_NODE_TYPE, -- SAP Obj Node Type [SBO_NODE_TYPE]
BO_TASK, -- Business Event Type [BEL_TASK_CODE]
OBJECT_NODE_ID, -- BEL Object Node ID [BEL_OBJECT_NODE_ID]
KEY1, -- BO Key Part (1) [BEL_KEY1]
KEY2, -- BO Key Part (2) [BEL_KEY2]
KEY3, -- BO Key Part (3) [BEL_KEY3]
KEY4, -- BO Key Part (4) [BEL_KEY4]
KEY5, -- BO Key Part (5) [BEL_KEY5]
KEY6, -- BO Key Part (6) [BEL_KEY6]
KEY7, -- BO Key Part (7) [BEL_KEY7]
KEY8, -- BO Key Part (8) [BEL_KEY8]
KEY1_RAW, -- Key1 Raw-16 [BEL_KEY1_RAW]
UNAME, -- Executed By [BEL_EXECUTED_BY]
EXEC_TIMESTAMP, -- Executed Time Stamp [BEL_EXEC_TIMESTAMP]
EXEC_TIME, -- Executed Time [BEL_EXEC_TIME]
SOURCE_SYSTEM, -- Logical system [LOGSYS]
TRANSACTION_ID, -- Transaction ID [BEL_TRANSACTION_ID]
DELETED, -- Deleted [BEL_DELETE]
PRE_EVENT_GUID, -- Event GUID [SWE_EGUID]
KPI_DURATION, -- Lead Time [BEL_TIME_SINCE_LAST_EVENT]
KPI_DUR_UNIT, -- Process KPI Unit [BEL_PROC_KPI_UNIT]
MIGRATION_STATUS, -- status value done [SDM_STATUS_VALUE_DONE]
LAST_CHANGED, -- Last Changed [LAST_CHANGED]
PROCESSING_STATUS, -- Processing Status [BEL_PROC_STAT]
EVENT_VERSION, -- Evt Version [BEL_EVENT_VER]
EVENT_SOURCE, -- Evt Source [BEL_EVENT_SRC]
PRODUCER_NAMESPACE, -- Producer Event Nsps [BEL_PRODUCER_NAMESPACE]
KEY1_CHAR, -- BO Key Part (1) [BEL_KEY1_CHAR]
KEY_CONCAT, -- BO Key [BEL_KEY_CONCAT]
PRIMARY KEY (MANDT, EVENT_GUID, BO_TYPE, EXEC_DATE)
);
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