I_BillOfMaterialHeaderDEX

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_BillOfMaterialHeaderDEX.
-- 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: IBOMHEADERDEX

CREATE VIEW I_BillOfMaterialHeaderDEX AS
SELECT
  bomHeader.BillOfMaterialCategory AS BillOfMaterialCategory,
  cast(bomHeader.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  bomHeader.BillOfMaterialVariant AS BillOfMaterialVariant,
  bomHeader.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bomHeader.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bomHeader.BillOfMaterialVersion AS BillOfMaterialVersion,
  bomHeader.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bomHeader.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  cast('PP01' as capid) AS BOMExplosionApplication,
  cast('' as x415a) AS IsMultipleBOMAlt,
  cast('' as cslpr) AS BOMUsagePriority,
  bomHeader.BOMIsConfigurable AS BOMIsConfigurable,
  bomHeader.IsConfiguredMaterial AS IsConfiguredMaterial,
  bomHeader.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bomHeader.BOMTechnicalType AS BOMTechnicalType,
  bomHeader.BOMHeaderText AS BOMHeaderText,
  bomHeader.LongTextLanguage AS LongTextLanguage,
  bomHeader.BOMGroup AS BOMGroup,
  bomHeader.IndicatorIsBOMWithDateHistory AS IndicatorIsBOMWithDateHistory,
  bomHeader.BOMAlternativeText AS BOMAlternativeText,
  bomHeader.BillOfMaterialStatus AS BillOfMaterialStatus,
  bomHeader.HeaderValidityEndDate AS HeaderValidityEndDate,
  bomHeader.HeaderEngineeringChgNmbrDoc AS HeaderEngineeringChgNmbrDoc,
  bomHeader.DeletionIndicator AS DeletionIndicator,
  bomHeader.BOMIsArchivedForDeletion AS BOMIsArchivedForDeletion,
  bomHeader.IsALE AS IsALE,
  bomHeader.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bomHeader.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bomHeader.RecordCreationDate AS RecordCreationDate,
  bomHeader.LastChangeDate AS LastChangeDate,
  bomHeader.CreatedByUser AS CreatedByUser,
  bomHeader.LastChangedByUser AS LastChangedByUser,
  bomHeader.BOMPredecessorVersion AS BOMPredecessorVersion,
  bomHeader.BOMVersionStatus AS BOMVersionStatus,
  bomHeader.IsLatestBOMVersion AS IsLatestBOMVersion,
  bomHeader.BOMOrBOMAltvCrtedInPlnt AS BOMOrBOMAltvCrtedInPlnt,
  bomHeader.LastChangeDateTime AS LastChangeDateTime,
  bomHeader.BOMAssetNtwkHndovrIsRelevant AS BOMAssetNtwkHndovrIsRelevant
FROM P_Bom_Header_Determine AS bomHeader
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialUsage ON BillOfMaterialVariantUsage = _BillOfMaterialUsage.BillOfMaterialVariantUsage AND _BillOfMaterialUsage.Language = $session.system_language  -- association [0..1]
;