C_MngUnassgdEBOMSuggestedList

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_MngUnassgdEBOMSuggestedList.
-- 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: CMNGUNASSEBMSUGG

CREATE VIEW C_MngUnassgdEBOMSuggestedList AS
SELECT
  cast( bintohex(EngBOMWithAllMfgPlants.BillOfMaterialHeaderUUID ) as char32 preserving type ) AS BillOfMaterialHeaderUUID,
  EngBOMWithAllMfgPlants.ProductionPlant AS ProductionPlant,
  PlngScpBom.DocumentId AS DocumentId,
  PlngScpBom.PlanningScopeAlternative AS PlanningScopeAlternative,
  EngBOMWithAllMfgPlants.BillOfMaterial AS BillOfMaterial,
  EngBOMWithAllMfgPlants.BillOfMaterialUUID AS BillOfMaterialUUID,
  EngBOMWithAllMfgPlants.BillOfMaterialVariant AS BillOfMaterialVariant,
  EngBOMWithAllMfgPlants.BillOfMaterialCategory AS BillOfMaterialCategory,
  EngBOMWithAllMfgPlants.Material AS Material,
  EngBOMWithAllMfgPlants.Plant AS Plant,
  EngBOMWithAllMfgPlants.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  EngBOMWithAllMfgPlants.BillOfMaterialVersion AS BillOfMaterialVersion,
  EngBOMWithAllMfgPlants.LastChangeDate AS LastChangeDate,
  _PlantText.PlantName AS PlantName,
  _ProdPlantText.PlantName AS ProductionPlantName,
  EngBOMWithAllMfgPlants.HeaderValidityStartDate AS HeaderValidityStartDate,
  EngBOMWithAllMfgPlants.CreatedByUser AS CreatedByUser,
  EngBOMWithAllMfgPlants.HeaderValidityEndDate AS HeaderValidityEndDate,
  EngBOMWithAllMfgPlants.EBOMType AS EBOMType,
  EngBOMWithAllMfgPlants.EBOMStatus AS EBOMStatus,
  EngBOMWithAllMfgPlants.LastChgStForBOMItm AS LastChgStForBOMItm,
  EngBOMWithAllMfgPlants.IsVersionBillOfMaterial AS IsVersionBillOfMaterial
FROM I_MngUnassgdEngBOM AS EngBOMWithAllMfgPlants
INNER JOIN I_PlanningScopeBillOfMaterial AS PlngScpBom ON /* join condition not captured in parsed metadata */
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_Plant AS _ProdPlantText ON ProductionPlant = _ProdPlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _UsageText ON BillOfMaterialVariantUsage = _UsageText.BillOfMaterialVariantUsage AND _UsageText.Language = $session.system_language  -- association [0..1]
;