P_RblsItmForKeyDteDuePerd2

@AbapCatalog.sqlViewName: 'PRBLSKDATDUE2'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RblsItmForKeyDteDuePerd2
  with parameters
    P_KeyDate    : sydate,
    P_PeriodType : fis_period_type

  as select from P_RblsItmForKeyDteDuePerd1( P_KeyDate: :P_KeyDate,
                                          P_PeriodType: :P_PeriodType )

{
  key CompanyCode,
  key AccountingDocument,
  key AccountingDocumentItem,
  key FiscalYear,
      ReportingPeriodStartDate,
      ReportingPeriodEndDate,
      InvoiceReference,
      InvoiceItemReference,
      InvoiceReferenceFiscalYear,
      ClearingDate,
      PostingDate,
      DocumentDate,
      FinancialAccountType,
      DebitCreditCode,
      Customer,
      FollowOnDocumentType,
      SpecialGLCode,
      GLAccount,
      @Semantics.currencyCode: true
      CompanyCodeCurrency,
      BusinessArea,
      
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      AmountInCompanyCodeCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      OpenDueAmountInDisplayCrcy,
      @Semantics.currencyCode: true
      DisplayCurrency,

      NetDueDate,

      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
}
where
        FollowOnDocumentType       = ''
  or    FollowOnDocumentType       = 'V'
  or    FollowOnDocumentType       = 'P'
  or    InvoiceReference           = 'V' // V is a valid invoice reference value for credit memos via e.g. transaction FB75 (see documentation of DTEL REBZG)

  or(
        InvoiceReference           = ''
    and InvoiceItemReference       = '000' // it is required to specify an invoice item reference (also for join) in contrast to documentation of DTEL REBZZ

    and InvoiceReferenceFiscalYear = '0000' // it is required to specify an invoice item reference (also for join) in contrast to documentation of DTEL REBZJ

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