C_ProdPlntFcstParameters

DDL: C_PRODPLNTFCSTPARAMETERS SQL: CPRODPLNTFCPAR Type: view CONSUMPTION Package: VDM_MD_PRODUCT

Cons View Product Plant Forecast Param

C_ProdPlntFcstParameters is a Consumption CDS View that provides data about "Cons View Product Plant Forecast Param" in SAP S/4HANA. It reads from 1 data source (I_ProdPlntFcstParametersTP) and exposes 29 fields with key fields Product, Plant. It has 2 associations to related views. Part of development package VDM_MD_PRODUCT.

Data Sources (1)

SourceAliasJoin Type
I_ProdPlntFcstParametersTP I_ProdPlntFcstParametersTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_Product _Product $projection.Product = _Product.Product
[1..1] C_Productplant _Plant $projection.Product = _Plant.Product and $projection.Plant = _Plant.Plant

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPRODPLNTFCPAR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cons View Product Plant Forecast Param view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.text.control #ASSOCIATED_TEXT_UI_HIDDEN view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
PlantForEdit PlantForEdit Plant ID
ProdPlntFcstParametersPointer ProdPlntFcstParametersPointer
ProdPlntFcstBscValAlphaFactor ProdPlntFcstBscValAlphaFactor
ProdPlntFcstTrendValBetaFactor ProdPlntFcstTrendValBetaFactor
ProdPlntMeanAbsltDvtnDeltaFctr ProdPlntMeanAbsltDvtnDeltaFctr
ProdPlntFcstNmbrOfFixedPeriod ProdPlntFcstNmbrOfFixedPeriod
ProdPlntFcstSeasnlIdxGammaFctr ProdPlntFcstSeasnlIdxGammaFctr
ProdPlntFcstWeightingGroup ProdPlntFcstWeightingGroup
FcstModelInitializationMethod FcstModelInitializationMethod
ProdPlntFcstParamIsOptimized ProdPlntFcstParamIsOptimized
ProdPlntFcstModSelProcedure ProdPlntFcstModSelProcedure
ProdPlntFcstModSelMethod ProdPlntFcstModSelMethod
OptimizationLevel OptimizationLevel
PerdsCntForFcstInitialization PerdsCntForFcstInitialization
FcstPerdCntPerSeasnCyc FcstPerdCntPerSeasnCyc
PeriodType
_Product _Product
_Plant _Plant
_ProdPlntFcstWeightingGrp _ProdPlntFcstWeightingGrp
_ProductFcstInitializeMeth _ProductFcstInitializeMeth
_ProductFcstInitializeMethText _ProductFcstInitializeMethText
_ProdPlntFcstSelProced _ProdPlntFcstSelProced
_ProdPlntFcstSelProcedTxt _ProdPlntFcstSelProcedTxt
_ProdPlntFcstModSelMeth _ProdPlntFcstModSelMeth
_ProdPlntFcstModSelMethText _ProdPlntFcstModSelMethText
_ProdFcstOptimizationLvl _ProdFcstOptimizationLvl
_ProdFcstOptimizationLvlText _ProdFcstOptimizationLvlText

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_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: CPRODPLNTFCPAR

CREATE VIEW C_ProdPlntFcstParameters AS
SELECT
  Product,
  Plant,
  PlantForEdit,
  ProdPlntFcstParametersPointer,
  ProdPlntFcstBscValAlphaFactor,
  ProdPlntFcstTrendValBetaFactor,
  ProdPlntMeanAbsltDvtnDeltaFctr,
  ProdPlntFcstNmbrOfFixedPeriod,
  ProdPlntFcstSeasnlIdxGammaFctr,
  ProdPlntFcstWeightingGroup,
  FcstModelInitializationMethod,
  ProdPlntFcstParamIsOptimized,
  ProdPlntFcstModSelProcedure,
  ProdPlntFcstModSelMethod,
  OptimizationLevel,
  PerdsCntForFcstInitialization,
  FcstPerdCntPerSeasnCyc,
  cast( '' as msehi ) AS PeriodType
FROM I_ProdPlntFcstParametersTP
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_Productplant AS _Plant ON Product = _Plant.Product AND Plant = _Plant.Plant  -- association [1..1]
;