I_NO_SAFTBUSPARTACCTBALANCE

CDS View

BP Account Balance for SAFT Norway

I_NO_SAFTBUSPARTACCTBALANCE is a CDS View in S/4HANA. BP Account Balance for SAFT Norway. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_NO_SAFTBusPartAcctBalanceC view_entity from CONSUMPTION SAFT Norway BP Account Balance - Cube 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'BP Account Balance for SAFT Norway'

define view entity I_NO_SAFTBusPartAcctBalance
  with parameters
    P_FromPostingDate : dats,
    P_ToPostingDate   : dats,
    P_FiscalYear      : gjahr

  as select from           I_NO_SAFTBusPartAcctBalanceEnd( P_ToPostingDate: $parameters.P_ToPostingDate,
                                                           P_FiscalYear: $parameters.P_FiscalYear)        as end_bal

    left outer to one join I_NO_SAFTBusPartAcctBalanceMvt( P_FromPostingDate: $parameters.P_FromPostingDate,
                                                           P_ToPostingDate: $parameters.P_ToPostingDate ) as bal_mov on  bal_mov.Ledger      = end_bal.Ledger
                                                                                                                     and bal_mov.CompanyCode = end_bal.CompanyCode
                                                                                                                     and bal_mov.Customer    = end_bal.Customer
                                                                                                                     and bal_mov.Supplier    = end_bal.Supplier
                                                                                                                     and bal_mov.FiscalYear  = end_bal.FiscalYear
                                                                                                                     and bal_mov.GLAccount   = end_bal.GLAccount
{
  key end_bal.Ledger,
  key end_bal.CompanyCode,
  key end_bal.Customer,
  key end_bal.Supplier,
  key end_bal.FiscalYear,
  key end_bal.GLAccount,

      end_bal.CompanyCodeCurrency,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      cast(case
        when bal_mov.DebitAmountInCoCodeCrcy is not null and bal_mov.CreditAmountInCoCodeCrcy is not null
          then ((end_bal.DebitAmountInCoCodeCrcy + end_bal.CreditAmountInCoCodeCrcy)-(bal_mov.DebitAmountInCoCodeCrcy + bal_mov.CreditAmountInCoCodeCrcy))
        else (end_bal.DebitAmountInCoCodeCrcy + end_bal.CreditAmountInCoCodeCrcy)
      end as abap.curr(23,2) )                                             as StartingBalanceAmtInCoCodeCrcy,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      (end_bal.DebitAmountInCoCodeCrcy + end_bal.CreditAmountInCoCodeCrcy) as EndingBalanceAmtInCoCodeCrcy
}

Learn More