P_DisplayCurrencyMaterialGroup

DDL: P_DISPLAYCURRENCYMATERIALGROUP SQL: PDSPCRCYMATLGRP Type: view CONSUMPTION

Display currency used for Material Group related Spends(PUC)

P_DisplayCurrencyMaterialGroup is a Consumption CDS View that provides data about "Display currency used for Material Group related Spends(PUC)" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 2 fields with key field MaterialGroup.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PDSPCRCYMATLGRP view
EndUserText.label Display currency used for Material Group related Spends(PUC) view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MaterialGroup I_MaterialGroup MaterialGroup
MaterialGroupDisplayCurrency I_SAPClient GroupCurrency 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PDSPCRCYMATLGRP' 
@EndUserText.label: 'Display currency used for Material Group related Spends(PUC)'
define view P_DisplayCurrencyMaterialGroup 
as select from  I_SAPClient   join I_MaterialGroup on MaterialGroup = MaterialGroup
{
    key I_MaterialGroup.MaterialGroup,
    I_SAPClient.GroupCurrency as MaterialGroupDisplayCurrency
}


//  as select from I_PurchaseOrderItem

//

//{

//  key  I_PurchaseOrderItem.MaterialGroup,    

//  max(I_PurchaseOrderItem.Currency) as MaterialGroupDisplayCurrency 

//

//} 

//where I_PurchaseOrderItem.Currency <> '' and I_PurchaseOrderItem.MaterialGroup <> ''

//group by I_PurchaseOrderItem.MaterialGroup    

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

Learn More