/APE/C_BOMAPHDRBUFFERED

DDL: /APE/C_BOMAPHDRBUFFERED Type: view BASIC
7 Fields 5 Data Sources 12 Associations

BO Mapping Header

/APE/C_BOMAPHDRBUFFERED is a Basic CDS View that provides data about "BO Mapping Header" in SAP S/4HANA. It reads from 5 data sources (/ape/busmsg, /ape/busmsg, /ape/bodmhdr, /ape/bodmhdr, /ape/bomaphdr) and exposes 7 fields with key field config_key. It has 12 associations to related views.

Data Sources (5)

SourceAliasJoin Type
/ape/busmsg _BMID_DEST left_outer
/ape/busmsg _BMID_SRC left_outer
/ape/bodmhdr _BO_DEST inner
/ape/bodmhdr _BO_SRC inner
/ape/bomaphdr _map_hdr from

Associations (12)

CardinalityTargetAliasCondition
[1..1] /ape/botyp _bo_src_type _bo_src_type.config_key = _BO_SRC.bo_type_uuid
[1..1] /ape/procclus _bo_src_clus _bo_src_clus.config_key = _BO_SRC.proc_cluster_uuid
[1..1] /ape/version _bo_src_version _bo_src_version.config_key = _BO_SRC.version_uuid
[1..1] /ape/botyp _bo_dest_type _bo_dest_type.config_key = _BO_DEST.bo_type_uuid
[1..1] /ape/procclus _bo_dest_clus _bo_dest_clus.config_key = _BO_DEST.proc_cluster_uuid
[1..1] /ape/version _bo_dest_version _bo_dest_version.config_key = _BO_DEST.version_uuid
[0..1] /ape/busmsgid _BMID_SRC_ID _BMID_SRC.bus_msg_id_uuid = _BMID_SRC_ID.config_key
[0..1] /ape/procclus _BMID_SRC_CLUS _BMID_SRC_CLUS.config_key = _BMID_SRC.proc_cluster_uuid
[0..1] /ape/version _BMID_SRC_VERSION _BMID_SRC_VERSION.config_key = _BMID_SRC.version_uuid
[0..1] /ape/busmsgid _BMID_DEST_ID _BMID_DEST.bus_msg_id_uuid = _BMID_DEST_ID.config_key
[0..1] /ape/procclus _BMID_DEST_CLUS _BMID_DEST_CLUS.config_key = _BMID_DEST.proc_cluster_uuid
[0..1] /ape/version _BMID_DEST_VERSION _BMID_DEST_VERSION.config_key = _BMID_DEST.version_uuid

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_VBOMAPHDB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label BO Mapping Header view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY config_key /ape/bomaphdr config_key Char
bmid_source _BMID_SRC_ID bus_msg_id
bmid_target _BMID_DEST_ID bus_msg_id
parser_class parser_class
proc_cluster _bo_src_clus proc_cluster
market_role /ape/bomaphdr market_role
config_layer /ape/bomaphdr config_layer

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_BOMAPHDRBUFFERED.
-- 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_BOMAPHDRBUFFERED AS
SELECT
  _map_hdr.config_key AS config_key,
  _BMID_SRC_ID.bus_msg_id AS bmid_source,
  _BMID_DEST_ID.bus_msg_id AS bmid_target,
  parser_class,
  _bo_src_clus.proc_cluster AS proc_cluster,
  _map_hdr.market_role AS market_role,
  _map_hdr.config_layer AS config_layer
FROM /ape/bomaphdr AS _map_hdr
INNER JOIN /ape/bodmhdr AS _BO_SRC ON /* join condition not captured in parsed metadata */
INNER JOIN /ape/bodmhdr AS _BO_DEST ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/busmsg AS _BMID_SRC ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/busmsg AS _BMID_DEST ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/botyp AS _bo_src_type ON _bo_src_type.config_key = _BO_SRC.bo_type_uuid  -- association [1..1]
LEFT OUTER JOIN /ape/procclus AS _bo_src_clus ON _bo_src_clus.config_key = _BO_SRC.proc_cluster_uuid  -- association [1..1]
LEFT OUTER JOIN /ape/version AS _bo_src_version ON _bo_src_version.config_key = _BO_SRC.version_uuid  -- association [1..1]
LEFT OUTER JOIN /ape/botyp AS _bo_dest_type ON _bo_dest_type.config_key = _BO_DEST.bo_type_uuid  -- association [1..1]
LEFT OUTER JOIN /ape/procclus AS _bo_dest_clus ON _bo_dest_clus.config_key = _BO_DEST.proc_cluster_uuid  -- association [1..1]
LEFT OUTER JOIN /ape/version AS _bo_dest_version ON _bo_dest_version.config_key = _BO_DEST.version_uuid  -- association [1..1]
LEFT OUTER JOIN /ape/busmsgid AS _BMID_SRC_ID ON _BMID_SRC.bus_msg_id_uuid = _BMID_SRC_ID.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procclus AS _BMID_SRC_CLUS ON _BMID_SRC_CLUS.config_key = _BMID_SRC.proc_cluster_uuid  -- association [0..1]
LEFT OUTER JOIN /ape/version AS _BMID_SRC_VERSION ON _BMID_SRC_VERSION.config_key = _BMID_SRC.version_uuid  -- association [0..1]
LEFT OUTER JOIN /ape/busmsgid AS _BMID_DEST_ID ON _BMID_DEST.bus_msg_id_uuid = _BMID_DEST_ID.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procclus AS _BMID_DEST_CLUS ON _BMID_DEST_CLUS.config_key = _BMID_DEST.proc_cluster_uuid  -- association [0..1]
LEFT OUTER JOIN /ape/version AS _BMID_DEST_VERSION ON _BMID_DEST_VERSION.config_key = _BMID_DEST.version_uuid  -- association [0..1]
;

Learn More