C_BOMDwnStreamDirectParent

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_BOMDwnStreamDirectParent.
-- 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: CBOMDOWNSTRMDP

CREATE VIEW C_BOMDwnStreamDirectParent AS
SELECT
  _BOMDirectParent.Material AS Material,
  _BOMDirectParent.Plant AS Plant,
  _BufferedProduct.MRPArea AS MRPArea,
  BillOfMaterialComponent,
  BillOfMaterialVariantUsage,
  BillOfMaterialCategory,
  _ProdText.ProductName AS MaterialName,
  _Plant.PlantName AS PlantName,
  _MRPArea.MRPAreaText AS MRPAreaText,
  _BufferedProduct.MRPType AS MRPType,
  _MRPText.MRPTypeName AS MRPTypeName,
  _BufferedProduct._Material.BaseUnit AS MaterialBaseUnit,
  _BufferedProduct.ProductIsBuffered AS ProductIsBuffered,
  _DomainText[SAPDataDictionaryDomain = 'PPH_DD_BUFFER_STATUS' and DomainValue = ProductIsBuffered].DomainText as BufferStatusText AS DomainTextasBufferStatusText,
  _DDProduct.BOMUsageCode AS BOMUsageCode,
  _DomainText[SAPDataDictionaryDomain = 'PPH_PQR_IND' and DomainValue = _DDProduct.BOMUsageCode].DomainText as BOMUsageDescription AS DomainTextasBOMUsageDescription,
  _DDProduct.ConsumptionCode AS ConsumptionCode,
  _DomainText[SAPDataDictionaryDomain = 'PPH_ABC_IND' and DomainValue = ConsumptionCode].DomainText as ConsumptionDescription AS DomainTextasConsumptionDescription,
  _DDProduct.ReplenishmentLeadTimeCode AS ReplenishmentLeadTimeCode,
  _DomainText[SAPDataDictionaryDomain = 'PPH_EFG_IND' and DomainValue = ReplenishmentLeadTimeCode].DomainText as ReplenishmentLeadTimeDesc AS DomainTextasReplenishmentLeadTimeDesc,
  _DDProduct.VariabilityCode AS VariabilityCode,
  _DomainText[SAPDataDictionaryDomain = 'PPH_XYZ_IND' and DomainValue = VariabilityCode].DomainText as VariabilityDescription AS DomainTextasVariabilityDescription,
  cast(0 as pph_bom_usagevalue) AS BOMUsageValue,
  _BufferedProduct.MRPProcedure AS MRPProcedure,
  _BufferedProduct.IsBulkMaterial AS IsBulkMaterial,
  _BufferedProduct.IsPhantomItem AS IsPhantomItem
INNER JOIN I_ProductPlantMRPArea AS _BufferedProduct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductText AS _ProdText ON _ProdText.Product = Material AND _ProdText.Language = $session.system_language  -- association [1..1]
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 _MRPText ON _BufferedProduct.MRPType = _MRPText.MRPType AND _MRPText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DDHistlBufDomainFxdValTxt AS _DomainText ON _DomainText.SAPDataDictionaryDomain = 'PPH_DD_BUFFER_STATUS' OR _DomainText.SAPDataDictionaryDomain = 'PPH_XYZ_IND' OR _DomainText.SAPDataDictionaryDomain = 'PPH_EFG_IND' OR _DomainText.SAPDataDictionaryDomain = 'PPH_ABC_IND' OR _DomainText.SAPDataDictionaryDomain = 'PPH_PQR_IND'  -- association [0..*]
LEFT OUTER JOIN I_MatlProcurementProfile AS _prfl ON _BufferedProduct.Plant = _prfl.Plant AND _BufferedProduct.MaterialProcurementProfile = _prfl.MaterialProcurementProfile  -- association [0..1]
LEFT OUTER JOIN I_MRPPlantControlParameter AS _MRPControlParams ON _BufferedProduct.Plant = _MRPControlParams.MRPPlant  -- association [0..1]
;