DD02BND
DD: List of Nodes for a Structured Object
DD02BND is an SAP database table in S/4HANA. DD: List of Nodes for a Structured Object. It contains 35 fields. 20 CDS views read from this table.
CDS Views using this table (20)
| 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_BOE_HIERARCHY_TOP | view_entity | left_outer | asdf | |
| DDCDS_BOE_OBJINFO_PROCESSING_2 | view | left_outer | Compilation of all object info | |
| 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 (35)
| 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 |
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: List of Nodes for a Structured Object
-- 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]
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