I_MasterRecipeComponentAlloc

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_MasterRecipeComponentAlloc.
-- 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: IMSTRRCPCOMPALC

CREATE VIEW I_MasterRecipeComponentAlloc AS
SELECT
  _CompAlloc.BillOfOperationsType AS BillOfOperationsType,
  _CompAlloc.BillOfOperationsGroup AS BillOfOperationsGroup,
  _CompAlloc.BillOfOperationsVariant AS BillOfOperationsVariant,
  BOOOperationInternalID,
  BOOOpBOMItemInternalID,
  BOOOpBOMItemIntVersCounter,
  _BOMItem.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  case when _CompAlloc.ValidityStartDate > _BOMItem.ValidityStartDate then _CompAlloc.ValidityStartDate else _BOMItem.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  case when _CompAlloc.ValidityEndDate < _BOMItem.ValidityEndDate then _CompAlloc.ValidityEndDate else case when _BOMItem.ValidityEndDate > _BOMItem.ValidityStartDate then dats_add_days( _BOMItem.ValidityEndDate, -1, 'UNCHANGED' ) else _BOMItem.ValidityEndDate end end as ValidityEndDate AS ValidityEndDateendendasValidityEndDate,
  _CompAlloc.CreationDate AS CreationDate,
  _CompAlloc.CreatedByUser AS CreatedByUser,
  _CompAlloc.LastChangeDate AS LastChangeDate,
  _CompAlloc.LastChangedByUser AS LastChangedByUser,
  _CompAlloc.IsDeleted AS IsDeleted,
  _CompAlloc.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  _CompAlloc.ChangeNumber AS ChangeNumber,
  _MatlAssgmt.Material AS Material,
  _MatlAssgmt.Plant AS Plant,
  _ProdnVers.ProductionVersion AS ProductionVersion,
  _CompAlloc.BillOfMaterialCategory AS BillOfMaterialCategory,
  _CompAlloc.BillOfMaterial AS BillOfMaterial,
  _CompAlloc.BillOfMaterialVariant AS BillOfMaterialVariant,
  _BOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _CompAlloc.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  _BOMItem.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  _BOMItem.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  _BOMItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  _BOMItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  _BOMItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  MatlCompIsMarkedForBackflush
FROM I_MfgBOOOpBOMItemChangeState AS _CompAlloc
INNER JOIN I_MaterialBOM AS _BOM ON /* join condition not captured in parsed metadata */
INNER JOIN I_MasterRecipeMaterialAssgmt AS _MatlAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BOMItem ON BillOfMaterialCategory = _BOMItem.BillOfMaterialCategory AND BillOfMaterial = _BOMItem.BillOfMaterial AND BillOfMaterialItemNodeNumber = _BOMItem.InheritedNodeNumberForBOMItem AND _CompAlloc.ValidityEndDate >= _BOMItem.ValidityStartDate AND _CompAlloc.ValidityStartDate <= _BOMItem.ValidityEndDate AND _BOMItem.ValidityEndDate >= $session.system_date AND _BOMItem.IsDeleted <> 'X'  -- association [1..*]
LEFT OUTER JOIN I_ProductionVersion AS _ProdnVers ON Material = _ProdnVers.Material AND Plant = _ProdnVers.Plant AND BillOfOperationsType = _ProdnVers.BillOfOperationsType AND BillOfOperationsGroup = _ProdnVers.BillOfOperationsGroup AND BillOfOperationsVariant = _ProdnVers.BillOfOperationsVariant AND BillOfMaterialVariant = _ProdnVers.BillOfMaterialVariant AND BillOfMaterialVariantUsage = _ProdnVers.BillOfMaterialVariantUsage AND _CompAlloc.ValidityEndDate >= _ProdnVers.ValidityStartDate AND _CompAlloc.ValidityStartDate <= _ProdnVers.ValidityEndDate AND _ProdnVers.ValidityEndDate >= $session.system_date  -- association [0..*]
;