I_ProdPlntFcstParametersTP

DDL: I_PRODPLNTFCSTPARAMETERSTP SQL: IPRODPLNTFCPARTP Type: view TRANSACTIONAL

TP View-Prod Plant Forecast Parm (draft)

I_ProdPlntFcstParametersTP is a Transactional CDS View that provides data about "TP View-Prod Plant Forecast Parm (draft)" in SAP S/4HANA. It reads from 1 data source (I_ProdPlntFcstParameters) and exposes 28 fields with key fields Product, Plant. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdPlntFcstParameters I_ProdPlntFcstParameters from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProductWD _Product $projection.Product = _Product.Product
[1..1] I_ProductPlantWD _Plant $projection.Product = _Plant.Product and $projection.Plant = _Plant.Plant

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPRODPLNTFCPARTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP View-Prod Plant Forecast Parm (draft) view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PRD_PLNT_FCSTPAR view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
PlantForEdit Plant Valuation Area
ProdPlntFcstParametersPointer ProdPlntFcstParametersPointer Pointer param
ProdPlntFcstBscValAlphaFactor ProdPlntFcstBscValAlphaFactor Alpha factor
ProdPlntFcstTrendValBetaFactor ProdPlntFcstTrendValBetaFactor Beta factor
ProdPlntMeanAbsltDvtnDeltaFctr ProdPlntMeanAbsltDvtnDeltaFctr WarrCountValue
ProdPlntFcstNmbrOfFixedPeriod ProdPlntFcstNmbrOfFixedPeriod Fixed periods
ProdPlntFcstSeasnlIdxGammaFctr ProdPlntFcstSeasnlIdxGammaFctr Gamma factor
ProdPlntFcstWeightingGroup ProdPlntFcstWeightingGroup Weighting group
FcstModelInitializationMethod FcstModelInitializationMethod Initialization
ProdPlntFcstParamIsOptimized ProdPlntFcstParamIsOptimized
ProdPlntFcstModSelProcedure ProdPlntFcstModSelProcedure Model slct pro.
ProdPlntFcstModSelMethod ProdPlntFcstModSelMethod Model selection
OptimizationLevel OptimizationLevel Optimiz.level
PerdsCntForFcstInitialization PerdsCntForFcstInitialization Init. periods
FcstPerdCntPerSeasnCyc FcstPerdCntPerSeasnCyc Time unit
_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 I_ProdPlntFcstParametersTP.
-- 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: IPRODPLNTFCPARTP

CREATE VIEW I_ProdPlntFcstParametersTP AS
SELECT
  Product,
  Plant,
  Plant AS PlantForEdit,
  ProdPlntFcstParametersPointer,
  ProdPlntFcstBscValAlphaFactor,
  ProdPlntFcstTrendValBetaFactor,
  ProdPlntMeanAbsltDvtnDeltaFctr,
  ProdPlntFcstNmbrOfFixedPeriod,
  ProdPlntFcstSeasnlIdxGammaFctr,
  ProdPlntFcstWeightingGroup,
  FcstModelInitializationMethod,
  ProdPlntFcstParamIsOptimized,
  ProdPlntFcstModSelProcedure,
  ProdPlntFcstModSelMethod,
  OptimizationLevel,
  PerdsCntForFcstInitialization,
  FcstPerdCntPerSeasnCyc
FROM I_ProdPlntFcstParameters
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantWD AS _Plant ON Product = _Plant.Product AND Plant = _Plant.Plant  -- association [1..1]
;