I_BillOfMaterialWithKeyDate

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_BillOfMaterialWithKeyDate.
-- 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: IBOMWITHKEYDATE
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_BillOfMaterialWithKeyDate AS
SELECT
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.BillOfMaterial AS BillOfMaterial,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.BillOfMaterialVersion AS BillOfMaterialVersion,
  bom_header.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bom_header.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bom_header.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  bom_header.BOMExplosionApplication AS BOMExplosionApplication,
  bom_header.BOMUsagePriority AS BOMUsagePriority,
  bom_header.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  bom_header.BOMVersionStatus AS BOMVersionStatus,
  bom_header.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bom_header.IsLatestBOMVersion AS IsLatestBOMVersion,
  bom_header.BOMIsConfigurable AS BOMIsConfigurable,
  bom_header.IsConfiguredMaterial AS IsConfiguredMaterial,
  cast ( bom_header.BOMTechnicalType as tetyp_d preserving type) AS BOMTechnicalType,
  bom_header.BOMGroup AS BOMGroup,
  bom_header.BOMHeaderText AS BOMHeaderText,
  bom_header.BOMAlternativeText AS BOMAlternativeText,
  bom_header.BillOfMaterialStatus AS BillOfMaterialStatus,
  bom_header.HeaderValidityStartDate AS HeaderValidityStartDate,
  bom_header.HeaderValidityEndDate AS HeaderValidityEndDate,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  bom_header.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_header.IsMarkedForDeletion AS IsMarkedForDeletion,
  bom_header.IsALE AS IsALE,
  bom_header.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bom_header.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bom_header.RecordCreationDate AS RecordCreationDate,
  bom_header.LastChangeDate AS LastChangeDate,
  bom_header.CreatedByUser AS CreatedByUser,
  bom_header.LastChangedByUser AS LastChangedByUser,
  bom_header.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bom_header.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bom_header.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  bom_header.LastChangeDateTime AS LastChangeDateTime,
  bom_header.BOMAssetNtwkHndovrIsRelevant AS BOMAssetNtwkHndovrIsRelevant,
  bom_header.BOMPredecessorVersion AS BOMPredecessorVersion
FROM I_BOMHeaderDetermine AS bom_header
LEFT OUTER JOIN I_BOMComponentWithKeyDate AS _BillOfMaterialItem ON BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BillOfMaterialVariant = _BillOfMaterialItem.BillOfMaterialVariant AND BillOfMaterialVersion = _BillOfMaterialItem.BillOfMaterialVersion  -- association [0..*]
LEFT OUTER JOIN I_MaterialBOMLink AS _Mast ON BillOfMaterialCategory = _Mast.BillOfMaterialCategory AND BillOfMaterial = _Mast.BillOfMaterial AND BillOfMaterialVariant = _Mast.BillOfMaterialVariant AND BillOfMaterialVariantUsage = _Mast.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN I_DocumentBOMLink AS _Dost ON BillOfMaterialCategory = _Dost.BillOfMaterialCategory AND BillOfMaterial = _Dost.BillOfMaterial AND BillOfMaterialVariant = _Dost.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_ProjectBOMLink AS _Prst ON BillOfMaterialCategory = _Prst.BillOfMaterialCategory AND BillOfMaterial = _Prst.BillOfMaterial AND BillOfMaterialVariant = _Prst.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_SalesOrderBOMLink AS _Kdst ON BillOfMaterialCategory = _Kdst.BillOfMaterialCategory AND BillOfMaterial = _Kdst.BillOfMaterial AND BillOfMaterialVariant = _Kdst.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_EquipmentBOMLink AS _Eqst ON BillOfMaterialCategory = _Eqst.BillOfMaterialCategory AND BillOfMaterial = _Eqst.BillOfMaterial AND BillOfMaterialVariant = _Eqst.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocBOMLink AS _Tpst ON BillOfMaterialCategory = _Tpst.BillOfMaterialCategory AND BillOfMaterial = _Tpst.BillOfMaterial AND BillOfMaterialVariant = _Tpst.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_StandardBOMLink AS _Stst ON BillOfMaterialCategory = _Stst.BillOfMaterialCategory AND BillOfMaterial = _Stst.BillOfMaterial AND BillOfMaterialVariant = _Stst.BillOfMaterialVariant  -- 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 I_UnitOfMeasure AS _UnitOfMeasure ON BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;