I_RO_SAFTMatlStockValue

DDL: I_RO_SAFTMATLSTOCKVALUE SQL: IROSAFTMATLVAL Type: view COMPOSITE

Material Stock Value for Romania SAFT

I_RO_SAFTMatlStockValue is a Composite CDS View that provides data about "Material Stock Value for Romania SAFT" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemRawData) and exposes 4 fields with key fields CompanyCode, Material, Plant.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemRawData I_GLAccountLineItemRawData from

Parameters (3)

NameTypeDefault
P_FromPostingDate figen_rep_date_from
P_ToPostingDate figen_rep_date_to
P_Ledger fins_ledger

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IROSAFTMATLVAL 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 #XXL view
VDM.viewType #COMPOSITE view
EndUserText.label Material Stock Value for Romania SAFT view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY Material Product
KEY Plant Plant
NetValueAmountInDocCurrency 
@AbapCatalog.sqlViewName: 'IROSAFTMATLVAL'
@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: #XXL
@VDM.viewType : #COMPOSITE
@EndUserText.label: 'Material Stock Value for Romania SAFT'
define view I_RO_SAFTMatlStockValue
  with parameters
          P_FromPostingDate            : figen_rep_date_from,
          P_ToPostingDate              : figen_rep_date_to,
          P_Ledger                     : fins_ledger
  as select from I_GLAccountLineItemRawData
{
  key CompanyCode,
  key Product as Material,
  key Plant,
  //key Supplier,

  sum( AmountInCompanyCodeCurrency ) as NetValueAmountInDocCurrency
} where SourceLedger = $parameters.P_Ledger
  and ( ReferenceDocumentType = 'PRCHG' or ReferenceDocumentType = 'RMRP'
   or ( ReferenceDocumentType = 'MKPF' and AccountingDocumentType = 'PR' ) )
  and   PostingDate between $parameters.P_FromPostingDate and $parameters.P_ToPostingDate
  //and   FinancialAccountType = 'M'

  and   TransactionTypeDetermination = 'BSX'
  group by CompanyCode, Product, Plant //, Supplier

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMRAWDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More