P_PL_ExcessDelayAccountingItem

@AbapCatalog.sqlViewName: 'PEDACTITM'
@AbapCatalog.compiler.compareFilter: true
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Accounting data for Customer and Vendor'
define view P_PL_ExcessDelayAccountingItem

  as select from I_StRpJournalEntryTaxItemLog as StRpJournalEntryTaxItemLog
    inner join   I_OperationalAcctgDocItem    as OperationalAcctgDocItem

    on  OperationalAcctgDocItem.CompanyCode            = StRpJournalEntryTaxItemLog.CompanyCode
    and OperationalAcctgDocItem.AccountingDocument     = StRpJournalEntryTaxItemLog.AccountingDocument
    and OperationalAcctgDocItem.FiscalYear             = StRpJournalEntryTaxItemLog.FiscalYear
    and OperationalAcctgDocItem.AccountingDocumentItem = StRpJournalEntryTaxItemLog.TaxItem

{
  key StRpJournalEntryTaxItemLog.StatryRptgEntity                  as StatryRptgEntity,
  key StRpJournalEntryTaxItemLog.StatryRptCategory                 as StatryRptCategory,
  key StRpJournalEntryTaxItemLog.StatryRptRunID                    as StatryRptRunID,
  key OperationalAcctgDocItem.CompanyCode                          as CompanyCode,
  key OperationalAcctgDocItem.FiscalYear                           as FiscalYear,
  key OperationalAcctgDocItem.AccountingDocument                   as AccountingDocument,
  key OperationalAcctgDocItem.AccountingDocumentItem               as AccountingDocumentItem,
      OperationalAcctgDocItem.ClearingJournalEntry                 as ClearingJournalEntry,
      OperationalAcctgDocItem._JournalEntry.AccountingDocumentType as AccountingDocumentType,
      OperationalAcctgDocItem.DebitCreditCode                      as DebitCreditCode,
      OperationalAcctgDocItem.AmountInCompanyCodeCurrency          as AmountInCompanyCodeCurrency,
      OperationalAcctgDocItem.CompanyCodeCurrency                  as CompanyCodeCurrency,
      OperationalAcctgDocItem.Supplier                             as Supplier,
      OperationalAcctgDocItem.Customer                             as Customer,
      OperationalAcctgDocItem.DocumentDate                         as DocumentDate,
      OperationalAcctgDocItem.PostingDate                          as PostingDate,
      OperationalAcctgDocItem.DueCalculationBaseDate               as DueCalculationBaseDate,
      OperationalAcctgDocItem.NetDueDate                           as NetDueDate,
      OperationalAcctgDocItem.ClearingDate                         as ClearingDate,
      OperationalAcctgDocItem._JournalEntry.InvoiceReceiptDate     as InvoiceReceiptDate,
      OperationalAcctgDocItem._JournalEntry.DocumentReferenceID    as DocumentReferenceID,
      OperationalAcctgDocItem.DocumentItemText                     as DocumentItemText,
      OperationalAcctgDocItem.InvoiceReference                     as InvoiceReference,
      OperationalAcctgDocItem.InvoiceItemReference                 as InvoiceItemReference,
      OperationalAcctgDocItem.InvoiceReferenceFiscalYear           as InvoiceReferenceFiscalYear,
      OperationalAcctgDocItem.FollowOnDocumentType                 as FollowOnDocumentType,
      OperationalAcctgDocItem.PaymentTerms                         as PaymentTerms,
      OperationalAcctgDocItem.CashDiscount1Days                    as CashDiscount1Days,
      OperationalAcctgDocItem.CashDiscount2Days                    as CashDiscount2Days,
      OperationalAcctgDocItem.NetPaymentDays                       as NetPaymentDays,
      OperationalAcctgDocItem.CashDiscount1Percent                 as CashDiscount1Percent,
      OperationalAcctgDocItem.CashDiscount2Percent                 as CashDiscount2Percent,
      OperationalAcctgDocItem.AssignmentReference                  as AssignmentReference,
      OperationalAcctgDocItem.IsUsedInPaymentTransaction           as IsUsedInPaymentTransaction,

      case
        when OperationalAcctgDocItem.Customer is not initial and
             OperationalAcctgDocItem.Customer is not null
          then 'C'
        when OperationalAcctgDocItem.Supplier is not initial and
             OperationalAcctgDocItem.Supplier is not null
          then 'V'
      end as CustomerSupplier
}




/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM",
"I_STRPJOURNALENTRYTAXITEMLOG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/