I_EngBOM

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_EngBOM.
-- 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: IENGBOM

CREATE VIEW I_EngBOM AS
SELECT
  MaterialBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MaterialBOM.BillOfMaterial AS BillOfMaterial,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MaterialBOM.Material AS Material,
  MaterialBOM.Plant AS Plant,
  MaterialBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  MaterialBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  MaterialBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  MaterialBOM.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  MaterialBOM.BOMExplosionApplication AS BOMExplosionApplication,
  MaterialBOM.BOMUsagePriority AS BOMUsagePriority,
  MaterialBOM.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  MaterialBOM.BOMVersionStatus AS BOMVersionStatus,
  MaterialBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  MaterialBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  MaterialBOM.IsConfiguredMaterial AS IsConfiguredMaterial,
  MaterialBOM.BOMTechnicalType AS BOMTechnicalType,
  MaterialBOM.BOMGroup AS BOMGroup,
  MaterialBOM.BOMHeaderText AS BOMHeaderText,
  MaterialBOM.BOMAlternativeText AS BOMAlternativeText,
  MaterialBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  MaterialBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  MaterialBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  MaterialBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  MaterialBOM.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  MaterialBOM.IsMarkedForDeletion AS IsMarkedForDeletion,
  MaterialBOM.IsALE AS IsALE,
  MaterialBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  MaterialBOM.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  MaterialBOM.RecordCreationDate AS RecordCreationDate,
  MaterialBOM.LastChangeDate AS LastChangeDate,
  MaterialBOM.CreatedByUser AS CreatedByUser,
  MaterialBOM.LastChangedByUser AS LastChangedByUser,
  MaterialBOM.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  MaterialBOM.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  MaterialBOM.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  MaterialBOM._BillOfMaterialItem AS _BillOfMaterialItem,
  MaterialBOM._BillOfMaterialVariantUsage AS _BillOfMaterialVariantUsage,
  MaterialBOM._UnitOfMeasure AS _UnitOfMeasure
FROM I_MaterialBOM AS MaterialBOM
INNER JOIN I_EngBOMUsage AS _EngBomUsage ON /* join condition not captured in parsed metadata */
;