C_BOMDwnStreamNextBuffered

DDL: C_BOMDWNSTREAMNEXTBUFFERED SQL: CBOMDWNSTRMBUFF Type: view CONSUMPTION
28 Fields 1 Data Sources 5 Associations

BOM downstream buffered product detail

C_BOMDwnStreamNextBuffered is a Consumption CDS View that provides data about "BOM downstream buffered product detail" in SAP S/4HANA. It reads from 1 data source (I_ProductPlantMRPArea) and exposes 28 fields with key fields Material, Plant, MRPArea. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductPlantMRPArea I_ProductPlantMRPArea from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_MRPArea _MRPArea $projection.MRPArea = _MRPArea.MRPArea
[1..1] I_MRPTypeText _MRPType $projection.MRPType = _MRPType.MRPType and _MRPType.Language = $session.system_language
[1..1] I_DemandDrivenProduct1 _DDProduct $projection.Material = _DDProduct.Material and $projection.Plant = _DDProduct.Plant and $projection.MRPArea = _DDProduct.MRPArea
[1..1] I_BufferStatus _BufferText $projection.ProductIsBuffered = _BufferText.BufferStatus

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CBOMDWNSTRMBUFF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BOM downstream buffered product detail view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
UI.headerInfo.typeName Product view
UI.headerInfo.typeNamePlural Products view
UI.headerInfo.title.value Material view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
BillOfMaterialComponent
MaterialName
PlantName _Plant PlantName Plant Name
MRPAreaText _MRPArea MRPAreaText
MRPType MRPType MRP Type
MRPProcedure MRPProcedure
MRPTypeName _MRPType MRPTypeName
ProductIsBuffered ProductIsBuffered
BufferStatus
StepsBetweenBuffers
BOMUsageCode _DDProduct BOMUsageCode
BOMUsageDescription
ConsumptionCode _DDProduct ConsumptionCode
ConsumptionDescription
ReplenishmentLeadTimeCode _DDProduct ReplenishmentLeadTimeCode
ReplenishmentLeadTimeDesc
VariabilityCode _DDProduct VariabilityCode
VariabilityDescription
BufferStatusText
IndividualLeadTime
ProductAuthorizationGroup _Product AuthorizationGroup AuthorizGroup
ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup
IsBulkMaterial IsBulkMaterial Bulk material
IsPhantomItem IsPhantomItem Phantom item

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_BOMDwnStreamNextBuffered.
-- 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: CBOMDWNSTRMBUFF

CREATE VIEW C_BOMDwnStreamNextBuffered AS
SELECT
  Material,
  Plant,
  MRPArea,
  cast('' as idnrk) AS BillOfMaterialComponent,
  _Material._Text[1:Language = $session.system_language].ProductName AS MaterialName,
  _Plant.PlantName AS PlantName,
  _MRPArea.MRPAreaText AS MRPAreaText,
  MRPType,
  MRPProcedure,
  _MRPType.MRPTypeName AS MRPTypeName,
  ProductIsBuffered,
  cast('' as pph_dd_buffer_status) AS BufferStatus,
  cast(0 as pph_steps_inbetween) AS StepsBetweenBuffers,
  _DDProduct.BOMUsageCode AS BOMUsageCode,
  _DDProduct._BOMUsgeText.BOMUsageDescription AS BOMUsageDescription,
  _DDProduct.ConsumptionCode AS ConsumptionCode,
  _DDProduct._ConsumptionText.ConsumptionDescription AS ConsumptionDescription,
  _DDProduct.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  _DDProduct._ReplnmtText.ReplenishmentLeadTimeDesc AS ReplenishmentLeadTimeDesc,
  _DDProduct.VariabilityCode AS VariabilityCode,
  _DDProduct._VarText.VariabilityDescription AS VariabilityDescription,
  _BufferText._BufferStatusText[1:Language = $session.system_language].BufferStatusText AS BufferStatusText,
  cast(0 as pph_ind_lead_time) AS IndividualLeadTime,
  _Product.AuthorizationGroup AS ProductAuthorizationGroup,
  _Product._ProductType.AuthorizationGroup AS ProductTypeAuthorizationGroup,
  _Product._ProductGroup.AuthorizationGroup AS ProductGroupAuthorizationGroup,
  IsBulkMaterial,
  IsPhantomItem
FROM I_ProductPlantMRPArea
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_MRPTypeText AS _MRPType ON MRPType = _MRPType.MRPType AND _MRPType.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_DemandDrivenProduct1 AS _DDProduct ON Material = _DDProduct.Material AND Plant = _DDProduct.Plant AND MRPArea = _DDProduct.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_BufferStatus AS _BufferText ON ProductIsBuffered = _BufferText.BufferStatus  -- association [1..1]
;

Learn More