I_MaterialValuationDEX

DDL: I_MATERIALVALUATIONDEX SQL: IMATVALUATIONDEX Type: view COMPOSITE Package: FINS_ML_VDM
28 Fields 1 Data Sources

Material Valuation for Extraction

I_MaterialValuationDEX (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

MaterialValuation · Accounting and Financial Close

I_MaterialValuationDEX is a Composite CDS View (Fact) that provides data about "Material Valuation for Extraction" in SAP S/4HANA. It reads from 1 data source (P_MaterialValuation) and exposes 28 fields with key fields CostEstimate, Ledger, CurrencyRole. Part of development package FINS_ML_VDM.

SAP Help Documentation

CategoryCDS Views for Inventory Accounting
Data CategoryFACT
Purpose
This CDS view provides information about the stock valuation for materials like quantity and value of the total stock and the inventory price. This view is intended to be used for data extraction. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users must have the authorization to access certain valuation areas and ledgers.

Structure
Further important fields Important fields in this view include the following: Field Name Description CurrencyRole Coded representation of the currency and valuation type LedgerValnCrcyRoleIsUsedInLogs Indicator for the ledger, currency, and valuation type used in logistics

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Full (physical deletions are possible in source tables)

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-PC-ML-2CL
CapabilitiesData Source for Data Extraction
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides information about the stock valuation for materials like quantity and value of the total stock and the inventory price.</p> <p>This view is intended to be used for data extraction.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_MaterialValuation P_MaterialValuation from

Annotations (15)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IMATVALUATIONDEX view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Material Valuation for Extraction view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.sapObjectNodeType.name MaterialValuation view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
KEY Ledger Ledger Ledger in General Ledger Accounting
KEY CurrencyRole CurrencyRole External Currency Type and Valuation View
Material Material Material Number
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
CompanyCode CompanyCode Receiver Company Code
InventoryValuationCategory InventoryValuationCategory Valuation Category
MaterialValuationClass MaterialValuationClass Valuation Class
SalesOrder SalesOrder Sales and Distribution Document Number
SalesOrderItem SalesOrderItem Item number of the SD document
Supplier Supplier Account Number of Supplier
WBSElementInternalID WBSElementInternalID WBS Internal ID
InventorySpecialStockType InventorySpecialStockType Special Stock Indicator
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy Val. Strat. for Current Plan Price, Sales Order/Proj. Stock
PriceDeterminationControl PriceDeterminationControl Material Price Determination: Control
BaseUnit BaseUnit Valuation Unit of Measure
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
Currency Currency Valuation Crcy
MaterialPriceControl MaterialPriceControl Price Control Indicator
InventoryPrice InventoryPrice Material Ledger Price
StandardPrice StandardPrice Standard price
MovingAveragePrice MovingAveragePrice Per. Unit Price
TotalVltdStockQuantity TotalVltdStockQuantity Valuation Quantity
TotalValuatedStockAmount TotalValuatedStockAmount Value of Total Valuated Stock
LedgerValnCrcyRoleIsUsedInLogs LedgerValnCrcyRoleIsUsedInLogs Indicator: currency type is used in logistic reporting
LedgerName LedgerName Ledger Name
CurrencyRoleName CurrencyRoleName Currency Type Description

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_MaterialValuationDEX.
-- 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: IMATVALUATIONDEX

CREATE VIEW I_MaterialValuationDEX AS
SELECT
  CostEstimate,
  Ledger,
  CurrencyRole,
  Material,
  ValuationArea,
  InventoryValuationType,
  CompanyCode,
  InventoryValuationCategory,
  MaterialValuationClass,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  WBSElementInternalID,
  InventorySpecialStockType,
  CurPlanProjSlsOrdValnStrategy,
  PriceDeterminationControl,
  BaseUnit,
  MaterialPriceUnitQty,
  Currency,
  MaterialPriceControl,
  InventoryPrice,
  StandardPrice,
  MovingAveragePrice,
  TotalVltdStockQuantity,
  TotalValuatedStockAmount,
  LedgerValnCrcyRoleIsUsedInLogs,
  LedgerName,
  CurrencyRoleName
FROM P_MaterialValuation
;

Learn More