P_NoTrdgPartIntcoJrnlEntr

@AbapCatalog.sqlViewName: 'PGRCNTRPINTCOJE'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'No Trading Partner Intercompany JE'
define view P_NoTrdgPartIntcoJrnlEntr

  with parameters
    @Consumption.valueHelpDefinition: [
            { entity:  { name:    'I_LedgerStdVH',
                         element: 'Ledger' }
            }]
    @EndUserText.label: 'Ledger'
    P_Ledger : rldnr

  as select from I_GLAccountLineItemRawData
{
      @Consumption.valueHelpDefinition: [{ entity:  { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } }]
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,

      @ObjectModel.foreignKey.association: '_FiscalYear'
  key FiscalYear,

      @Consumption.valueHelpDefinition: [{ entity:  { name: 'I_JournalEntryStdVH', element: 'AccountingDocument' }, additionalBinding: [{ localElement: 'CompanyCode', element: 'CompanyCode' }, { localElement: 'FiscalYear', element: 'FiscalYear' }] }]
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key AccountingDocument,

      @ObjectModel.foreignKey.association: '_Ledger'
  key cast(SourceLedger as rldnr preserving type ) as Ledger,

      count(*)           as P_NumberOfTradingPartner,

      _CompanyCode,
      _FiscalYear,
      _JournalEntry,
      _Ledger
}

where
      PartnerCompany <> ''
  and SourceLedger = $parameters.P_Ledger

group by
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  SourceLedger
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEMRAWDATA"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_FISCALYEARFORCOMPANYCODE",
"I_JOURNALENTRY",
"I_LEDGER"
],
"BASE":
[
"I_GLACCOUNTLINEITEMRAWDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/