I_MngUnassgdEngBOM

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 I_MngUnassgdEngBOM.
-- 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: IMNGUNASSEBOM

CREATE VIEW I_MngUnassgdEngBOM AS
SELECT
  UnassgdVersEBOM.BillOfMaterial AS BillOfMaterial,
  UnassgdVersEBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  UnassgdVersEBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  UnassgdVersEBOM.Material AS Material,
  UnassgdVersEBOM.Plant AS Plant,
  UnassgdVersEBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  UnassgdVersEBOM.ProductionPlant AS ProductionPlant,
  UnassgdVersEBOM.BOMAlternativeText AS BOMAlternativeText,
  UnassgdVersEBOM.BOMGroup AS BOMGroup,
  UnassgdVersEBOM.EBOMType AS EBOMType,
  UnassgdVersEBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  UnassgdVersEBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  UnassgdVersEBOM.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  UnassgdVersEBOM.BOMHeaderText AS BOMHeaderText,
  UnassgdVersEBOM.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  UnassgdVersEBOM.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  UnassgdVersEBOM.BOMTechnicalType AS BOMTechnicalType,
  UnassgdVersEBOM.BOMUsagePriority AS BOMUsagePriority,
  UnassgdVersEBOM.BOMVersionStatus AS BOMVersionStatus,
  UnassgdVersEBOM.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  UnassgdVersEBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  UnassgdVersEBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  UnassgdVersEBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  UnassgdVersEBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  UnassgdVersEBOM.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  UnassgdVersEBOM.CreatedByUser AS CreatedByUser,
  UnassgdVersEBOM.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  UnassgdVersEBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  UnassgdVersEBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  UnassgdVersEBOM.IsALE AS IsALE,
  UnassgdVersEBOM.IsConfiguredMaterial AS IsConfiguredMaterial,
  UnassgdVersEBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  UnassgdVersEBOM.IsMarkedForDeletion AS IsMarkedForDeletion,
  UnassgdVersEBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  UnassgdVersEBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  UnassgdVersEBOM.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  UnassgdVersEBOM.LastChangeDate AS LastChangeDate,
  UnassgdVersEBOM.RecordCreationDate AS RecordCreationDate,
  UnassgdVersEBOM.LastChangedByUser AS LastChangedByUser,
  UnassgdVersEBOM.EBOMStatus AS EBOMStatus,
  UnassgdVersEBOM.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  UnassgdVersEBOM.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  UnassgdVersEBOM.IsMaterialUnitized AS IsMaterialUnitized,
  case when UnassgdVersEBOM.ChangeRecord is null then cast('' as /plmb/cr_id ) else UnassgdVersEBOM.ChangeRecord end as ChangeRecord AS ChangeRecordendasChangeRecord,
  UnassgdVersEBOM.ChangeRecordUUID AS ChangeRecordUUID,
  UnassgdVersEBOM.ChgRecdAssgd AS ChgRecdAssgd,
  cast('00000000' as datuv) AS LastChgStForBOMItm,
  cast('00000000' as /plmb/cr_eng_effctv_date) AS ChgRecdEngEffectiveDate,
  UnassgdNonVersEBOM.LatestEngEffctvDte AS LatestEngEffctvDte
FROM I_MngUnassgdVersEngBOM AS UnassgdVersEBOM
-- UNION with additional select branch(es): I_MngUnassgdNonVersEngBOM
;