C_BillOfMaterial

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_BillOfMaterial.
-- 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: CBILLOFMATERIAL

CREATE VIEW C_BillOfMaterial AS
SELECT
  bomBO.DraftUUID AS DraftUUID,
  bomBO.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bomBO.BillOfMaterialUUID AS BillOfMaterialUUID,
  bomBO.Material AS Material,
  bomBO.Plant AS Plant,
  bomBO.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bomBO.BillOfMaterialCategory AS BillOfMaterialCategory,
  bomBO.BillOfMaterial AS BillOfMaterial,
  bomBO.BillOfMaterialVariant AS BillOfMaterialVariant,
  bomBO.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  MatToLotSizeQuantity,
  bomBO.BOMGroup AS BOMGroup,
  bomBO.BillOfMaterialVersion AS BillOfMaterialVersion,
  bomBO.BOMVersionStatus AS BOMVersionStatus,
  bomBO.BOMVersionStatusDescription AS BOMVersionStatusDescription,
  bomBO.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bomBO.IsLatestBOMVersion AS IsLatestBOMVersion,
  bomBO.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bomBO.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bomBO.IsConfiguredMaterial AS IsConfiguredMaterial,
  bomBO.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  bomBO.BOMExplosionApplication AS BOMExplosionApplication,
  bomBO.BOMUsagePriority AS BOMUsagePriority,
  bomBO.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  BOMTechnicalType,
  bomBO.BOMHeaderText AS BOMHeaderText,
  bomBO.BOMAlternativeText AS BOMAlternativeText,
  bomBO.BillOfMaterialStatus AS BillOfMaterialStatus,
  bomBO.HeaderValidityStartDate AS HeaderValidityStartDate,
  bomBO.HeaderValidityEndDate AS HeaderValidityEndDate,
  bomBO.EngineeringChangeDocument AS EngineeringChangeDocument,
  bomBO.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bomBO.IsMarkedForDeletion AS IsMarkedForDeletion,
  bomBO.IsALE AS IsALE,
  bomBO.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bomBO.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bomBO.RecordCreationDate AS RecordCreationDate,
  bomBO.LastChangeDate AS LastChangeDate,
  bomBO.CreatedByUser AS CreatedByUser,
  bomBO.LastChangedByUser AS LastChangedByUser,
  bomBO.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bomBO.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bomBO.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  bomBO.IsHeaderDraftModified AS IsHeaderDraftModified,
  bomBO.DraftAdministrativeDataUUID AS DraftAdministrativeDataUUID,
  bomBO.IsActiveEntity AS IsActiveEntity,
  bomBO.HasActiveEntity AS HasActiveEntity,
  bomBO.HasDraftEntity AS HasDraftEntity,
  bomBO.HeaderAttachmentKey AS HeaderAttachmentKey,
  bomBO.UxFcMaterial AS UxFcMaterial,
  bomBO.UxFcPlant AS UxFcPlant,
  bomBO.UxFcBillOfMaterialVariantUsage AS UxFcBillOfMaterialVariantUsage,
  bomBO.UxFcBillOfMaterialCategory AS UxFcBillOfMaterialCategory,
  bomBO.UxFcBillOfMaterialVariant AS UxFcBillOfMaterialVariant,
  bomBO.UxFcMatFromLotSizeQuantity AS UxFcMatFromLotSizeQuantity,
  bomBO.UxFcMatToLotSizeQuantity AS UxFcMatToLotSizeQuantity,
  bomBO.UxFcHeaderValidityStartDate AS UxFcHeaderValidityStartDate,
  bomBO.UxFcEngineeringChangeDocument AS UxFcEngineeringChangeDocument,
  bomBO.UxFcBillOfMaterialVersion AS UxFcBillOfMaterialVersion,
  bomBO.UxFcBOMVersionStatus AS UxFcBOMVersionStatus
FROM I_Billofmaterialwd AS bomBO
LEFT OUTER JOIN C_BillOfMaterialItem AS _BillOfMaterialItem ON BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterialItem.BillOfMaterialVariant AND DraftUUID = _BillOfMaterialItem.ParentDraftUUID AND BillOfMaterialVersion = _BillOfMaterialItem.BillOfMaterialVersion  -- association [0..*]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialVariantUsage ON BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage AND _BillOfMaterialVariantUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_BillOfMaterial AS _SiblingEntity ON bomBO.BillOfMaterialHeaderUUID = _SiblingEntity.BillOfMaterialHeaderUUID AND bomBO.IsActiveEntity <> _SiblingEntity.IsActiveEntity  -- association [0..1]
;