P_BillOfMaterialHeader

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 P_BillOfMaterialHeader.
-- 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: PBOMHEADER

CREATE VIEW P_BillOfMaterialHeader AS
SELECT
  materialBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  materialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  materialBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  materialBOM.BillOfMaterial AS BillOfMaterial,
  materialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  materialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  materialBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  _Mast.Material AS Material,
  _Mast.Plant AS Plant,
  _Kdst.SalesOrder AS SalesOrder,
  cast( '000000' as cs_vbpos preserving type ) AS SalesOrderItem,
  materialBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  materialBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  materialBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  materialBOM.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  materialBOM.BOMExplosionApplication AS BOMExplosionApplication,
  materialBOM.BOMUsagePriority AS BOMUsagePriority,
  materialBOM.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  materialBOM.BOMVersionStatus AS BOMVersionStatus,
  _Mast.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  _Mast.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  materialBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  materialBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  materialBOM.BOMTechnicalType AS BOMTechnicalType,
  materialBOM.BOMGroup AS BOMGroup,
  materialBOM.IndicatorIsBOMWithDateHistory AS IndicatorIsBOMWithDateHistory,
  materialBOM.IndicatorIsBOMChangedWithHist AS IndicatorIsBOMChangedWithHist,
  materialBOM.BOMHeaderText AS BOMHeaderText,
  materialBOM.BOMAlternativeText AS BOMAlternativeText,
  materialBOM.LongTextLanguage AS LongTextLanguage,
  cast('' as ltxzu preserving type) AS LongTextExists,
  materialBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  materialBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  materialBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  materialBOM.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  materialBOM.IsMarkedForDeletion AS IsMarkedForDeletion,
  materialBOM.BOMIsArchivedForDeletion AS BOMIsArchivedForDeletion,
  materialBOM.IsConfiguredMaterial AS IsConfiguredMaterial,
  materialBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  materialBOM.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  materialBOM.RecordCreationDate AS RecordCreationDate,
  materialBOM.LastChangeDate AS LastChangeDate,
  materialBOM.LastChangedByUser AS LastChangedByUser,
  materialBOM.CreatedByUser AS CreatedByUser,
  materialBOM.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  materialBOM.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  materialBOM.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  materialBOM.LastChangeDateTime AS LastChangeDateTime,
  materialBOM.BOMAssetNtwkHndovrIsRelevant AS BOMAssetNtwkHndovrIsRelevant,
  materialBOM._Mast.MaterialBOMObjectID AS MaterialBOMObjectID,
  materialBOM.BOMPredecessorVersion AS BOMPredecessorVersion
FROM I_BillOfMaterial AS materialBOM
LEFT OUTER JOIN I_SalesOrderBOMLink AS _Kdst ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_BillOfMaterial
;