I_Ftr_Cl_Key_Date_Utilization

DDL: I_FTR_CL_KEY_DATE_UTILIZATION SQL: ICLKEYDATEUTIL Type: view COMPOSITE

Facility Utilization by Key Date

I_Ftr_Cl_Key_Date_Utilization is a Composite CDS View (Cube) that provides data about "Facility Utilization by Key Date" in SAP S/4HANA. It reads from 2 data sources (I_FinancialTransaction, P_Ftr_Cl_Keydate_Utilization) and exposes 11 fields with key fields CompanyCode, FinancialTransaction, KeyDate. It has 1 association to related views.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_FinancialTransaction FinancialTransaction inner
P_Ftr_Cl_Keydate_Utilization Utilization from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICLKEYDATEUTIL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Facility Utilization by Key Date view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_Ftr_Cl_Keydate_Utilization CompanyCode
KEY FinancialTransaction P_Ftr_Cl_Keydate_Utilization FinancialTransaction
KEY KeyDate
FinancialInstrumentProductType I_FinancialTransaction FinancialInstrumentProductType
FinancialInstrTransactionType I_FinancialTransaction FinancialInstrTransactionType
Portfolio I_FinancialTransaction Portfolio
TransactionCurrency P_Ftr_Cl_Keydate_Utilization TransactionCurrency
TotalAmountInTransactionCrcy
UtilizedAmountInTransCrcy
AvailableAmountInTransCrcy
_TransactionCurrency _TransactionCurrency 
@AbapCatalog.sqlViewName: 'ICLKEYDATEUTIL'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@EndUserText.label: 'Facility Utilization by Key Date'
@Analytics: { dataCategory: #CUBE }
@Metadata.allowExtensions:true
define view I_Ftr_Cl_Key_Date_Utilization
  as select from P_Ftr_Cl_Keydate_Utilization as Utilization
    inner join   I_FinancialTransaction       as FinancialTransaction on  FinancialTransaction.CompanyCode          = Utilization.CompanyCode
                                                                      and FinancialTransaction.FinancialTransaction = Utilization.FinancialTransaction
  association [1..1] to I_Currency as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency
{
  key Utilization.CompanyCode,
  key Utilization.FinancialTransaction,
  key cast(Utilization.FacilityDate as vdm_v_key_date)       as KeyDate,
      //Utilization.RelatObject,

      FinancialTransaction.FinancialInstrumentProductType,
      FinancialTransaction.FinancialInstrTransactionType,
      FinancialTransaction.Portfolio,
      
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      @Semantics.currencyCode: true
      Utilization.TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @DefaultAggregation: #SUM
      sum(Utilization.TotalAmount)                           as TotalAmountInTransactionCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @DefaultAggregation: #SUM
      sum(Utilization.UtilizedChangeAmount)                  as UtilizedAmountInTransCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @DefaultAggregation: #SUM
      sum(Utilization.AvailableAmount)                       as AvailableAmountInTransCrcy,

      _TransactionCurrency
}
group by
  Utilization.CompanyCode,
  Utilization.FinancialTransaction,
  FinancialTransaction.FinancialInstrumentProductType,
  FinancialTransaction.FinancialInstrTransactionType,
  FinancialTransaction.Portfolio,
  Utilization.FacilityDate,
  Utilization.TransactionCurrency

Learn More