C_ChgImpactETOVersBOMItem

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_ChgImpactETOVersBOMItem.
-- 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: CCHGIMPCTEOBITM

CREATE VIEW C_ChgImpactETOVersBOMItem AS
SELECT
  ETOVersBOMItem.BillOfMaterialVariant AS BillOfMaterialVariant,
  ETOVersBOMItem.BillOfMaterial AS BillOfMaterial,
  ETOVersBOMItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  ETOVersBOMItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  ETOVersBOMItem.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  ETOVersBOMItem.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  _BOMHeader.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ETOVersBOMItem.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  ETOVersBOMItem.BOMItemDescription AS BOMItemDescription,
  ETOVersBOMItem.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  ETOVersBOMItem.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  ETOVersBOMItem.BOMItemIsSalesRelevant AS BOMItemIsSalesRelevant,
  ETOVersBOMItem.BOMItemIsSparePart AS BOMItemIsSparePart,
  ETOVersBOMItem.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  ETOVersBOMItem.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  ETOVersBOMItem.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  ETOVersBOMItem.BOMItemSorter AS BOMItemSorter,
  ETOVersBOMItem.BOMItemText2 AS BOMItemText2,
  ETOVersBOMItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  ETOVersBOMItem.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  ETOVersBOMItem.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  ETOVersBOMItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  ETOVersBOMItem.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  ETOVersBOMItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  ETOVersBOMItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  _BOMHeader.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  ETOVersBOMItem.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  ETOVersBOMItem.EngineeringChangeDocument AS EngineeringChangeDocument,
  ETOVersBOMItem.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  ETOVersBOMItem.ValidityEndDate AS ValidityEndDate,
  ETOVersBOMItem.ValidityStartDate AS ValidityStartDate,
  cast( ' ' as abap.char( 255 ) ) AS NetChangeAnalysisPath,
  cast(' ' as mpe_mec_cima_isdefinite) AS IsDefinite,
  cast(' ' as mpe_mec_cima_ischanged ) AS IsChanged,
  _BomItemCategoryText[1:Language = $session.system_language].BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  _CompText[1:Language = $session.system_language].MaterialName AS MaterialName,
  cast('00000000' as datuv) AS ComprnStrtDte,
  cast('00000000' as datuv) AS ComprnEndDte,
  cast('' as /plmb/cr_id ) AS ChangeRecord,
  cast(hextobin('00000000000000000000000000000000') as dmu_guid16) AS BOMItemInstanceUUID,
  ETOVersBOMItem.Plant AS Plant,
  OrigSalesOrderBOM,
  OrigSalesOrderBOMItmCategory,
  OrigSalesOrderBOMItmNodeNumber,
  OrigSalesOrderBOMItmNumber
FROM I_ChgImpactETOVersBOMItem AS ETOVersBOMItem
LEFT OUTER JOIN I_BillOfMaterial AS _BOMHeader ON BillOfMaterial = _BOMHeader.BillOfMaterial AND BillOfMaterialCategory = _BOMHeader.BillOfMaterialCategory AND BillOfMaterialVariant = _BOMHeader.BillOfMaterialVariant AND BillOfMaterialVersion = _BOMHeader.BillOfMaterialVersion  -- association [0..1]
LEFT OUTER JOIN I_BomItemCategoryText AS _BomItemCategoryText ON BillOfMaterialItemCategory = _BomItemCategoryText.BillOfMaterialItemCategory  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _CompText ON BillOfMaterialComponent = _CompText.Material  -- association [0..*]
;