P_RTPCOrderStandardCost

@AbapCatalog.sqlViewName: 'PFIRTPCORSTDCOST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'RTPC Order Plan Cost'

@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_RTPCOrderStandardCost
  as select from acdocp          as _item
    inner join   I_MfgOrdPlngCat as _PlngCat on _item.category = _PlngCat.PlanningCategory
{
  key aufnr       as OrderID,
  key case accasty
        when 'OP' then concat( concat( 'OP', aufnr), aufps ) 
        else concat('OR', aufnr) 
      end      as ControllingObject,
  key accasty     as AccountAssignmentType,
  key aufps       as OrderItem,
  key rbukrs      as CompanyCode,
  key rldnr       as Ledger,
  key racct       as GLAccount,
  key co_belkz    as ControllingDebitCreditCode,
  key matnr       as Material,
 // key scntr       as OriginCostCenter,

 // key plstar      as OriginCostCenterActivityType,

  key  case ukostl
         when '' then scntr
         else ukostl
       end  as OriginCostCenter,
  key  case ulstar
         when '' then plstar
         else ulstar
       end  as OriginCostCenterActivityType,
  key psknz       as IsLotSzIndep,
  key hkgrp       as CostOriginGroup,
  losgr as CostingLotSize,
  rvunit as Unit,
  
  

      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
}
where
  (
       accasty                     = 'OR'
    or accasty                     = 'OP'
  )
  and  PlngCatIsForMatlCostEstPlnCost = 'X'
group by
  aufnr,
  accasty,
  aufps,
  rbukrs,
  rldnr,
  racct,
  co_belkz,
  matnr,
  scntr,
  plstar,
  ukostl,
  ulstar,
  psknz,
  losgr,
  rvunit,
  hkgrp