C_ChgImpactBOMItem

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_ChgImpactBOMItem.
-- 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: CCHGIMPACTBOMITM

CREATE VIEW C_ChgImpactBOMItem AS
SELECT
  BOMItem.BillOfMaterialVariant AS BillOfMaterialVariant,
  BOMItem.BillOfMaterial AS BillOfMaterial,
  BOMItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  BOMItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  BOMItem.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  BOMItem.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  _BOMHeader.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOMItem.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  BOMItem.BOMItemDescription AS BOMItemDescription,
  BOMItem.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  BOMItem.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  BOMItem.BOMItemIsSalesRelevant AS BOMItemIsSalesRelevant,
  BOMItem.BOMItemIsSparePart AS BOMItemIsSparePart,
  BOMItem.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  BOMItem.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  BOMItem.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  BOMItem.BOMItemSorter AS BOMItemSorter,
  BOMItem.BOMItemText2 AS BOMItemText2,
  BOMItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  BOMItem.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  BOMItem.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  BOMItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  BOMItem.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  BOMItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  BOMItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  _BOMHeader.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  BOMItem.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  BOMItem.EngineeringChangeDocument AS EngineeringChangeDocument,
  BOMItem.FixedQuantity AS FixedQuantity,
  BOMItem.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  BOMItem.ValidityEndDate AS ValidityEndDate,
  BOMItem.ValidityStartDate AS ValidityStartDate,
  BOMItem.IsMaterialUnitized AS IsMaterialUnitized,
  BOMItem.EffectivityType AS EffectivityType,
  BOMItem.ComplexAssemblyType AS ComplexAssemblyType,
  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('' as text255 ) AS EffectivityParameterDesc,
  cast('00000000' as datuv) AS ComprnStrtDte,
  cast('00000000' as datuv) AS ComprnEndDte,
  cast('' as /plmb/cr_id ) AS ChangeRecord,
  cast('' as mpe_mrs_designator ) AS ReferenceDesignator,
  cast('' as mpe_mrs_designator_name ) AS MfgRefStrucItmRefDsgntrName,
  cast('' as abap.char( 1 )) AS MfgRefStrucAssgmtIsAtBOMInstce,
  cast(hextobin('00000000000000000000000000000000') as dmu_guid16) AS BOMItemInstanceUUID,
  BOMItem.Plant AS Plant
FROM I_ChgImpactBOMItem AS BOMItem
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..*]
LEFT OUTER JOIN E_BillOfMaterialItemTP AS _BillOfMaterialItemExtension ON BillOfMaterial = _BillOfMaterialItemExtension.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory AND BillOfMaterialItemNodeNumber = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount  -- association [1..1]
;