C_BillOfMaterialTP

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 C_BillOfMaterialTP.
-- 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: CBOMTP

CREATE VIEW C_BillOfMaterialTP AS
SELECT
  bomBO.BillOfMaterial AS BillOfMaterial,
  bomBO.BillOfMaterialCategory AS BillOfMaterialCategory,
  bomBO.BillOfMaterialVersion AS BillOfMaterialVersion,
  bomBO.EngineeringChangeDocument AS EngineeringChangeDocument,
  bomBO.Plant AS Plant,
  bomBO.SalesOrderItem AS SalesOrderItem,
  bomBO.SalesOrder AS SalesOrder,
  bomBO.SoldToParty AS SoldToParty,
  bomBO.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _Plants.PlantName AS PlantName,
  bomBO.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bomBO.Plant AS NewPlant,
  bomBO.BillOfMaterialVariantForEdit AS BillOfMaterialVariantForEdit,
  bomBO.BillOfMaterialVersionForEdit AS BillOfMaterialVersionForEdit,
  _Plants.PlantName AS PlantNameForEdit,
  bomBO.BillOfMaterialUUID AS BillOfMaterialUUID,
  bomBO.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bomBO.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  bomBO.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  bomBO.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  bomBO.BOMGroup AS BOMGroup,
  bomBO.IndicatorIsBOMWithDateHistory AS IndicatorIsBOMWithDateHistory,
  bomBO.IndicatorIsBOMChangedWithHist AS IndicatorIsBOMChangedWithHist,
  bomBO.BOMVersionStatus AS BOMVersionStatus,
  bomBO.BOMVersionStatusDescription AS BOMVersionStatusDescription,
  bomBO.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bomBO.IsLatestBOMVersion AS IsLatestBOMVersion,
  bomBO.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bomBO.IsConfiguredMaterial AS IsConfiguredMaterial,
  bomBO.BOMIsConfigurable AS BOMIsConfigurable,
  bomBO.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  bomBO.BOMExplosionApplication AS BOMExplosionApplication,
  bomBO.BOMUsagePriority AS BOMUsagePriority,
  bomBO.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  BOMTechnicalType,
  bomBO.BOMHeaderText AS BOMHeaderText,
  bomBO.BOMAlternativeText AS BOMAlternativeText,
  bomBO.LongTextLanguage AS LongTextLanguage,
  bomBO.LongTextExists AS LongTextExists,
  bomBO.BillOfMaterialStatus AS BillOfMaterialStatus,
  bomBO.HeaderValidityStartDate AS HeaderValidityStartDate,
  bomBO.HeaderValidityEndDate AS HeaderValidityEndDate,
  bomBO.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bomBO.IsMarkedForDeletion AS IsMarkedForDeletion,
  bomBO.BOMIsArchivedForDeletion AS BOMIsArchivedForDeletion,
  bomBO.IsALE AS IsALE,
  bomBO.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bomBO.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bomBO.RecordCreationDate AS RecordCreationDate,
  bomBO.CreatedByUser AS CreatedByUser,
  bomBO.LastChangeDate AS LastChangeDate,
  bomBO.LastChangedByUser AS LastChangedByUser,
  bomBO.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bomBO.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bomBO.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  bomBO.HeaderAttachmentKey AS HeaderAttachmentKey,
  bomBO.MaterialType AS MaterialType,
  bomBO.ProductIsConfigurable AS ProductIsConfigurable,
  bomBO.AssetIntelNetworkTrackingMode AS AssetIntelNetworkTrackingMode,
  bomBO.AssetIntelNetworkTemplate AS AssetIntelNetworkTemplate,
  bomBO.AssetIntelNetworkManufacturer AS AssetIntelNetworkManufacturer,
  bomBO.BOMAssetNtwkHndovrIsRelevant AS BOMAssetNtwkHndovrIsRelevant,
  bomBO.MaterialBOMObjectID AS MaterialBOMObjectID,
  bomBO.ChangeRecord AS ChangeRecord,
  bomBO.BOMPredecessorVersion AS BOMPredecessorVersion,
  bomBO.SelectedVersion AS SelectedVersion,
  bomBO.SelectedVariant AS SelectedVariant,
  _UnitizedMaterial.EffectivityType AS EffectivityType,
  cast('' as text255 ) AS BillOfMaterialHdrDetailsText,
  cast('' as boolean) AS IsCloudSystem,
  cast('' as boolean) AS BOMVersionIsReleased,
  _MaterialText.MaterialName AS MaterialName,
  BOMIsParamEffectivityRelevant,
  bomBO._SoldToParty AS _SoldToParty
FROM I_BillOfMaterialTP AS bomBO
LEFT OUTER JOIN C_BillOfMaterialItemTP AS _BillOfMaterialItem ON BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterialItem.BillOfMaterialVariant AND BillOfMaterialVersion = _BillOfMaterialItem.BillOfMaterialVersion AND EngineeringChangeDocument = _BillOfMaterialItem.HeaderChangeDocument AND Material = _BillOfMaterialItem.Material AND Plant = _BillOfMaterialItem.Plant  -- 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_ChangeMaster AS _ChangeNumber ON EngineeringChangeDocForEdit = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialStatus AS _BillOfMaterialStatus ON BillOfMaterialStatus = _BillOfMaterialStatus.BillOfMaterialStatus  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _Plants ON PlantForEdit = _Plants.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON MaterialForEdit = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitizedMaterial AS _UnitizedMaterial ON MaterialForEdit = _UnitizedMaterial.Material  -- association [1..1]
;