P_RblsItmForKeyDtePerd1_WSJ

@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity  P_RblsItmForKeyDtePerd1_WSJ
  as select from I_OperationalAcctgDocItem
{
  key CompanyCode,
  key AccountingDocument,
  key AccountingDocumentItem,
  key FiscalYear,
      InvoiceReference,
      InvoiceItemReference,
      InvoiceReferenceFiscalYear,
      ClearingDate,
      PostingDate,
      DocumentDate,
      FinancialAccountType,
      DebitCreditCode,
      Customer,
      FollowOnDocumentType,
      NetDueDate,
      SpecialGLCode,
      GLAccount,
      CompanyCodeCurrency         as DisplayCurrency,
      CompanyCodeCurrency,
      FunctionalCurrency,
      TransactionCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      AmountInCompanyCodeCurrency as OpenDueAmountInDisplayCrcy,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      AmountInCompanyCodeCurrency,
      AccountingDocumentCategory,
      AmountInFunctionalCurrency,
      AmountInTransactionCurrency,
      PostingKey,
      IsUsedInPaymentTransaction,
      BusinessArea,
      FiscalPeriod
}

where
  // receivables

       FinancialAccountType       =  'D'
  and  AccountingDocumentCategory =  ''
  and  IsUsedInPaymentTransaction =  ' '
  and  FollowOnDocumentType       <> ''
  and  FollowOnDocumentType       <> 'V'
  and  FollowOnDocumentType       <> 'P'
  and  InvoiceReference           <> 'V' // V is a valid invoice reference value for credit memos via e.g. transaction FB75 (see documentation of DTEL REBZG)

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

    or InvoiceReferenceFiscalYear <> '0000'
  )