I_CurrentMatlValnPrice

DDL: I_CURRENTMATLVALNPRICE SQL: ICURMATLVALNPRC Type: view BASIC
33 Fields 1 Data Sources

Current Material Valuation Price

I_CurrentMatlValnPrice is a Basic CDS View that provides data about "Current Material Valuation Price" in SAP S/4HANA. It reads from 1 data source (P_CURRENTMATLVALNPRICE) and exposes 33 fields with key fields CostEstimate, Ledger, CurrencyRole.

Data Sources (1)

SourceAliasJoin Type
P_CURRENTMATLVALNPRICE P_CURRENTMATLVALNPRICE from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICURMATLVALNPRC view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Current Material Valuation Price view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY Ledger Ledger Ledger
KEY CurrencyRole CurrencyRole Curr./Val. Type
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
Supplier Supplier Supplier
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
InvtryValnSpecialStockType InvtryValnSpecialStockType Special Stock
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
IsSupplierStockValuation IsSupplierStockValuation Vendor stk val.
CompanyCode CompanyCode Receiver Company Code
PriceDeterminationControl PriceDeterminationControl Price Determ.
MaterialPriceControl MaterialPriceControl Price Control
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
Currency Currency Valuation Crcy
MovingAveragePrice MovingAveragePrice Per. Unit Price
StandardPrice StandardPrice Standard price
InventoryPrice InventoryPrice Price
FuturePrice FuturePrice Inventory Price
FuturePriceValidityStartDate FuturePriceValidityStartDate Valid from
PlannedPrice PlannedPrice Inventory Price
FutrCostEstValuationVariant FutrCostEstValuationVariant Valuation Var.
FutureCostEstFiscalYear FutureCostEstFiscalYear Fut. FYyear
FutureCostEstimateFiscalPeriod FutureCostEstimateFiscalPeriod Posting Period
FutureCostEstCostingVersion FutureCostEstCostingVersion Late Completion
FixedPortionOfPlannedPrice FixedPortionOfPlannedPrice
LedgerName LedgerName Ledger Name
CurrencyRoleName CurrencyRoleName
LedgerValnCrcyRoleIsUsedInLogs LedgerValnCrcyRoleIsUsedInLogs Is Log. Curr. Type

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_CurrentMatlValnPrice.
-- 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: ICURMATLVALNPRC

CREATE VIEW I_CurrentMatlValnPrice AS
SELECT
  CostEstimate,
  Ledger,
  CurrencyRole,
  Material,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  WBSElementInternalID,
  WBSElementExternalID,
  InvtryValnSpecialStockType,
  InventorySpecialStockValnType,
  IsSupplierStockValuation,
  CompanyCode,
  PriceDeterminationControl,
  MaterialPriceControl,
  MaterialPriceUnitQty,
  Currency,
  MovingAveragePrice,
  StandardPrice,
  InventoryPrice,
  FuturePrice,
  FuturePriceValidityStartDate,
  PlannedPrice,
  FutrCostEstValuationVariant,
  FutureCostEstFiscalYear,
  FutureCostEstimateFiscalPeriod,
  FutureCostEstCostingVersion,
  FixedPortionOfPlannedPrice,
  LedgerName,
  CurrencyRoleName,
  LedgerValnCrcyRoleIsUsedInLogs
FROM P_CURRENTMATLVALNPRICE
;

Learn More