I_ChangeRecordMfgBOM

DDL: I_CHANGERECORDMFGBOM SQL: ICHGRECDMBOM Type: view COMPOSITE
13 Fields 2 Data Sources 1 Associations

Change Record Manufacturing Bill Of Material

I_ChangeRecordMfgBOM is a Composite CDS View that provides data about "Change Record Manufacturing Bill Of Material" in SAP S/4HANA. It reads from 2 data sources (I_ChangeRecordMaterialBOM, I_MfgBOMUsage) and exposes 13 fields with key fields Material, Plant, BillOfMaterialVariantUsage, BillOfMaterialVariant, BillOfMaterialVersion. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_ChangeRecordMaterialBOM MaterialBOM from
I_MfgBOMUsage MfgBOMUsage inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialBOM _MaterialBOMDetails $projection.Material = _MaterialBOMDetails.Material and $projection.Plant = _MaterialBOMDetails.Plant and $projection.BillOfMaterialVariantUsage = _MaterialBOMDetails.BillOfMaterialVariantUsage and $projection.BillOfMaterialVariant = _MaterialBOMDetails.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _MaterialBOMDetails.BillOfMaterialVersion and $projection.HeaderValidityStartDate = _MaterialBOMDetails.HeaderValidityStartDate

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECDMBOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Change Record Manufacturing Bill Of Material view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material I_ChangeRecordMaterialBOM Material Vehicle Model
KEY Plant I_ChangeRecordMaterialBOM Plant Valuation Area
KEY BillOfMaterialVariantUsage I_ChangeRecordMaterialBOM BillOfMaterialVariantUsage Usage
KEY BillOfMaterialVariant I_ChangeRecordMaterialBOM BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion I_ChangeRecordMaterialBOM BillOfMaterialVersion BOM Version
BillOfMaterialHeaderUUID _MaterialBOMDetails BillOfMaterialHeaderUUID Guid
BillOfMaterialUUID _MaterialBOMDetails BillOfMaterialUUID Character Field of Length 12
IsVersionBillOfMaterial _MaterialBOMDetails IsVersionBillOfMaterial Versioning Relevant
BillOfMaterial _MaterialBOMDetails BillOfMaterial BOM
BillOfMaterialCategory _MaterialBOMDetails BillOfMaterialCategory BOM category
BOMVersionStatus _MaterialBOMDetails BOMVersionStatus BOM Version Status
HeaderValidityStartDate I_ChangeRecordMaterialBOM HeaderValidityStartDate Valid From
BillOfMaterialStatus _MaterialBOMDetails BillOfMaterialStatus BOM Status

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 I_ChangeRecordMfgBOM.
-- 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: ICHGRECDMBOM

CREATE VIEW I_ChangeRecordMfgBOM AS
SELECT
  MaterialBOM.Material AS Material,
  MaterialBOM.Plant AS Plant,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  _MaterialBOMDetails.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  _MaterialBOMDetails.BillOfMaterialUUID AS BillOfMaterialUUID,
  _MaterialBOMDetails.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  _MaterialBOMDetails.BillOfMaterial AS BillOfMaterial,
  _MaterialBOMDetails.BillOfMaterialCategory AS BillOfMaterialCategory,
  _MaterialBOMDetails.BOMVersionStatus AS BOMVersionStatus,
  MaterialBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  _MaterialBOMDetails.BillOfMaterialStatus AS BillOfMaterialStatus
FROM I_ChangeRecordMaterialBOM AS MaterialBOM
INNER JOIN I_MfgBOMUsage AS MfgBOMUsage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialBOM AS _MaterialBOMDetails ON Material = _MaterialBOMDetails.Material AND Plant = _MaterialBOMDetails.Plant AND BillOfMaterialVariantUsage = _MaterialBOMDetails.BillOfMaterialVariantUsage AND BillOfMaterialVariant = _MaterialBOMDetails.BillOfMaterialVariant AND BillOfMaterialVersion = _MaterialBOMDetails.BillOfMaterialVersion AND HeaderValidityStartDate = _MaterialBOMDetails.HeaderValidityStartDate  -- association [0..1]
;

Learn More