I_MngUnassgdNonVersEngBOM

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_MngUnassgdNonVersEngBOM.
-- 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: IMNGUNASSNVREBOM

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