C_MngUnassgdEngBOMWorklist

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_MngUnassgdEngBOMWorklist.
-- 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: CUNASSEBOMWKLST

CREATE VIEW C_MngUnassgdEngBOMWorklist AS
SELECT
  UnassgdEngBOM.BillOfMaterial AS BillOfMaterial,
  UnassgdEngBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  UnassgdEngBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  UnassgdEngBOM.Material AS Material,
  UnassgdEngBOM.Plant AS Plant,
  UnassgdEngBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  UnassgdEngBOM.ProductionPlant AS ProductionPlant,
  UnassgdEngBOM.ChangeRecord AS ChangeRecord,
  UnassgdEngBOM.ChangeRecordUUID AS ChangeRecordUUID,
  UnassgdEngBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  UnassgdEngBOM.ChgRecdAssgd AS ChgRecdAssgd,
  UnassgdEngBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  UnassgdEngBOM.LastChangeDate AS LastChangeDate,
  _PlantVH.PlantName AS PlantName,
  _ProductionPlantVH.PlantName AS ProductionPlantName,
  UnassgdEngBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  UnassgdEngBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  cast( bintohex(UnassgdEngBOM.BillOfMaterialHeaderUUID ) as char32 preserving type ) AS BillOfMaterialHeaderUUID,
  UnassgdEngBOM.EBOMType AS EBOMType,
  UnassgdEngBOM.EBOMStatus AS EBOMStatus,
  UnassgdEngBOM.CreatedByUser AS CreatedByUser,
  _UserInfo.UserDescription AS UserDescription,
  UnassgdEngBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  UnassgdEngBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  UnassgdEngBOM.IsMaterialUnitized AS IsMaterialUnitized,
  UnassgdEngBOM.RecordCreationDate AS RecordCreationDate,
  UnassgdEngBOM.ChgRecdEngEffectiveDate AS ChgRecdEngEffectiveDate,
  UnassgdEngBOM.LastChgStForBOMItm AS LastChgStForBOMItm,
  UnassgdEngBOM.LatestEngEffctvDte AS LatestEngEffctvDte,
  UnassgdEngBOM.IsConfiguredMaterial AS IsConfiguredMaterial
FROM I_MngUnassgdEngBOM AS UnassgdEngBOM
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _UsageText ON BillOfMaterialVariantUsage = _UsageText.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN C_MngUnassgdEngBOMMatlVH AS _MaterialVH ON Material = _MaterialVH.Material  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _PlantVH ON Plant = _PlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _ProductionPlantVH ON ProductionPlant = _ProductionPlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_MngUnassgdEBOMUsagesVH AS _EngBOMUsageVH ON BillOfMaterialVariantUsage = _EngBOMUsageVH.BillOfMaterialVariantUsage  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserInfo ON CreatedByUser = _UserInfo.UserID  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialStatus AS _BOMStatus ON BillOfMaterialStatus = _BOMStatus.BillOfMaterialStatus  -- association [0..1]
LEFT OUTER JOIN I_MngUnassgdEBOMHandoverSts AS _EBOMHandOverSts ON EBOMStatus = _EBOMHandOverSts.EBOMStatus  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialStatusText AS _BOMStatusTxt ON BillOfMaterialStatus = _BOMStatusTxt.BillOfMaterialStatus  -- association [0..*]
LEFT OUTER JOIN I_MngUnassgdEBOMHandoverStsTxt AS _EBOMHandOverStsTxt ON EBOMStatus = _EBOMHandOverStsTxt.EBOMStatus  -- association [0..*]
;