/APE/C_SH_BO_TYPE

DDL: /APE/C_SH_BO_TYPE SQL: /APE/C_SHBOTYPE Type: view CONSUMPTION

Search Help for BO Type

/APE/C_SH_BO_TYPE is a Consumption CDS View that provides data about "Search Help for BO Type" in SAP S/4HANA. It reads from 1 data source (/APE/C_BODataModelHeader) and exposes 6 fields with key field config_key. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/C_BODataModelHeader /APE/C_BODataModelHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..1] /APE/C_BusObjTypeText _bo_type_txt _bo_type_txt.ape_parent_key = $projection.bo_type_uuid and _bo_type_txt.language = $session.system_language

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_SHBOTYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Search Help for BO Type view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY config_key config_key Char
bo_type_uuid bo_type_uuid
bo_type bo_type SOT Name
proc_cluster proc_cluster
tech_msg_id tech_msg_id
description _bo_type_txt description Well Code Des.

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_SH_BO_TYPE.
-- 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_SHBOTYPE

CREATE VIEW /APE/C_SH_BO_TYPE AS
SELECT
  config_key,
  bo_type_uuid,
  bo_type,
  proc_cluster,
  tech_msg_id,
  _bo_type_txt.description AS description
FROM /APE/C_BODataModelHeader
LEFT OUTER JOIN /APE/C_BusObjTypeText AS _bo_type_txt ON _bo_type_txt.ape_parent_key = bo_type_uuid AND _bo_type_txt.language = $session.system_language  -- association [0..1]
;