I_ProdPlntFcstParameters

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_ProdPlntFcstParameters.
-- 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: IPRODPLNTFCPAR

CREATE VIEW I_ProdPlntFcstParameters AS
SELECT
  material_index.matnr AS Product,
  material_index.werks AS Plant,
  forecast_parameters.pnum1 AS ProdPlntFcstParametersPointer,
  forecast_parameters.alpha AS ProdPlntFcstBscValAlphaFactor,
  forecast_parameters.beta1 AS ProdPlntFcstTrendValBetaFactor,
  forecast_parameters.delta AS ProdPlntMeanAbsltDvtnDeltaFctr,
  forecast_parameters.fimon AS ProdPlntFcstNmbrOfFixedPeriod,
  forecast_parameters.gamma AS ProdPlntFcstSeasnlIdxGammaFctr,
  forecast_parameters.gewgr AS ProdPlntFcstWeightingGroup,
  forecast_parameters.kzini AS FcstModelInitializationMethod,
  cast ( forecast_parameters.kzpar as xfeld ) AS ProdPlntFcstParamIsOptimized,
  forecast_parameters.modav AS ProdPlntFcstModSelProcedure,
  forecast_parameters.modaw AS ProdPlntFcstModSelMethod,
  forecast_parameters.opgra AS OptimizationLevel,
  forecast_parameters.perin AS PerdsCntForFcstInitialization,
  forecast_parameters.perio AS FcstPerdCntPerSeasnCyc
FROM mapr AS material_index
INNER JOIN prop AS forecast_parameters ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _Plant ON Product = _Plant.Product AND Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductForecastModel AS _ProductForecastModel ON ForecastModel = _ProductForecastModel.ForecastModel  -- association [0..1]
LEFT OUTER JOIN I_ProductForecastModelText AS _ProductForecastModelText ON ForecastModel = _ProductForecastModelText.ForecastModel  -- association [0..*]
LEFT OUTER JOIN I_ProdPlntFcstWeightingGrp AS _ProdPlntFcstWeightingGrp ON ProdPlntFcstWeightingGroup = _ProdPlntFcstWeightingGrp.ProdPlntFcstWeightingGroup  -- association [0..1]
LEFT OUTER JOIN I_ProdFcstInitializeMeth AS _ProductFcstInitializeMeth ON FcstModelInitializationMethod = _ProductFcstInitializeMeth.FcstModelInitializationMethod  -- association [0..1]
LEFT OUTER JOIN I_ProdFcstInitializeMethT AS _ProductFcstInitializeMethText ON FcstModelInitializationMethod = _ProductFcstInitializeMethText.FcstModelInitializationMethod  -- association [0..*]
LEFT OUTER JOIN I_ProdPlntFcstSelProced AS _ProdPlntFcstSelProced ON ProdPlntFcstModSelProcedure = _ProdPlntFcstSelProced.ProdPlntFcstModSelProcedure  -- association [0..1]
LEFT OUTER JOIN I_ProdPlntFcstSelProcedTxt AS _ProdPlntFcstSelProcedTxt ON ProdPlntFcstModSelProcedure = _ProdPlntFcstSelProcedTxt.ProdPlntFcstModSelProcedure  -- association [0..*]
LEFT OUTER JOIN I_ProdPlntFcstModSelMeth AS _ProdPlntFcstModSelMeth ON ProdPlntFcstModSelMethod = _ProdPlntFcstModSelMeth.ProdPlntFcstModSelMethod  -- association [0..1]
LEFT OUTER JOIN I_ProdPlntFcstModSelMethT AS _ProdPlntFcstModSelMethText ON ProdPlntFcstModSelMethod = _ProdPlntFcstModSelMethText.ProdPlntFcstModSelMethod  -- association [0..*]
LEFT OUTER JOIN I_ProdFcstOptimizationLvl AS _ProdFcstOptimizationLvl ON OptimizationLevel = _ProdFcstOptimizationLvl.OptimizationLevel  -- association [0..1]
LEFT OUTER JOIN I_ProdFcstOptimizationLvlT AS _ProdFcstOptimizationLvlText ON OptimizationLevel = _ProdFcstOptimizationLvlText.OptimizationLevel  -- association [0..*]
;