I_RO_SAFTMatlValuationHistory

DDL: I_RO_SAFTMATLVALUATIONHISTORY SQL: IROSAFTMATLHIST Type: view COMPOSITE
7 Fields 2 Data Sources

Material Value History for Romania SAFT

I_RO_SAFTMatlValuationHistory is a Composite CDS View that provides data about "Material Value History for Romania SAFT" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_ValuationArea) and exposes 7 fields with key fields Material, Plant, YearMonth, CompanyCode.

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode _CompanyCode inner
I_ValuationArea _ValuationArea inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IROSAFTMATLHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
EndUserText.label Material Value History for Romania SAFT view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Material _MatValHist Material Vehicle Model
KEY Plant _MatValHist ValuationArea Valuation Area
KEY YearMonth
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
Currency I_CompanyCode Currency Valuation Crcy
TotalValStockQuantity _MatValHist TotalValStockQuantity Total Stock
StockValueInCCCrcy _MatValHist StockValueInCCCrcy Total Value

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_RO_SAFTMatlValuationHistory.
-- 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: IROSAFTMATLHIST

CREATE VIEW I_RO_SAFTMatlValuationHistory AS
SELECT
  _MatValHist.Material AS Material,
  _MatValHist.ValuationArea AS Plant,
  cast( concat( _MatValHist.FiscalYearCurrentPeriod, _MatValHist.FiscalMonthCurrentPeriod ) as vdm_yearmonth ) AS YearMonth,
  _CompanyCode.CompanyCode AS CompanyCode,
  _CompanyCode.Currency AS Currency,
  _MatValHist.TotalValStockQuantity AS TotalValStockQuantity,
  _MatValHist.StockValueInCCCrcy AS StockValueInCCCrcy
INNER JOIN I_ValuationArea AS _ValuationArea ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS _CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More