I_RO_SAFTMatlValuationHistory

DDL: I_RO_SAFTMATLVALUATIONHISTORY SQL: IROSAFTMATLHIST Type: view COMPOSITE Package: GLO_LOG_SAFT_RO
8 Fields 3 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 3 data sources (I_CompanyCode, I_MaterialValuationHist, I_ValuationArea) and exposes 8 fields with key fields Material, Plant, ValuationType, YearMonth, CompanyCode. Part of development package GLO_LOG_SAFT_RO.

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode _CompanyCode inner
I_MaterialValuationHist _MatValHist from
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 (8)

KeyFieldSource TableSource FieldDescription
KEY Material I_MaterialValuationHist Material Vehicle Model
KEY Plant I_MaterialValuationHist ValuationArea Valuation Area
KEY ValuationType I_MaterialValuationHist ValuationType Valuation Type
KEY YearMonth
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
Currency I_CompanyCode Currency Valuation Crcy
TotalValStockQuantity I_MaterialValuationHist TotalValStockQuantity Total Stock
StockValueInCCCrcy I_MaterialValuationHist 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,
  _MatValHist.ValuationType AS ValuationType,
  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
FROM I_MaterialValuationHist AS _MatValHist
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