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,
      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 <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/