/APE/C_BOSTRGR_UI

DDL: /APE/C_BOSTRGR_UI Type: view CONSUMPTION

Business Object Strategy Group

/APE/C_BOSTRGR_UI is a Consumption CDS View that provides data about "Business Object Strategy Group" in SAP S/4HANA. It reads from 1 data source (/APE/I_BOSTRGR_TP) and exposes 20 fields with key field BOStrategyGroupKey. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_BOSTRGR_TP BOStrategyGrp from

Associations (7)

CardinalityTargetAliasCondition
[0..1] /APE/C_ProcessCluster_VH _ProcessClusterVH _ProcessClusterVH.ProcessClusterKey = $projection.ProcessClusterKey
[0..*] /APE/C_BOSTRGRT_UI _TEXT $projection.BOStrategyGroupKey = _TEXT.BOStrGrpTextKey
[0..*] /APE/C_BOSTRAS_UI _STRAS $projection.BOStrategyGroupKey = _STRAS.StrategyGroupIDKey
[0..1] /APE/C_BOStrategyGrop_VH _Description _Description.StrategyGroupKey = $projection.BOStrategyGroupKey
[0..1] /APE/C_MarketRole_VH _MarketRole _MarketRole.MarketRole = $projection.MarketRole
[0..1] /APE/C_ConfigLayer_VH _ConfigurationLayer _ConfigurationLayer.Value = $projection.ConfigurationLayer
[0..1] /APE/C_DeploymentTarget_VH _DeploymentTarget _DeploymentTarget.Value = $projection.DeploymentTarget

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_BOSGRUI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Object Strategy Group view
VDM.viewType #CONSUMPTION view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.allowExtensions true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BOStrategyGroupKey /APE/I_BOSTRGR_TP config_key Char
ProcessClusterKey /APE/I_BOSTRGR_TP proc_cluster_uuid
proc_cluster /APE/I_BOSTRGR_TP proc_cluster
ProcessClusterLi /APE/I_BOSTRGR_TP proc_cluster
ProcessClusterDescription _ProcessClusterVH ProcessClusterDescription
ProcessClusterDescriptionISL _ProcessClusterVH ProcessClusterDescriptionISL
StrategyGroupID /APE/I_BOSTRGR_TP strategy_group_id
StrategyGroupIDLI /APE/I_BOSTRGR_TP strategy_group_id
StrategyGroupIDDescription _Description StrategyGroupDescription
StrategyGroupIDDescriptionISL _Description StrategyGroupDescriptionISL
DeploymentTarget /APE/I_BOSTRGR_TP deploy_target
DeploymentTargetDescription _DeploymentTarget Description Well Code Des.
ConfigurationLayer /APE/I_BOSTRGR_TP config_layer
ConfigurationLayerDescription _ConfigurationLayer Description Well Code Des.
MarketRole /APE/I_BOSTRGR_TP market_role
MarketRoleDescription _MarketRole MarketRoleDescription
_ProcessClusterVH _ProcessClusterVH
_TEXT _TEXT
_STRAS _STRAS
_Description _Description

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_BOSTRGR_UI.
-- 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.

CREATE VIEW /APE/C_BOSTRGR_UI AS
SELECT
  BOStrategyGrp.config_key AS BOStrategyGroupKey,
  BOStrategyGrp.proc_cluster_uuid AS ProcessClusterKey,
  BOStrategyGrp.proc_cluster AS proc_cluster,
  BOStrategyGrp.proc_cluster AS ProcessClusterLi,
  _ProcessClusterVH.ProcessClusterDescription AS ProcessClusterDescription,
  _ProcessClusterVH.ProcessClusterDescriptionISL AS ProcessClusterDescriptionISL,
  BOStrategyGrp.strategy_group_id AS StrategyGroupID,
  BOStrategyGrp.strategy_group_id AS StrategyGroupIDLI,
  _Description.StrategyGroupDescription AS StrategyGroupIDDescription,
  _Description.StrategyGroupDescriptionISL AS StrategyGroupIDDescriptionISL,
  BOStrategyGrp.deploy_target AS DeploymentTarget,
  _DeploymentTarget.Description AS DeploymentTargetDescription,
  BOStrategyGrp.config_layer AS ConfigurationLayer,
  _ConfigurationLayer.Description AS ConfigurationLayerDescription,
  BOStrategyGrp.market_role AS MarketRole,
  _MarketRole.MarketRoleDescription AS MarketRoleDescription
FROM /APE/I_BOSTRGR_TP AS BOStrategyGrp
LEFT OUTER JOIN /APE/C_ProcessCluster_VH AS _ProcessClusterVH ON _ProcessClusterVH.ProcessClusterKey = ProcessClusterKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_BOSTRGRT_UI AS _TEXT ON BOStrategyGroupKey = _TEXT.BOStrGrpTextKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_BOSTRAS_UI AS _STRAS ON BOStrategyGroupKey = _STRAS.StrategyGroupIDKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_BOStrategyGrop_VH AS _Description ON _Description.StrategyGroupKey = BOStrategyGroupKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_MarketRole_VH AS _MarketRole ON _MarketRole.MarketRole = MarketRole  -- association [0..1]
LEFT OUTER JOIN /APE/C_ConfigLayer_VH AS _ConfigurationLayer ON _ConfigurationLayer.Value = ConfigurationLayer  -- association [0..1]
LEFT OUTER JOIN /APE/C_DeploymentTarget_VH AS _DeploymentTarget ON _DeploymentTarget.Value = DeploymentTarget  -- association [0..1]
;