/APE/C_BODMHdrT_VH

DDL: /APE/C_BODMHDRT_VH SQL: /APE/C_BODMHTVH Type: view CONSUMPTION

Business Object Data Model

/APE/C_BODMHdrT_VH is a Consumption CDS View that provides data about "Business Object Data Model" in SAP S/4HANA. It reads from 1 data source (/APE/C_BODataModelHeader) and exposes 7 fields with key field BusinessObjectDataModelKey. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/C_BODataModelHeader BODMHdr from

Associations (2)

CardinalityTargetAliasCondition
[0..*] /APE/C_BODataMedelHdrText _Text _Text.ape_parent_key = BODMHdr.config_key
[1..1] /APE/C_ProcessCluster _ProcessCluster $projection.proc_cluster_uuid = _ProcessCluster.config_key

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_BODMHTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Object Data Model view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectDataModelKey /APE/C_BODataModelHeader config_key BO Data Model Key
descriptionasdescriptionISL
ProcessCluster _ProcessCluster proc_cluster
BusinessObjectType /APE/C_BODataModelHeader bo_type SOT Name
Version /APE/C_BODataModelHeader version XML Vers.
proc_cluster _ProcessCluster proc_cluster
bo_ddic_type /APE/C_BODataModelHeader bo_ddic_type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view /APE/C_BODMHdrT_VH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: /APE/C_BODMHTVH

CREATE VIEW /APE/C_BODMHdrT_VH AS
SELECT
  BODMHdr.config_key AS BusinessObjectDataModelKey,
  _Text[1: language = $session.system_language ].description as descriptionISL AS descriptionasdescriptionISL,
  _ProcessCluster.proc_cluster AS ProcessCluster,
  BODMHdr.bo_type AS BusinessObjectType,
  BODMHdr.version AS Version,
  _ProcessCluster.proc_cluster AS proc_cluster,
  BODMHdr.bo_ddic_type AS bo_ddic_type
FROM /APE/C_BODataModelHeader AS BODMHdr
LEFT OUTER JOIN /APE/C_BODataMedelHdrText AS _Text ON _Text.ape_parent_key = BODMHdr.config_key  -- association [0..*]
LEFT OUTER JOIN /APE/C_ProcessCluster AS _ProcessCluster ON proc_cluster_uuid = _ProcessCluster.config_key  -- association [1..1]
;