C_ChangeRecordOrderBOMVH

DDL: C_CHANGERECORDORDERBOMVH SQL: CMFGOBMVH Type: view CONSUMPTION
10 Fields 1 Data Sources 3 Associations

Sales Order Bill of Material

C_ChangeRecordOrderBOMVH is a Consumption CDS View that provides data about "Sales Order Bill of Material" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordOrderBOM) and exposes 10 fields with key field BillOfMaterialHeaderUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordOrderBOM ChangeRecordOrdBOMVH from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..*] I_BillOfMaterialUsageText _BillOfMaterialUsageText $projection.BillOfMaterialVariantUsage = _BillOfMaterialUsageText.BillOfMaterialVariantUsage

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CMFGOBMVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Sales Order Bill of Material view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialHeaderUUID I_ChangeRecordOrderBOM BillOfMaterialHeaderUUID Guid
Material I_ChangeRecordOrderBOM Material Vehicle Model
SalesOrder I_ChangeRecordOrderBOM SalesOrder SD Document
SalesOrderItem I_ChangeRecordOrderBOM SalesOrderItem Sales Order Item
Plant I_ChangeRecordOrderBOM Plant Valuation Area
BillOfMaterialVariantUsage I_ChangeRecordOrderBOM BillOfMaterialVariantUsage Usage
BillOfMaterialVariant I_ChangeRecordOrderBOM BillOfMaterialVariant AlternativeBOM
PlantName _Plant PlantName Plant Name
_BillOfMaterialUsageText _BillOfMaterialUsageText
_MaterialText _MaterialText

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 C_ChangeRecordOrderBOMVH.
-- 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.
-- SQL view name: CMFGOBMVH

CREATE VIEW C_ChangeRecordOrderBOMVH AS
SELECT
  ChangeRecordOrdBOMVH.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  ChangeRecordOrdBOMVH.Material AS Material,
  ChangeRecordOrdBOMVH.SalesOrder AS SalesOrder,
  ChangeRecordOrdBOMVH.SalesOrderItem AS SalesOrderItem,
  ChangeRecordOrdBOMVH.Plant AS Plant,
  ChangeRecordOrdBOMVH.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ChangeRecordOrdBOMVH.BillOfMaterialVariant AS BillOfMaterialVariant,
  _Plant.PlantName AS PlantName
FROM I_ChangeRecordOrderBOM AS ChangeRecordOrdBOMVH
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _BillOfMaterialUsageText ON BillOfMaterialVariantUsage = _BillOfMaterialUsageText.BillOfMaterialVariantUsage  -- association [0..*]
;

Learn More