DD02BND
DD: Liste der Knoten zu eines strukturierten Objektes
DD02BND is an SAP database table in S/4HANA. DD: Liste der Knoten zu eines strukturierten Objektes. It contains 41 fields. 18 CDS views read from this table.
CDS Views using this table (18)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SSB/ANALYTICS_CDS3_LIST | view | inner | Fetches CDS 3.0 Analytical Queries | |
| Ars_V_Ddls_Extensions | view_entity | inner | API Release: CDS Extensions (DDLS) | |
| C_ABI_Analytical_Query | view_entity | inner | CONSUMPTION | Analytical Query List |
| Cds_Views | view | inner | List of All CDS Views | |
| CDS_Views_Extension | view | inner | CDS Views with extension | |
| CSN_EXPOSURE_CDS_DEFAULT_FT | view | inner | CSN Entities with feature flag | |
| CSN_EXPOSURE_CDS_DEFAULT_NFT | view | inner | CSN Entities with no feature flag | |
| DD_CDS_ROOTREF_BASE | view_entity | inner | Base for root composition hierarchy | |
| DDCDS_ENTITY_HEADER | view_entity | inner | CDS Entities: Header Information | |
| DDCDS_RAP_TRANSACT_INTERFACES | view_entity | from | ABAP Dictionary: Transactional Interface | |
| DDCDS_USED_SESSION_VARIABLE | view_entity | from | CDS: Acronyms for used session variables | |
| DDL_OBJECT_NAMES_COPY | view | inner | Zuordnung der Namen von DDL,Entität,DB_View,Extendbasisview | |
| DHAMB_BASE_DP_CDS_NODES | view_entity | inner | DI meta data browser: list of CDS views | |
| I_CCV_DataSource_VH_1 | view_entity | inner | CCV Datasource VH primary || associated | |
| QB_V2_V3_QUERY | view | inner | Get direct base objects | |
| RSRTS_QF4_QUERYWOPROVIDER | view_entity | inner | Queries (without Provider Info) | |
| VB_CDS_VIEWS | view | inner | List of All CDS Views | |
| VB_CDS_VIEWS_EXTN | view | inner | List of All CDS Views with view extn |
Fields (41)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | strucobjn | ddstrucobjname | DD: Name of a structured object (e.g. entity, context) | |||
| KEY | nodename | ddnodename | Node Name of BO in ABAP Dictionary | |||
| KEY | as4local | as4local | Activation State | |||
| nodekind | ddnodekind | Type of Node in ABAP Dictionary | ||||
| dbtabname | tabname | Table Name | ||||
| dbobjkind | dbobjkind | DD: Type of DB Object of Node, View, or Table | ||||
| suffix | ddsuffix | DD: Suffix for Field Names | ||||
| ndposition | ddfdpos | DD: Marked Position in a Repeat Group | ||||
| nodeorigin | ddnodeorigin | DD: Origin of a BO Node | ||||
| isrootnode | ddrootnode | DD: Flag whether a node is the root node | ||||
| dbismaster | ddismaster | DD: Database object determines structured object | ||||
| clientfield | fieldname | Field Name | ||||
| exview_included | ddextview_included | DD: Contains at least one external view in the hierarchy | ||||
| with_parameters | ddwithpar | DD: Set whenever a view or base view has parameters | ||||
| accessctrl_target | ddaccessctrl_target | DD: Target entity for a view generated from the DCL | ||||
| accessctrl_not_allowed | ddaccessctrl_not_allowed | DD: Authorization checks are not allowed in this entity | ||||
| nontrp_included | ddnontransp_included | Obsolete | ||||
| amdp_name | ddamdpname | DD: Name of ABAP-Managed DB Procedure | ||||
| tbfunc_included | ddtbfunc_included | Contains info whether a table function exists in hierarchy | ||||
| session_var_ex | ddsessionvar_ex | DD: Does a session variable exist? | ||||
| baseobj_nr | ddbaseobj_nr | DD: Number of basis objects used | ||||
| used_session_vars | ddusedsession_vars | DD: Session Variables Used | ||||
| hdb_only_entity_included | ddhdbonly_entity_included | HDB entity | ||||
| rootnode_ref | ddstrucobjname | DD: Name of a structured object (e.g. entity, context) | ||||
| has_select_asterisk | ddcds_asterisk | Has Select * | ||||
| provider_contract | dd_cds_provider_contract | Provider Contract | ||||
| bufferable | dd_bufferable | Bufferability | ||||
| buffered | dd_buffered | Buffering status | ||||
| buffer_propagatable | dd_buffer_propagatable | Allows Propagations | ||||
| appl_session_vars | dd_appl_session_vars | DD: Used Application Session Variables | ||||
| accessctrl_auth_check | dd_accessctrl_auth_check | Authorization Check | ||||
| own_used_session_vars | ddusedsession_vars | DD: Session Variables Used | ||||
| own_appl_session_vars | dd_appl_session_vars | DD: Used Application Session Variables | ||||
| sql_passvalue_client | ddsqlpassvalue | SQL Pass Value | ||||
| accessctrl_audit_filter | dd_accessctrl_audit_filter | Audit Filter | ||||
| writable | dd_writable | |||||
| own_client_safety | dd_own_client_safety | |||||
| is_client_safe | dd_client_safe | |||||
| log_data_changes | ddprotocol | Log | ||||
| accessctrl_write_operation | dd_accessctrl_write_operation | |||||
| allowed_for_amdp_write | dd_allowed_4_amdp_write |
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.
-- DD: Liste der Knoten zu eines strukturierten Objektes
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD02BND (
STRUCOBJN, -- DD: Name of a structured object (e.g. entity, context) [ddstrucobjname]
NODENAME, -- Node Name of BO in ABAP Dictionary [ddnodename]
AS4LOCAL, -- Activation State [as4local]
NODEKIND, -- Type of Node in ABAP Dictionary [ddnodekind]
DBTABNAME, -- Table Name [tabname]
DBOBJKIND, -- DD: Type of DB Object of Node, View, or Table [dbobjkind]
SUFFIX, -- DD: Suffix for Field Names [ddsuffix]
NDPOSITION, -- DD: Marked Position in a Repeat Group [ddfdpos]
NODEORIGIN, -- DD: Origin of a BO Node [ddnodeorigin]
ISROOTNODE, -- DD: Flag whether a node is the root node [ddrootnode]
DBISMASTER, -- DD: Database object determines structured object [ddismaster]
CLIENTFIELD, -- Field Name [fieldname]
EXVIEW_INCLUDED, -- DD: Contains at least one external view in the hierarchy [ddextview_included]
WITH_PARAMETERS, -- DD: Set whenever a view or base view has parameters [ddwithpar]
ACCESSCTRL_TARGET, -- DD: Target entity for a view generated from the DCL [ddaccessctrl_target]
ACCESSCTRL_NOT_ALLOWED, -- DD: Authorization checks are not allowed in this entity [ddaccessctrl_not_allowed]
NONTRP_INCLUDED, -- Obsolete [ddnontransp_included]
AMDP_NAME, -- DD: Name of ABAP-Managed DB Procedure [ddamdpname]
TBFUNC_INCLUDED, -- Contains info whether a table function exists in hierarchy [ddtbfunc_included]
SESSION_VAR_EX, -- DD: Does a session variable exist? [ddsessionvar_ex]
BASEOBJ_NR, -- DD: Number of basis objects used [ddbaseobj_nr]
USED_SESSION_VARS, -- DD: Session Variables Used [ddusedsession_vars]
HDB_ONLY_ENTITY_INCLUDED, -- HDB entity [ddhdbonly_entity_included]
ROOTNODE_REF, -- DD: Name of a structured object (e.g. entity, context) [ddstrucobjname]
HAS_SELECT_ASTERISK, -- Has Select * [ddcds_asterisk]
PROVIDER_CONTRACT, -- Provider Contract [dd_cds_provider_contract]
BUFFERABLE, -- Bufferability [dd_bufferable]
BUFFERED, -- Buffering status [dd_buffered]
BUFFER_PROPAGATABLE, -- Allows Propagations [dd_buffer_propagatable]
APPL_SESSION_VARS, -- DD: Used Application Session Variables [dd_appl_session_vars]
ACCESSCTRL_AUTH_CHECK, -- Authorization Check [dd_accessctrl_auth_check]
OWN_USED_SESSION_VARS, -- DD: Session Variables Used [ddusedsession_vars]
OWN_APPL_SESSION_VARS, -- DD: Used Application Session Variables [dd_appl_session_vars]
SQL_PASSVALUE_CLIENT, -- SQL Pass Value [ddsqlpassvalue]
ACCESSCTRL_AUDIT_FILTER, -- Audit Filter [dd_accessctrl_audit_filter]
WRITABLE, -- dd_writable
OWN_CLIENT_SAFETY, -- dd_own_client_safety
IS_CLIENT_SAFE, -- dd_client_safe
LOG_DATA_CHANGES, -- Log [ddprotocol]
ACCESSCTRL_WRITE_OPERATION, -- dd_accessctrl_write_operation
ALLOWED_FOR_AMDP_WRITE, -- dd_allowed_4_amdp_write
PRIMARY KEY (STRUCOBJN, NODENAME, AS4LOCAL)
);
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