C_DeficitCashPoolAnalytics

@EndUserText.label: 'Deficit Cash Pool'
@OData.publish: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'CDCSHPLANLYTS'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropogatedAnnotations: true
define view C_DeficitCashPoolAnalytics
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate          : sydate,
    P_ExchangeRateType : kurst,
    P_DisplayCurrency  : vdm_v_display_currency,
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language         : sylangu
  as select from P_Fclm_Deficit_Cash_Pool_Tb
                 (
                                       P_KeyDate: $parameters.P_KeyDate ,
                                       P_DisplayCurrency :$parameters.P_DisplayCurrency,
                                       P_ExchangeRateType :$parameters.P_ExchangeRateType,
                                       P_SAPClient: $session.client ) as pos
                 inner join I_CompanyCode  as _CompanyCode
                        on  pos.CompanyCode = _CompanyCode.CompanyCode
                 left outer join I_BankAccount as _BankAccount
                        on  pos.BankAccountInternalID = _BankAccount.BankAccountInternalID
                 left outer join I_Bank as _Bank
                        on  pos.Bank  = _Bank.BankInternalID and pos.BankCountry = _Bank.BankCountry
{

      @ObjectModel.text.element:  [ 'CompanyCodeName' ]
      key pos.CompanyCode,

      @ObjectModel.text.element:  [ 'BankAccountDescription' ]
      key pos.BankAccountInternalID,

     @EndUserText.label: 'Bank Account Currency'
     @Semantics.currencyCode: true
--      key cast(pos.Currency as fclm_bank_acct_currency) as BankAccountCurrency,
      key _BankAccount.BankAccountCurrency  as BankAccountCurrency,


      pos.BankAccount,
      @Semantics.text: true
      _BankAccount._Text[1:Language=$parameters.P_Language].BankAccountDescription,

      @Semantics.text: true
      _CompanyCode.CompanyCodeName,

      @ObjectModel.text.element:  [ 'BankName' ]
      pos.Bank,
      @Semantics.text: true
      _Bank.BankName,

      @ObjectModel.filter.enabled:false 
      @Semantics.currencyCode: true
      pos.DisplayCurrency,

      @ObjectModel.text.element: 'CashPoolName'
      pos.CashPool,
      @Semantics.text: true
      pos.CashPoolName,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      pos.AmountInDisplayCurrency

}