P_RTPCOrderDistributedCost

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

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

{
  key _item.aufnr as OrderID,
  key objnr       as ControllingObject,
  key aufps       as OrderItem,
  key rbukrs      as CompanyCode,
  key rldnr       as Ledger,
  key racct       as GLAccount,
  //key gkont       as OffsetAccount,

  key co_belkz    as ControllingDebitCreditCode,
  key _item.matnr as Material,
  key ukostl      as OriginCostCenter,
  key ulstar      as OriginCostCenterActivityType,
  key fiscyearper as FiscalYearPeriod,
  key hkgrp       as CostOriginGroup,
      uspob       as SourceObject,
      segment     as segment,
      //hrkft       as COSubkey,

      werks       as Plant,
      rvunit      as UnitOfMeasure,

      hsl,
      ksl,
      osl,
      vsl,
      bsl,
      csl,
      dsl,
      esl,
      fsl,
      gsl,
      kfsl,
      vmsl,
      rmsl
}
where
  (
       //       accasty        =  'OR'

       accasty  =  'OP'
  )
  and  bttype   <> 'TBCS' --ignore Transaction-Based Split
  and  bttype   <> 'EBWP' --ignore Event-Based WIP posting
  and(
       autyp    =  '10'
    or autyp    =  '40'
  )
  //and  aufnr    <> paufnr //exclude pre-settlement

  //and  co_belnr <> ''

  and  co_beknz =  'S'

//group by

//  aufnr,

//  objnr,

//  aufps,

//  rbukrs,

//  rldnr,

//  racct,

//  co_belkz,

//  matnr,

//  ukostl,

//  ulstar,

//  fiscyearper,

//  rvunit