Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_ProdValnMatlLdgrFutrPrc

DDL: C_PRODVALNMATLLDGRFUTRPRC SQL: CPRODVALNFUTR Type: view CONSUMPTION
12 Fields 1 Data Sources

Consumption - Material Ledger Future Prices

C_ProdValnMatlLdgrFutrPrc is a Consumption CDS View that provides data about "Consumption - Material Ledger Future Prices" in SAP S/4HANA. It reads from 1 data source (I_ProdValnMatlLdgrFutrPrcWD) and exposes 12 fields with key fields ProdCostEstNumber, CurrencyRoleName, Product.

Data Sources (1)

SourceAliasJoin Type
I_ProdValnMatlLdgrFutrPrcWD MLFutrPrice from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPRODVALNFUTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consumption - Material Ledger Future Prices view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.lifecycle.status #DEPRECATED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProdCostEstNumber I_ProdValnMatlLdgrFutrPrcWD ProdCostEstNumber ProdCostEst.No.
KEY CurrencyRoleName I_ProdValnMatlLdgrFutrPrcWD CurrencyRoleName Valuation Area
KEY Product I_ProdValnMatlLdgrFutrPrcWD Product Product Sold
FuturePrice I_ProdValnMatlLdgrFutrPrcWD FuturePrice Future Price
PlannedPriceInCoCodeCrcy I_ProdValnMatlLdgrFutrPrcWD PlannedPriceInCoCodeCrcy Fut. Plnd Price
FutrCostEstValuationVariant I_ProdValnMatlLdgrFutrPrcWD FutrCostEstValuationVariant Valuation Var.
FutureCostEstFiscalYear I_ProdValnMatlLdgrFutrPrcWD FutureCostEstFiscalYear Fut. FYyear
FutureCostEstimateFiscalPeriod I_ProdValnMatlLdgrFutrPrcWD FutureCostEstimateFiscalPeriod Posting Period
FutureCostEstCostingVersion I_ProdValnMatlLdgrFutrPrcWD FutureCostEstCostingVersion Late Completion
FutrPlanProjSlsOrdValnStrategy I_ProdValnMatlLdgrFutrPrcWD FutrPlanProjSlsOrdValnStrategy Fut. Valn Strat.
FxdPortnOfFutPlPrcInCoCodeCrcy I_ProdValnMatlLdgrFutrPrcWD FxdPortnOfFutPlPrcInCoCodeCrcy Fut. PlanPrice, Fxd
FuturePriceValidityStartDate I_ProdValnMatlLdgrFutrPrcWD FuturePriceValidityStartDate Valid from

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_ProdValnMatlLdgrFutrPrc.
-- 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: CPRODVALNFUTR

CREATE VIEW C_ProdValnMatlLdgrFutrPrc AS
SELECT
  MLFutrPrice.ProdCostEstNumber AS ProdCostEstNumber,
  MLFutrPrice.CurrencyRoleName AS CurrencyRoleName,
  MLFutrPrice.Product AS Product,
  MLFutrPrice.FuturePrice AS FuturePrice,
  MLFutrPrice.PlannedPriceInCoCodeCrcy AS PlannedPriceInCoCodeCrcy,
  MLFutrPrice.FutrCostEstValuationVariant AS FutrCostEstValuationVariant,
  MLFutrPrice.FutureCostEstFiscalYear AS FutureCostEstFiscalYear,
  MLFutrPrice.FutureCostEstimateFiscalPeriod AS FutureCostEstimateFiscalPeriod,
  MLFutrPrice.FutureCostEstCostingVersion AS FutureCostEstCostingVersion,
  MLFutrPrice.FutrPlanProjSlsOrdValnStrategy AS FutrPlanProjSlsOrdValnStrategy,
  MLFutrPrice.FxdPortnOfFutPlPrcInCoCodeCrcy AS FxdPortnOfFutPlPrcInCoCodeCrcy,
  MLFutrPrice.FuturePriceValidityStartDate AS FuturePriceValidityStartDate
FROM I_ProdValnMatlLdgrFutrPrcWD AS MLFutrPrice
;

Learn More