/APE/C_BOMAPRULE_UI

DDL: /APE/C_BOMAPRULE_UI Type: view CONSUMPTION

Business Object Mapping Rule

/APE/C_BOMAPRULE_UI is a Consumption CDS View that provides data about "Business Object Mapping Rule" in SAP S/4HANA. It reads from 1 data source (/APE/I_BOMAPRULE_TP) and exposes 23 fields with key fields BOMapRuleKey, BOMapHdrKey. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_BOMAPRULE_TP /APE/I_BOMAPRULE_TP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] /APE/C_BOMAPHDR_UI _MAPHDR $projection.BOMapHdrKey = _MAPHDR.BOMapHdrKey
[0..1] /APE/C_BODMHdrT_VH _BODataModel1VH _BODataModel1VH.BusinessObjectDataModelKey = $projection.BusinessObjectDataModelKey
[0..1] /APE/C_BODMHdrT_VH _BODataModel2VH _BODataModel2VH.BusinessObjectDataModelKey = $projection.BODataModel2Key

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_VBOMAPRUL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Object Mapping Rule view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY BOMapRuleKey config_key Char
KEY BOMapHdrKey ape_parent_key
SequenceNumber map_no
BusinessObject1ParentPath bodm1_parent_path
BusinessObject1Path bodm1_path
BusinessObject1Field bodm1_field
BusinessObjectDataModelKey bodm1
BODataModel1DDICType _BODataModel1VH bo_ddic_type
BusinessObject2ParentPath bodm2_parent_path
BusinessObject2Path bodm2_path
BusinessObject2Field bodm2_field
BODataModel2Key bodm2
BODataModel2DDICType _BODataModel2VH bo_ddic_type
SourceValue source_value Explanation
QualifierPath qualifier_path
QualifierField qualifier_field
QualifierCode qualifier_code
ConversionClass convert_class
ConversionRule brf_func
isMandatory mandatory Yes/No
ParserClass _MAPHDR ParserClass
ParserMapMethod map_method
_MAPHDR _MAPHDR

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_BOMAPRULE_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_BOMAPRULE_UI AS
SELECT
  config_key AS BOMapRuleKey,
  ape_parent_key AS BOMapHdrKey,
  map_no AS SequenceNumber,
  bodm1_parent_path AS BusinessObject1ParentPath,
  bodm1_path AS BusinessObject1Path,
  bodm1_field AS BusinessObject1Field,
  bodm1 AS BusinessObjectDataModelKey,
  _BODataModel1VH.bo_ddic_type AS BODataModel1DDICType,
  bodm2_parent_path AS BusinessObject2ParentPath,
  bodm2_path AS BusinessObject2Path,
  bodm2_field AS BusinessObject2Field,
  bodm2 AS BODataModel2Key,
  _BODataModel2VH.bo_ddic_type AS BODataModel2DDICType,
  source_value AS SourceValue,
  qualifier_path AS QualifierPath,
  qualifier_field AS QualifierField,
  qualifier_code AS QualifierCode,
  convert_class AS ConversionClass,
  brf_func AS ConversionRule,
  mandatory AS isMandatory,
  _MAPHDR.ParserClass AS ParserClass,
  map_method AS ParserMapMethod
FROM /APE/I_BOMAPRULE_TP
LEFT OUTER JOIN /APE/C_BOMAPHDR_UI AS _MAPHDR ON BOMapHdrKey = _MAPHDR.BOMapHdrKey  -- association [1..1]
LEFT OUTER JOIN /APE/C_BODMHdrT_VH AS _BODataModel1VH ON _BODataModel1VH.BusinessObjectDataModelKey = BusinessObjectDataModelKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_BODMHdrT_VH AS _BODataModel2VH ON _BODataModel2VH.BusinessObjectDataModelKey = BODataModel2Key  -- association [0..1]
;