I_MaterialValuationPrices

DDL: I_MATERIALVALUATIONPRICES SQL: IMATVALPRICES Type: view COMPOSITE Package: FINS_ML_VDM
41 Fields 1 Data Sources

Material Valuation Prices

I_MaterialValuationPrices is a Composite CDS View that provides data about "Material Valuation Prices" in SAP S/4HANA. It reads from 1 data source (P_MaterialValuationPrices) and exposes 41 fields with key fields CostEstimate, Ledger, FiscalYear, FiscalPeriod, CurrencyRole. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
P_MaterialValuationPrices P_MaterialValuationPrices from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMATVALPRICES view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Material Valuation Prices view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY Ledger Ledger Ledger
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY CurrencyRole CurrencyRole Curr./Val. Type
KEY PeriodType PeriodType PeriodIndicator
KEY FiscalPeriodType FiscalPeriodType
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
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
IsSupplierStockValuation IsSupplierStockValuation
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
FuturePriceValidityStartDate FuturePriceValidityStartDate Valid from
PlannedPrice PlannedPrice
FutrCostEstValuationVariant FutrCostEstValuationVariant
FutureCostEstFiscalYear FutureCostEstFiscalYear
FutureCostEstimateFiscalPeriod FutureCostEstimateFiscalPeriod
FutureCostEstCostingVersion FutureCostEstCostingVersion
FixedPortionOfPlannedPrice FixedPortionOfPlannedPrice
LedgerName LedgerName Ledger Name
CurrencyRoleName CurrencyRoleName
LegalCurrencyRole LegalCurrencyRole
LegalCurrencyRoleName LegalCurrencyRoleName
AccountingValuationView AccountingValuationView
AcctgValnVwSubviewCombinedName AcctgValnVwSubviewCombinedName
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_MaterialValuationPrices.
-- 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: IMATVALPRICES

CREATE VIEW I_MaterialValuationPrices AS
SELECT
  CostEstimate,
  Ledger,
  FiscalYear,
  FiscalPeriod,
  CurrencyRole,
  PeriodType,
  FiscalPeriodType,
  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,
  LegalCurrencyRole,
  LegalCurrencyRoleName,
  AccountingValuationView,
  AcctgValnVwSubviewCombinedName,
  LedgerValnCrcyRoleIsUsedInLogs
FROM P_MaterialValuationPrices
;

Learn More