I_EngineeringRedlineBOMItem

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_EngineeringRedlineBOMItem.
-- 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 I_EngineeringRedlineBOMItem AS
SELECT
  BillOfMaterialCategory,
  cast( BillOfMaterial as bom_id preserving type ) AS BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  HeaderChangeDocument,
  Material,
  Plant,
  BillOfMaterialItemNodeNumber,
  BillOfMaterialItemUUID,
  BillOfMaterialItemCategory,
  BillOfMaterialItemCategoryDesc,
  BillOfMaterialComponent,
  ComponentDescription,
  BillOfMaterialItemQuantity,
  BillOfMaterialItemUnit,
  cast( BillOfMaterialItemNumber as bom_item_number preserving type ) AS BillOfMaterialItemNumber,
  ValidityStartDate,
  ValidityEndDate,
  EngineeringChangeDocument,
  IsSubItem,
  BillOfMaterialVariantUsage,
  DocNumber,
  DocumentVersion,
  DocumentType,
  DocumentPart,
  ClassNumber,
  ClassType,
  BOMItemDescription,
  _BOMHeader.HeaderValidityStartDate AS HeaderValidityStartDate,
  _BOMHeader.HeaderValidityEndDate AS HeaderValidityEndDate
FROM I_BOMItemHdrChangeState AS _BOMItem
LEFT OUTER JOIN I_MultiLevelBOM AS _MultiLevelBOM ON _BOMItem.BillOfMaterialComponent = _MultiLevelBOM.Material AND Plant = _MultiLevelBOM.Plant  -- association [0..1]
LEFT OUTER JOIN I_AssemblySalesOrderBOM AS _AssemblySalesOrderBOM ON _BOMItem.BillOfMaterialComponent = _AssemblySalesOrderBOM.Material AND Plant = _AssemblySalesOrderBOM.Plant  -- association [0..1]
LEFT OUTER JOIN I_BOMVariantUsage AS _BOMUsages ON BillOfMaterialVariantUsage = _BOMUsages.BillOfMaterialVariantUsage  -- association [0..1]
LEFT OUTER JOIN t418 AS _BOMConfig ON BillOfMaterialItemCategory = _BOMConfig.postp  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterial AS _BOMHeader ON _BOMItem.BillOfMaterialCategory = _BOMHeader.BillOfMaterialCategory AND _BOMItem.BillOfMaterial = _BOMHeader.BillOfMaterial AND _BOMItem.BillOfMaterialVariant = _BOMHeader.BillOfMaterialVariant AND _BOMItem.BillOfMaterialVersion = _BOMHeader.BillOfMaterialVersion AND _BOMItem.HeaderChangeDocument = _BOMHeader.EngineeringChangeDocument AND _BOMItem.BillOfMaterialHeaderUUID = _BOMHeader.BillOfMaterialHeaderUUID  -- association [0..1]
;