P_RTPCOrderWIPReserve

@AbapCatalog.sqlViewName: 'PFIRTPCORWIPRSRV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'RTPC Order WIP Reserve'

@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_RTPCOrderWIPReserve
  as select from acdoca   as _item
    inner join   I_Ledger as _ledger on  _ledger.Ledger     = _item.rldnr
                                     and _ledger.LedgerType = '' //standard ledger only

{
  key aufnr       as OrderID,
  key aufps       as OrderItem,
  key rbukrs      as CompanyCode,
  key rldnr       as Ledger,
  key slalittype  as SubLedgerAcctLineItemType,
  key fiscyearper as FiscalYearPeriod,

      sum( hsl )  as hsl,
      sum( ksl )  as ksl,
      sum( osl )  as osl,
      sum( vsl )  as vsl,
      sum( bsl )  as bsl,
      sum( csl )  as csl,
      sum( dsl )  as dsl,
      sum( esl )  as esl,
      sum( fsl )  as fsl,
      sum( gsl )  as gsl

}
where
  (
         vorgn      = 'EBWP'
    and(
         slalittype = '09100'
      or slalittype = '09110'
    )
  )
  or(
         vorgn      = 'KOAE' // for non-event-based migrated orders

    and  rhoart     = '23'
  )

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