C_ChgImpactMBOMDets

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_ChgImpactMBOMDets.
-- 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: CCHGIMPCTMBOM

CREATE VIEW C_ChgImpactMBOMDets AS
SELECT
  MfgBOM.BillOfMaterial AS BillOfMaterial,
  MfgBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MfgBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MfgBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MfgBOM.Plant AS Plant,
  MfgBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  MfgBOM.BOMHeaderText AS BOMHeaderText,
  Material,
  _MaterialText[1:Language = $session.system_language].MaterialName AS MaterialName,
  MfgBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _BOMUsageText[1:Language = $session.system_language].BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  MfgBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  MfgBOM.BOMVersionStatus AS BOMVersionStatus,
  MfgBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  cast('0000' as werks_d) AS ProductionPlant,
  cast('00000000'as abap.dats) AS ValidityStartDate,
  cast('00000000'as abap.dats) AS ValidityEndDate,
  _PlantText.PlantName AS PlantName,
  EffectivityType,
  IsMaterialUnitized,
  _VersionStatus.BOMVersionStatusDescription AS BOMVersionStatusDescription
FROM I_ChgImpactMBOMReltdObj AS MfgBOM
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _PlantText ON Plant = _PlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _BOMUsageText ON BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN C_ChgImpactBOMItem AS _MfgBOMItem ON BillOfMaterial = _MfgBOMItem.BillOfMaterial AND BillOfMaterialCategory = _MfgBOMItem.BillOfMaterialCategory AND BillOfMaterialVariant = _MfgBOMItem.BillOfMaterialVariant AND BillOfMaterialVersion = _MfgBOMItem.BillOfMaterialVersion  -- association [0..*]
LEFT OUTER JOIN I_VersionStatus AS _VersionStatus ON BOMVersionStatus = _VersionStatus.BOMVersionStatus AND _VersionStatus.Language = $session.system_language  -- association [0..1]
;