P_PSMMatDocJournalEntry

@AbapCatalog.sqlViewName: 'PPSMMATDOCJE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED

define view P_PSMMatDocJournalEntry
  as select from acdoca        as _Journal_item

    join         I_Ledger      as _Ledger      on  _Journal_item.rldnr     = _Ledger.Ledger
                                               and _Ledger.IsLeadingLedger = 'X'

    join         I_CompanyCode as _CompanyCode on  _Journal_item.rbukrs                 =  _CompanyCode.CompanyCode
                                               and _CompanyCode.FinancialManagementArea <> ''

{
  key _Journal_item.rldnr      as SourceLedger,
  key _Journal_item.rbukrs     as CompanyCode,
  key _Journal_item.gjahr      as FiscalYear,
  key _Journal_item.belnr      as AccountingDocument,
  key _Journal_item.docln      as LedgerGLLineItem,
      _Journal_item.awtyp      as ReferenceDocumentType,
      _Journal_item.awref      as ReferenceDocument,
      //cast( right(_Journal_item.awitem, 4) as nsdm_mblpo ) as ReferenceDocumentItem,

      _Journal_item.awitem     as ReferenceDocumentItem,
      _Journal_item.aworg      as ReferenceDocumentUnits,
      _Journal_item.fikrs      as FinancialManagementArea,
      _Journal_item.rfund      as Fund,
      _Journal_item.rgrant_nbr as GrantID,
      _Journal_item.rbudget_pd as BudgetPeriod,
      _Journal_item.rfarea     as FunctionalArea,
      _Journal_item.fistl      as FundsCenter,
      _Journal_item.measure    as FundedProgram
}
where
       _Journal_item.vorgn            = 'RMWE'
  and  _Journal_item.xsecondary       is initial
  and(
       _Journal_item.bdgt_cnsmpn_type = '99'
    or _Journal_item.bdgt_cnsmpn_type = '66'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_LEDGER",
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/