I_MngUnassgdVersEngBOM

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_MngUnassgdVersEngBOM.
-- 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: IMNGUNASSVEREBOM

CREATE VIEW I_MngUnassgdVersEngBOM AS
SELECT
  VersEngBOMWithChgRecdAssgd.BillOfMaterial AS BillOfMaterial,
  VersEngBOMWithChgRecdAssgd.BillOfMaterialCategory AS BillOfMaterialCategory,
  VersEngBOMWithChgRecdAssgd.BillOfMaterialVariant AS BillOfMaterialVariant,
  VersEngBOMWithChgRecdAssgd.Material AS Material,
  VersEngBOMWithChgRecdAssgd.Plant AS Plant,
  VersEngBOMWithChgRecdAssgd.BillOfMaterialVersion AS BillOfMaterialVersion,
  VersEngBOMWithChgRecdAssgd.ProductionPlant AS ProductionPlant,
  VersEngBOMWithChgRecdAssgd.BOMAlternativeText AS BOMAlternativeText,
  VersEngBOMWithChgRecdAssgd.BOMGroup AS BOMGroup,
  VersEngBOMWithChgRecdAssgd.EBOMType AS EBOMType,
  VersEngBOMWithChgRecdAssgd.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  VersEngBOMWithChgRecdAssgd.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  VersEngBOMWithChgRecdAssgd.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  VersEngBOMWithChgRecdAssgd.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  VersEngBOMWithChgRecdAssgd.BOMHeaderText AS BOMHeaderText,
  VersEngBOMWithChgRecdAssgd.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  VersEngBOMWithChgRecdAssgd.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  VersEngBOMWithChgRecdAssgd.BOMTechnicalType AS BOMTechnicalType,
  VersEngBOMWithChgRecdAssgd.BOMUsagePriority AS BOMUsagePriority,
  VersEngBOMWithChgRecdAssgd.BOMVersionStatus AS BOMVersionStatus,
  VersEngBOMWithChgRecdAssgd.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  VersEngBOMWithChgRecdAssgd.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  VersEngBOMWithChgRecdAssgd.BillOfMaterialStatus AS BillOfMaterialStatus,
  VersEngBOMWithChgRecdAssgd.BillOfMaterialUUID AS BillOfMaterialUUID,
  VersEngBOMWithChgRecdAssgd.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  VersEngBOMWithChgRecdAssgd.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  VersEngBOMWithChgRecdAssgd.CreatedByUser AS CreatedByUser,
  VersEngBOMWithChgRecdAssgd.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  VersEngBOMWithChgRecdAssgd.EngineeringChangeDocument AS EngineeringChangeDocument,
  VersEngBOMWithChgRecdAssgd.HeaderValidityEndDate AS HeaderValidityEndDate,
  VersEngBOMWithChgRecdAssgd.HeaderValidityStartDate AS HeaderValidityStartDate,
  VersEngBOMWithChgRecdAssgd.IsALE AS IsALE,
  VersEngBOMWithChgRecdAssgd.IsConfiguredMaterial AS IsConfiguredMaterial,
  VersEngBOMWithChgRecdAssgd.IsLatestBOMVersion AS IsLatestBOMVersion,
  VersEngBOMWithChgRecdAssgd.IsMarkedForDeletion AS IsMarkedForDeletion,
  VersEngBOMWithChgRecdAssgd.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  VersEngBOMWithChgRecdAssgd.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  VersEngBOMWithChgRecdAssgd.RecordCreationDate AS RecordCreationDate,
  VersEngBOMWithChgRecdAssgd.LastChangeDate AS LastChangeDate,
  VersEngBOMWithChgRecdAssgd.LastChangedByUser AS LastChangedByUser,
  VersEngBOMWithChgRecdAssgd.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  VersEngBOMWithChgRecdAssgd.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  VersEngBOMWithChgRecdAssgd.IsMaterialUnitized AS IsMaterialUnitized,
  VersEngBOMWithChgRecdAssgd.ChangeRecord AS ChangeRecord,
  VersEngBOMWithChgRecdAssgd.ChangeRecordUUID AS ChangeRecordUUID,
  VersEngBOMWithChgRecdAssgd.ChgRecdAssgd AS ChgRecdAssgd,
  VersEngBOMWithChgRecdAssgd._BillOfMaterialItem AS _BillOfMaterialItem,
  VersEngBOMWithChgRecdAssgd._BillOfMaterialVariantUsage AS _BillOfMaterialVariantUsage,
  VersEngBOMWithChgRecdAssgd._UnitOfMeasure AS _UnitOfMeasure
FROM P_VersEngBOMAllProdnPlntCRChck AS VersEngBOMWithChgRecdAssgd
LEFT OUTER JOIN P_EngBOMStatusDetermination AS EngBOMMgBOMMLink ON /* join condition not captured in parsed metadata */
;