P_RblsItmForKeyDteDuePerd1a

@AbapCatalog.sqlViewName: 'PRBLSKDATDUE1A'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RblsItmForKeyDteDuePerd1a

  // get the referenced invoices to e.g. partial payments; net due date of partial payment will then be adjusted to net due date of referenced invoice so

  //  in Analytics both items are assigned to the correct aging period and correctly summed up in this aging period for due date of invoice

  as select from I_OperationalAcctgDocItem as Receivables 
    left outer join I_OperationalAcctgDocItem as ReferencedInvoices on  Receivables.CompanyCode                = ReferencedInvoices.CompanyCode
                                                                            and Receivables.InvoiceReference           = ReferencedInvoices.AccountingDocument
                                                                            and Receivables.InvoiceItemReference       = ReferencedInvoices.AccountingDocumentItem
                                                                            and Receivables.InvoiceReferenceFiscalYear = ReferencedInvoices.FiscalYear
                                                                            and Receivables.FinancialAccountType       = ReferencedInvoices.FinancialAccountType
                                                                            and Receivables.AccountingDocumentCategory = ReferencedInvoices.AccountingDocumentCategory
//  as select from I_OperationalAcctgDocItem as Receivables 

//    left outer join I_OperationalAcctgDocItem as ReferencedInvoices on  Receivables.CompanyCode                = ReferencedInvoices.CompanyCode

//                                                                            and Receivables.InvoiceReference           = ReferencedInvoices.AccountingDocument

//                                                                            and Receivables.InvoiceItemReference       = ReferencedInvoices.AccountingDocumentItem

//                                                                            and Receivables.InvoiceReferenceFiscalYear = ReferencedInvoices.FiscalYear

//                                                                            and Receivables.FinancialAccountType       = ReferencedInvoices.FinancialAccountType

//                                                                            and Receivables.AccountingDocumentCategory = ReferencedInvoices.AccountingDocumentCategory                                                             

{
  key Receivables.CompanyCode,
  key Receivables.AccountingDocument,
  key Receivables.AccountingDocumentItem,
  key Receivables.FiscalYear,
      Receivables.InvoiceReference,
      Receivables.InvoiceItemReference,
      Receivables.InvoiceReferenceFiscalYear,
      Receivables.ClearingDate,
      Receivables.PostingDate,
      Receivables.DocumentDate,
//      Receivables.NetPaymentDays,

//      Receivables.CashDiscount2Days,

//      Receivables.CashDiscount1Days,

//      Receivables.DueCalculationBaseDate,

      Receivables.FinancialAccountType,
      Receivables.DebitCreditCode,
      Receivables.Customer,
      Receivables.FollowOnDocumentType,
      Receivables.NetDueDate,
      Receivables.SpecialGLCode,
      Receivables.GLAccount,
      Receivables.CompanyCodeCurrency,
      Receivables.FunctionalCurrency,
//      Receivables.GlobalCurrency,

      cast('EUR' as fis_rkcur ) as GlobalCurrency,
      Receivables.TransactionCurrency,
      Receivables.AmountInCompanyCodeCurrency,
      Receivables.AmountInFunctionalCurrency,
//      Receivables.AmountInGlobalCurrency,

      cast(0 as fis_ksl) as AmountInGlobalCurrency,
      Receivables.AmountInTransactionCurrency,
      Receivables.PostingKey,
      Receivables.AccountingDocumentCategory,
      Receivables.BusinessArea,
      Receivables.FiscalPeriod, 
      Receivables.IsUsedInPaymentTransaction,
      
//      cast( '00000000' as fis_bldat ) as RefInvcDocumentDate,

//      cast( '' as farp_koart )  as RefInvcFinancialAccountType,

//      cast( '' as fis_shkzg ) as RefInvcDebitCreditCode,

//      cast( 0 as farp_dzbd3t ) as RefInvcNetPaymentDays,

//      cast( 0 as farp_dzbd2t ) as RefInvcCashDiscount2Days,

//      cast( 0 as farp_dzbd1t ) as RefInvcCashDiscount1Days,

//      cast( '00000000' as fis_dzfbdt ) as RefInvcDueCalculationBaseDate,

//      cast( '' as farp_rebzg ) as RefInvcInvoiceReference,

//      cast( '00000000' as farp_netdt ) as RefInvcNetDueDate


      ReferencedInvoices.DocumentDate                            as RefInvcDocumentDate,
      ReferencedInvoices.FinancialAccountType                    as RefInvcFinancialAccountType,
      ReferencedInvoices.DebitCreditCode                         as RefInvcDebitCreditCode,
      ReferencedInvoices.NetPaymentDays                          as RefInvcNetPaymentDays,
      ReferencedInvoices.CashDiscount2Days                       as RefInvcCashDiscount2Days,
      ReferencedInvoices.CashDiscount1Days                       as RefInvcCashDiscount1Days,
      ReferencedInvoices.DueCalculationBaseDate                  as RefInvcDueCalculationBaseDate,
      ReferencedInvoices.InvoiceReference                        as RefInvcInvoiceReference,
      ReferencedInvoices.NetDueDate                              as RefInvcNetDueDate
}
where Receivables.FinancialAccountType = 'D'
  and Receivables.AccountingDocumentCategory =  ''