C_LU_SAFTBusPartActBalanceC

@AbapCatalog.sqlViewName: 'CLUSAFTBUPACBAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'SAFT LU Bus Part Act Balance - Cube'
define view C_LU_SAFTBusPartActBalanceC
  with parameters
    P_FromPostingDate :dats,
    P_ToPostingDate   :dats,
    P_FiscalYear      :gjahr
    
   as select from I_SAFTAccountBalance(   P_FromPostingDate:  $parameters.P_FromPostingDate ,
                                          P_ToPostingDate:    $parameters.P_ToPostingDate ,
                                          P_FiscalYear:       $parameters.P_FiscalYear ) as Balance
                                              
//  as select from P_LU_SAFTGLBALANCE9( P_FromPostingDate:  $parameters.P_FromPostingDate ,

//                                              P_ToPostingDate:    $parameters.P_ToPostingDate ) as Balance



        inner join   I_LU_SAFTGenericSettings  as GenSettings  on  GenSettings.CompanyCode = Balance.CompanyCode
                                                           and GenSettings.FiscalYearFrom <= Balance.FiscalYear
                                                           and GenSettings.FiscalYearTo   >= Balance.FiscalYear
                                                           and GenSettings.Ledger          = Balance.Ledger     

{
  key cast(concat(Balance.CompanyCode, concat('_', Balance.GLAccount)) as abap.char(70)) as SAFTGeneralLedgerAccountID,

  key Balance.Ledger,
//      @ObjectModel.foreignKey.association: '_CompanyCode'

  key Balance.CompanyCode,
//      @ObjectModel.foreignKey.association: '_ChartOfAccounts'

  key Balance.ChartOfAccounts,
//      @ObjectModel.foreignKey.association: '_GLAccountInCompanyCode'

  key Balance.GLAccount,
      //

      //  key GLBP.VATRegistration,

      @Semantics.currencyCode:true
      CompanyCodeCurrency,

      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      case when StartingBalanceAmtInCoCodeCrcy >= 0
        then StartingBalanceAmtInCoCodeCrcy
        else 0
      end                                                                                as DebitStartingBalAmtInCCCrcy,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      case when StartingBalanceAmtInCoCodeCrcy < 0
        then abs( StartingBalanceAmtInCoCodeCrcy )
        else 0
      end                                                                                as CreditStartingBalAmtInCCCrcy,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      case when EndingBalanceAmtInCoCodeCrcy >= 0
        then EndingBalanceAmtInCoCodeCrcy
        else 0
      end                                                                                as DebitEndingBalAmtInCCCrcy,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      case when EndingBalanceAmtInCoCodeCrcy < 0
       then abs( EndingBalanceAmtInCoCodeCrcy )
        else 0
      end                                                                                as CreditEndingBalAmtInCCCrcy
//      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

//      debitamountincocodecrcy                                                            as DebitAmountInCoCodeCrcy,

//      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

//      creditamountincocodecrcy                                                           as CreditAmountInCoCodeCrcy,

//      

//      _ChartOfAccounts,

//      _CompanyCode,

//      _GLAccountInCompanyCode

//      

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