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 I_GLAccountLineItemRawData   as _item
    inner join   I_Ledger as _ledger on  _ledger.Ledger     = _item.SourceLedger
                                     and _ledger.LedgerType = '' //standard ledger only

{
  key ControllingObject                  as ObjectNumber,
  key OrderID,
  key OrderItem,
  key SourceLedger                  as Ledger,

      sum(AmountInCompanyCodeCurrency)              as AmountInCompanyCodeCurrency,
      sum(AmountInGlobalCurrency)              as AmountInGlobalCurrency,
      sum(AmountInFreeDefinedCurrency1)              as AmountInFreeDefinedCurrency1,
      sum(AmountInFreeDefinedCurrency2)              as AmountInFreeDefinedCurrency2,
      sum(AmountInFreeDefinedCurrency3)              as AmountInFreeDefinedCurrency3,
      sum(AmountInFreeDefinedCurrency4)              as AmountInFreeDefinedCurrency4,
      sum(AmountInFreeDefinedCurrency5)              as AmountInFreeDefinedCurrency5,
      sum(AmountInFreeDefinedCurrency6)              as AmountInFreeDefinedCurrency6,
      sum(AmountInFreeDefinedCurrency7)              as AmountInFreeDefinedCurrency7,
      sum(AmountInFreeDefinedCurrency8)              as AmountInFreeDefinedCurrency8

}
where

  OriginObjectType = '23'
//  and 

//  ( bttype      = 'EBWP'

//  or bttype      = 'KOAE'

//  )


group by
  ControllingObject,
  OrderID,
  OrderItem,
  SourceLedger