BEL_D_NODE_REL
Object Node Relationship
BEL_D_NODE_REL is an SAP database table in S/4HANA. Object Node Relationship. It contains 26 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BusEvtLogObjectNodeRelshp | view | from | BASIC | Bus Evt Log Object Node Relationship |
Fields (26)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | object_node_id | bel_object_node_id | BEL Object Node ID | |||
| KEY | rel_object_node_id | bel_object_node_id | BEL Object Node ID | |||
| KEY | bo_type | sap_object_type_raw | SOT Name | |||
| KEY | associationname | ddassociationname | DD: Name of an Association | |||
| object_node_type | sap_object_node_type_raw | SONT Name | ||||
| node_key1 | bel_key1 | BO Key Part (1) | ||||
| node_key2 | bel_key2 | BO Key Part (2) | ||||
| node_key3 | bel_key3 | BO Key Part (3) | ||||
| node_key4 | bel_key4 | BO Key Part (4) | ||||
| node_key5 | bel_key5 | BO Key Part (5) | ||||
| node_key6 | bel_key6 | BO Key Part (6) | ||||
| node_key7 | bel_key7 | BO Key Part (7) | ||||
| node_key8 | bel_key8 | BO Key Part (8) | ||||
| rel_bo_type | sbo_bo_type | SAP Object Type | ||||
| rel_object_node_type | sbo_node_type | SAP Obj Node Type | ||||
| rel_node_key1 | bel_key1 | BO Key Part (1) | ||||
| rel_node_key2 | bel_key2 | BO Key Part (2) | ||||
| rel_node_key3 | bel_key3 | BO Key Part (3) | ||||
| rel_node_key4 | bel_key4 | BO Key Part (4) | ||||
| rel_node_key5 | bel_key5 | BO Key Part (5) | ||||
| rel_node_key6 | bel_key6 | BO Key Part (6) | ||||
| rel_node_key7 | bel_key7 | BO Key Part (7) | ||||
| rel_node_key8 | bel_key8 | BO Key Part (8) | ||||
| outdated | bel_outdated | Outdated | ||||
| last_changed | last_changed | Last Changed |
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.
-- Object Node Relationship
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BEL_D_NODE_REL (
MANDT, -- Client [mandt]
OBJECT_NODE_ID, -- BEL Object Node ID [bel_object_node_id]
REL_OBJECT_NODE_ID, -- BEL Object Node ID [bel_object_node_id]
BO_TYPE, -- SOT Name [sap_object_type_raw]
ASSOCIATIONNAME, -- DD: Name of an Association [ddassociationname]
OBJECT_NODE_TYPE, -- SONT Name [sap_object_node_type_raw]
NODE_KEY1, -- BO Key Part (1) [bel_key1]
NODE_KEY2, -- BO Key Part (2) [bel_key2]
NODE_KEY3, -- BO Key Part (3) [bel_key3]
NODE_KEY4, -- BO Key Part (4) [bel_key4]
NODE_KEY5, -- BO Key Part (5) [bel_key5]
NODE_KEY6, -- BO Key Part (6) [bel_key6]
NODE_KEY7, -- BO Key Part (7) [bel_key7]
NODE_KEY8, -- BO Key Part (8) [bel_key8]
REL_BO_TYPE, -- SAP Object Type [sbo_bo_type]
REL_OBJECT_NODE_TYPE, -- SAP Obj Node Type [sbo_node_type]
REL_NODE_KEY1, -- BO Key Part (1) [bel_key1]
REL_NODE_KEY2, -- BO Key Part (2) [bel_key2]
REL_NODE_KEY3, -- BO Key Part (3) [bel_key3]
REL_NODE_KEY4, -- BO Key Part (4) [bel_key4]
REL_NODE_KEY5, -- BO Key Part (5) [bel_key5]
REL_NODE_KEY6, -- BO Key Part (6) [bel_key6]
REL_NODE_KEY7, -- BO Key Part (7) [bel_key7]
REL_NODE_KEY8, -- BO Key Part (8) [bel_key8]
OUTDATED, -- Outdated [bel_outdated]
LAST_CHANGED, -- Last Changed [last_changed]
PRIMARY KEY (MANDT, OBJECT_NODE_ID, REL_OBJECT_NODE_ID, BO_TYPE, ASSOCIATIONNAME)
);
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