I_BOMHeaderDetermine

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_BOMHeaderDetermine.
-- 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: IBOMHEADDET

CREATE VIEW I_BOMHeaderDetermine 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.HeaderEngineeringChgNmbrDoc AS EngineeringChangeDocument,
  bom_header.ChangeNumberTo AS ChgToEngineeringChgDocument,
  bom_header.DeletionIndicator 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 P_Bom_Header_Determine AS bom_header
;