/APE/C_BusMsg_UI

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_BusMsg_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_BusMsg_UI AS
SELECT
  config_key AS BusinessMessageKey,
  proc_cluster_uuid AS ProcessClusterKey,
  proc_cluster AS ProcessCluster,
  proc_cluster,
  proc_cluster AS ProcessClusterLi,
  _ProcessClusterKeyVH.ProcessClusterDescription AS ProcessClusterDescription,
  _ProcessClusterKeyVH.ProcessClusterDescriptionISL AS ProcessClusterDescriptionISL,
  bus_msg_id_uuid AS BusinessMessageIDKey,
  bus_msg_id AS BusinessMessageID,
  bus_msg_id AS BusinessMessageIDLI,
  _BusinessMessageIDKeyVH.BusinessMessageIDDescription AS BusinessMessageIDDescription,
  _BusinessMessageIDKeyVH.BusMsgIDDescriptionISL AS BusMsgIDDescriptionISL,
  bus_msg_id_ext AS ExternalBusinessMessageID,
  execution_priority AS ExecutionPriority,
  _BusMsgCust.config_key AS CustKey,
  _BusMsgCust.execution_priority AS CustExecutionPriority,
  0 AS FCExtended,
  version_uuid AS VersionKey,
  Version,
  version AS VersionLi,
  _VersionKeyVH.VersionDescription AS VersionDescription,
  _VersionKeyVH.DescriptionInLoginLanguage AS VersionDescriptionISL,
  market_role_own AS MarketRoleOwn,
  _MarketRoleOwn.MarketRoleDescription AS MarketRoleOwnDescription,
  market_role_third AS MarketRoleThrid,
  _MarketRoleThird.MarketRoleDescription AS MarketRoleThridDescription,
  deploy_target AS DeploymentTarget,
  _DeploymentTarget.Description AS DeploymentTargetDescription,
  config_layer AS ConfigurationLayer,
  _ConfigurationLayer.Description AS ConfigurationLayerDescription,
  market_role AS MarketRole,
  _MarketRole.MarketRoleDescription AS MarketRoleDescription,
  bo_type_uuid AS BusinessObjectTypeKey,
  bo_type AS BusinessObjectType,
  _BusObjTypeVH.BusinessObjectTypeDescription AS BusinessObjectTypeDescription
FROM /APE/I_BusMsg_TP
LEFT OUTER JOIN /APE/C_BusinessMessageID_VH AS _BusinessMessageIDKeyVH ON _BusinessMessageIDKeyVH.BusinessMessageIDKey = BusinessMessageIDKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessCluster_VH AS _ProcessClusterKeyVH ON _ProcessClusterKeyVH.ProcessClusterKey = ProcessClusterKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_Version_VH AS _VersionKeyVH ON _VersionKeyVH.VersionKey = VersionKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_BUSOBJTYPE_VH AS _BusObjTypeVH ON _BusObjTypeVH.BusinessObjectTypeKey = BusinessObjectTypeKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_BMIDLinkBOType AS _LinkedBO ON _LinkedBO.BusinessMessageIDKey = BusinessMessageIDKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_MarketRole_VH AS _MarketRoleOwn ON _MarketRoleOwn.MarketRole = MarketRoleOwn  -- association [0..1]
LEFT OUTER JOIN /APE/C_MarketRole_VH AS _MarketRoleThird ON _MarketRoleThird.MarketRole = MarketRoleThrid  -- 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]
LEFT OUTER JOIN /APE/C_BusMsgCust AS _BusMsgCust ON _BusMsgCust.ape_parent_key = BusinessMessageKey  -- association [0..1]
;