P_RU_VATInvoiceClearingChain2

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUVATINVCLRCH2'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_VATInvoiceClearingChain2
  as select from P_RU_VATInvoiceClearingChain1 as Level1

    inner join   P_RU_BusPartnerClearing       as Level2 on  Level2.CompanyCode                =  Level1.CompanyCode
                                                         and Level2.ClearingAccountingDocument =  Level1.ClearingAccountingDocument
                                                         and Level2.ClearingFiscalYear         =  Level1.ClearingFiscalYear
                                                         and Level2.DebitCreditCode            <> Level1.DebitCreditCode

{
  Level1.CompanyCode,
  Level1.AccountingDocument,
  Level1.FiscalYear,
  Level1.AccountingDocumentItem,
  Level1.DebitCreditCode,
  Level1.AccountType,

  Level2.ClearingAccountingDocument,
  Level2.ClearingFiscalYear,
  Level2.ClearingInformationIndex,
  Level2.ClearingInformationType,

  Level2.AccountingDocument     as ClearedAccountingDocument,
  Level2.FiscalYear             as ClearedFiscalYear,
  Level2.AccountingDocumentItem as ClearedAccountingDocumentItem,
  Level2.AccountType            as ClearedAccountType,

  '2'                           as ClearingLevel
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_RU_BUSPARTNERCLEARING",
"P_RU_VATINVOICECLEARINGCHAIN1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/