I_RO_SAFTMatlValuationHistory

DDL: I_RO_SAFTMATLVALUATIONHISTORY SQL: IROSAFTMATLHIST Type: view COMPOSITE

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.

2 data source(s) 7 fields

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
KEY Plant _MatValHist ValuationArea
KEY YearMonth
KEY CompanyCode I_CompanyCode CompanyCode
Currency I_CompanyCode Currency
TotalValStockQuantity _MatValHist TotalValStockQuantity
StockValueInCCCrcy _MatValHist StockValueInCCCrcy 
@AbapCatalog.sqlViewName: 'IROSAFTMATLHIST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking : #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType : #COMPOSITE
@EndUserText.label: 'Material Value History for Romania SAFT'
define view I_RO_SAFTMatlValuationHistory as select distinct from I_MaterialValuationHist as _MatValHist
  inner join I_ValuationArea as _ValuationArea on _MatValHist.ValuationArea = _ValuationArea.ValuationArea
  inner join I_CompanyCode as _CompanyCode on _CompanyCode.CompanyCode = _ValuationArea.CompanyCode
{
  key _MatValHist.Material as Material,
  key _MatValHist.ValuationArea as Plant,
  key cast( concat( _MatValHist.FiscalYearCurrentPeriod, _MatValHist.FiscalMonthCurrentPeriod ) as vdm_yearmonth ) as YearMonth,
  key _CompanyCode.CompanyCode as CompanyCode,
      _CompanyCode.Currency as Currency,
      _MatValHist.TotalValStockQuantity as TotalValStockQuantity,
      @Semantics.amount.currencyCode: 'Currency'
      _MatValHist.StockValueInCCCrcy as StockValueInCCCrcy,
      case _MatValHist.MaterialPriceControl
        when 'V'
          then _MatValHist.MovingAveragePrice
        when 'S'
          then _MatValHist.StandardPrice
        else 0
      end as MovingAveragePriceInCoCodeCrcy
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_MATERIALVALUATIONHIST",
"I_VALUATIONAREA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More