/APE/C_BusinessMessage

DDL: /APE/C_BUSINESSMESSAGE Type: view CONSUMPTION

Business Message Configuration

/APE/C_BusinessMessage is a Consumption CDS View that provides data about "Business Message Configuration" in SAP S/4HANA. It reads from 1 data source (/APE/I_BusMsg_TP) and exposes 11 fields with key field config_key. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_BusMsg_TP /APE/I_BusMsg_TP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] /APE/C_BusMsgID _BusMsgID $projection.bus_msg_id_uuid = _BusMsgID.config_key

Annotations (8)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY config_key config_key Char
version_uuid version_uuid
proc_cluster proc_cluster
bus_msg_id bus_msg_id
version version XML Vers.
valid_from _Version valid_from Validity Start Time
bo_type_uuid _BusMsgID bo_type_uuid
bo_type _BusMsgID bo_type SOT Name
market_role market_role
config_layer config_layer
_Version _Version

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_BusinessMessage.
-- 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_BusinessMessage AS
SELECT
  config_key,
  version_uuid,
  proc_cluster,
  bus_msg_id,
  version,
  _Version.valid_from AS valid_from,
  _BusMsgID.bo_type_uuid AS bo_type_uuid,
  _BusMsgID.bo_type AS bo_type,
  market_role,
  config_layer
FROM /APE/I_BusMsg_TP
LEFT OUTER JOIN /APE/C_BusMsgID AS _BusMsgID ON bus_msg_id_uuid = _BusMsgID.config_key  -- association [1..1]
;