I_Billofmaterialwd

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_Billofmaterialwd.
-- 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: IBOMWD

CREATE VIEW I_Billofmaterialwd AS
SELECT
  headerWD.DraftUUID AS DraftUUID,
  headerWD.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  headerWD.BillOfMaterialUUID AS BillOfMaterialUUID,
  headerWD.Material AS Material,
  headerWD.Plant AS Plant,
  headerWD.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  headerWD.BillOfMaterialCategory AS BillOfMaterialCategory,
  headerWD.BillOfMaterial AS BillOfMaterial,
  headerWD.BillOfMaterialVariant AS BillOfMaterialVariant,
  headerWD.BillOfMaterialVersion AS BillOfMaterialVersion,
  headerWD.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  headerWD.BOMVersionStatus AS BOMVersionStatus,
  _VersionStatus.BOMVersionStatusDescription AS BOMVersionStatusDescription,
  headerWD.IsLatestBOMVersion AS IsLatestBOMVersion,
  headerWD.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  MatToLotSizeQuantity,
  headerWD.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  headerWD.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  headerWD.IsConfiguredMaterial AS IsConfiguredMaterial,
  headerWD.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  headerWD.BOMExplosionApplication AS BOMExplosionApplication,
  headerWD.BOMUsagePriority AS BOMUsagePriority,
  headerWD.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  BOMTechnicalType,
  headerWD.BOMGroup AS BOMGroup,
  headerWD.BOMHeaderText AS BOMHeaderText,
  headerWD.BOMAlternativeText AS BOMAlternativeText,
  headerWD.BillOfMaterialStatus AS BillOfMaterialStatus,
  headerWD.HeaderValidityStartDate AS HeaderValidityStartDate,
  headerWD.HeaderValidityEndDate AS HeaderValidityEndDate,
  headerWD.EngineeringChangeDocument AS EngineeringChangeDocument,
  headerWD.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  headerWD.IsMarkedForDeletion AS IsMarkedForDeletion,
  headerWD.IsALE AS IsALE,
  headerWD.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  headerWD.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  headerWD.RecordCreationDate AS RecordCreationDate,
  headerWD.LastChangeDate AS LastChangeDate,
  headerWD.CreatedByUser AS CreatedByUser,
  headerWD.LastChangedByUser AS LastChangedByUser,
  headerWD.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  headerWD.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  headerWD.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  headerWD.IsHeaderDraftModified AS IsHeaderDraftModified,
  headerWD.DraftAdministrativeDataUUID AS DraftAdministrativeDataUUID,
  headerWD.IsActiveEntity AS IsActiveEntity,
  headerWD.HasActiveEntity AS HasActiveEntity,
  headerWD.HasDraftEntity AS HasDraftEntity,
  cast ( '' as objky ) AS HeaderAttachmentKey,
  cast ( 1 as fdc_ux_fc preserving type) AS UxFcBillOfMaterialCategory,
  cast (1 as fdc_ux_fc preserving type) AS UxFcBOMVersionStatus
FROM P_Billofmaterialwd AS headerWD
LEFT OUTER JOIN I_VersionStatus AS _VersionStatus ON BOMVersionStatus = _VersionStatus.BOMVersionStatus AND _VersionStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Billofmaterialitemwd AS _BillOfMaterialItem ON BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterialItem.BillOfMaterialVariant AND DraftUUID = _BillOfMaterialItem.ParentDraftUUID  -- association [0..*]
LEFT OUTER JOIN I_Billofmaterialwd AS _SiblingEntity ON headerWD.BillOfMaterialHeaderUUID = _SiblingEntity.BillOfMaterialHeaderUUID AND headerWD.IsActiveEntity <> _SiblingEntity.IsActiveEntity  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialVariantUsage ON BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage AND _BillOfMaterialVariantUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BomChanges AS _BOMChangeNumbers ON BillOfMaterial = _BOMChangeNumbers.BillOfMaterial AND BillOfMaterialCategory = _BOMChangeNumbers.BillOfMaterialCategory AND BillOfMaterialVariant = _BOMChangeNumbers.BillOfMaterialVariant AND BillOfMaterialVersion = _BOMChangeNumbers.BillOfMaterialVersion AND Material = _BOMChangeNumbers.Material AND Plant = _BOMChangeNumbers.Plant AND BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON DraftAdministrativeDataUUID = _DraftAdministrativeData.DraftUUID  -- association [0..*]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumbers ON EngineeringChangeDocument = _ChangeNumbers.ChangeNumber  -- association [0..1]
;