P_RTPCOrderCostDistribution

@AbapCatalog.sqlViewName: 'PFIRTPCORDCSTD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_RTPCOrderCostDistribution
  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 objnr               as ControllingObject,
  key rcntr               as CostCenter,
  key rldnr               as Ledger,
  key racct               as GLAccount,
  key matnr               as Material,
  key ukostl              as OriginCostCenter,
  key ulstar              as OriginActivityType,
  key fiscyearper         as FiscalYearPeriod,
  key paufnr              as PartnerOrder,
  key paufps              as PartnerOrderItem,
      //key ps_posid    as WBSElement,//PS_POSID/PS_PSPID?

  key ps_psp_pnr          as WBSElement,
  key hkgrp               as CostOriginGroup,
  key ucb_id              as ComponentBreakdown,
      ucb_scale_numerator as CompBreakdownScaleNumerator,
      autyp               as OrderCategory,
      ktosl               as TransactionTypeDetermination,
      co_beknz            as ControllingObjectDebitType,
      rbukrs              as CompanyCode,
      uspob               as SourceObject,
      werks               as Plant,
      rvunit              as UnitOfMeasure,
      parob1              as PartnerObject,
      runit               as EntryUnitOfMeasure,
      accasty             as AccountAssignmentType,
      paccasty            as PartnerAccountAssignmentType,
      bttype              as BusinessTransactionType,


      hsl,
      ksl,
      osl,
      vsl,
      bsl,
      csl,
      dsl,
      esl,
      fsl,
      gsl,
      kfsl,
      vmsl,
      msl
}

where
  (
       autyp  =  '10'
    or autyp  =  '40'
    or pautyp =  '10' //For other receiver distributed cost

    or pautyp =  '40'
  )
  and  objnr  <> ''