P_RTPCOrderPostedVariance

@AbapCatalog.sqlViewName: 'PFIRTPCORPOVARC'
@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_RTPCOrderPostedVariance
  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 aufnr_org      as Origin_OrderID,
  key aufps          as OrderItem,
  key rldnr          as Ledger,
  key slalittype     as SubLedgerAcctLineItemType,
  key varc_uacct     as OriginGLAccount,
  key umatnr         as OriginMaterial,
  key ukostl         as OriginCostCenter,
  key ulstar         as OriginCostCenterActivityType,
  key varc_hkgrp     as CostOriginGroup,
  key rrunit         as Unit,
  key paobjnr        as ProfitabilitySegment,
  key fiscyearper    as FiscalYearPeriod,
      xreversed,
      xreversing,
      

      sum(_item.msl) as ValuationQuantity,

      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,
      sum( kfsl )    as kfsl,
      sum( vmsl )    as vmsl,
      sum( rmsl )    as rmsl

}
where

       bttype     = 'EBVP'
  and(
       slalittype = '09130'
    or slalittype = '09131'
    or slalittype = '09132'
    or slalittype = '09139'
    or slalittype = '09138'
    or slalittype = '09140'
  )

group by
  aufnr,
  aufnr_org,
  aufps,
  rldnr,
  slalittype,
  varc_uacct,
  umatnr,
  ukostl,
  ulstar,
  varc_hkgrp,
  rrunit,
  paobjnr,
  fiscyearper,
  xreversed,
  xreversing
  
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/