P_RTPCOrderProdDelievedCost

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

@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_RTPCOrderProdDelievedCost
  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 objnr       as ControllingObject,
  key rbukrs      as CompanyCode,
  key rldnr       as Ledger,
  key racct       as GLAccount,
  key co_beknz    as ControllingDebitCreditCode,
  key matnr       as Material,
  key fiscyearper as FiscalYearPeriod,

      rvunit      as ValuationUnit,
      runit       as Unit,
      xsettled    as IsSettled,

      hsl,
      ksl,
      osl,
      vsl,
      bsl,
      csl,
      dsl,
      esl,
      fsl,
      gsl,
      kfsl,
      vmsl,
      msl
}
where
  (
       accasty  =  'OR'
    or accasty  =  'OP'
  )
  and  ktosl    =  'GBB'
  and  co_beknz =  'L'
  and  bttype   <> 'TBCS' --ignore Transaction-Based Split
  and(
       autyp    =  '10'
    or autyp    =  '40'
  )
  and  objnr    <> ''