C_MatlValnManageInvtryValn

DDL: C_MATLVALNMANAGEINVTRYVALN SQL: CMVMINVPRVAL Type: view CONSUMPTION
37 Fields 1 Data Sources

Prices and values over Per. and Curr.

C_MatlValnManageInvtryValn is a Consumption CDS View that provides data about "Prices and values over Per. and Curr." in SAP S/4HANA. It reads from 1 data source (I_MaterialValuationsByPeriods) and exposes 37 fields with key fields CostEstimate, LedgerValuationCurrencyRole, FiscalYear, FiscalPeriod.

Data Sources (1)

SourceAliasJoin Type
I_MaterialValuationsByPeriods I_MaterialValuationsByPeriods from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMVMINVPRVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Prices and values over Per. and Curr. view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY LedgerValuationCurrencyRole LedgerValuationCurrencyRole
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
LegalCurrencyRole LegalCurrencyRole
Ledger Ledger Ledger
AccountingValuationView AccountingValuationView
AccountingValuationSubview AccountingValuationSubview
LedgerValnCrcyRoleIsUsedInLogs LedgerValnCrcyRoleIsUsedInLogs Is Log. Curr. Type
AccountingValuationViewName AccountingValuationViewName
AccountingValuationSubviewName AccountingValuationSubviewName
AcctgValnVwSubviewCombinedName AcctgValnVwSubviewCombinedName
LegalCurrencyRoleName LegalCurrencyRoleName
LedgerName LedgerName Ledger Name
TotalValuatedStockAmount TotalValuatedStockAmount
TotalVltdStockQuantity TotalVltdStockQuantity
MaterialPriceControl MaterialPriceControl Price Control
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
InvtryValnSpecialStockType InvtryValnSpecialStockType
StandardPrice StandardPrice Standard price
MovingAveragePrice MovingAveragePrice Per. Unit Price
FuturePrice FuturePrice
FuturePriceValidityStartDate I_MaterialValuationsByPeriods FuturePriceValidityStartDate Valid from
FuturePlannedPrice FuturePlannedPrice
Currency Currency Valuation Crcy
BaseUnit BaseUnit Unit of Measure
ValuationQuantityUnit ValuationQuantityUnit Unit of Measure
ValuationArea ValuationArea Valuation Area
CompanyCode CompanyCode Receiver Company Code
ControllingArea I_MaterialValuationsByPeriods ControllingArea Controlling Area
ControllingValuationType
Material Material Vehicle Model
FiscalPeriodStartDate FiscalPeriodStartDate
FiscalPeriodEndDate FiscalPeriodEndDate
PostgFsclPerdCurDateRelation PostgFsclPerdCurDateRelation
_ControllingArea _ControllingArea

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_MatlValnManageInvtryValn.
-- 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: CMVMINVPRVAL

CREATE VIEW C_MatlValnManageInvtryValn AS
SELECT
  CostEstimate,
  LedgerValuationCurrencyRole,
  FiscalYear,
  FiscalPeriod,
  LegalCurrencyRole,
  Ledger,
  AccountingValuationView,
  AccountingValuationSubview,
  LedgerValnCrcyRoleIsUsedInLogs,
  AccountingValuationViewName,
  AccountingValuationSubviewName,
  AcctgValnVwSubviewCombinedName,
  LegalCurrencyRoleName,
  LedgerName,
  TotalValuatedStockAmount,
  TotalVltdStockQuantity,
  MaterialPriceControl,
  MaterialPriceUnitQty,
  InventorySpecialStockValnType,
  InvtryValnSpecialStockType,
  StandardPrice,
  MovingAveragePrice,
  FuturePrice,
  I_MaterialValuationsByPeriods.FuturePriceValidityStartDate AS FuturePriceValidityStartDate,
  FuturePlannedPrice,
  Currency,
  BaseUnit,
  ValuationQuantityUnit,
  ValuationArea,
  CompanyCode,
  I_MaterialValuationsByPeriods.ControllingArea AS ControllingArea,
  cast (AccountingValuationView as valutyp preserving type) AS ControllingValuationType,
  Material,
  FiscalPeriodStartDate,
  FiscalPeriodEndDate,
  PostgFsclPerdCurDateRelation
FROM I_MaterialValuationsByPeriods
;

Learn More