P_RealTimeMfgOrdWIPBalance

@AbapCatalog.sqlViewName: 'PRTWIPB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true

define view P_RealTimeMfgOrdWIPBalance 
as select from acdoca   as _item
    inner join   I_Ledger as _ledger on  _ledger.Ledger     = _item.rldnr
                                     and _ledger.LedgerType = '' //standard ledger only

{
  key objnr                   as ObjectNumber,
  key aufnr                   as OrderID,
  key aufps                   as OrderItem,
  key rldnr                   as Ledger,

      sum(hsl)                as AmountInCompanyCodeCurrency,
      sum(ksl)                as AmountInGlobalCurrency,
      sum(osl)                as AmountInFreeDefinedCurrency1,
      sum(vsl)                as AmountInFreeDefinedCurrency2,
      sum(bsl)                as AmountInFreeDefinedCurrency3,
      sum(csl)                as AmountInFreeDefinedCurrency4,
      sum(dsl)                as AmountInFreeDefinedCurrency5,
      sum(esl)                as AmountInFreeDefinedCurrency6,
      sum(fsl)                as AmountInFreeDefinedCurrency7,
      sum(gsl)                as AmountInFreeDefinedCurrency8

}
where

  rhoart = '23'
//  and 

//  ( bttype      = 'EBWP'

//  or bttype      = 'KOAE'

//  )


group by
  objnr,
  aufnr,
  aufps,
  rldnr
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/