P_SFINRECURRINGJOURNALENTRY

CDS View

SFIN Recurring Journal Entry

P_SFINRECURRINGJOURNALENTRY is a CDS View in S/4HANA. SFIN Recurring Journal Entry. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_RecrrgJournalEntryAttribute view_entity from CONSUMPTION Recurring Journal Entry Attributes
P_SFINRecurringToJournalEntry view_entity inner BASIC SFIN Recurring Journal Entry

Fields (5)

KeyField CDS FieldsUsed in Views
KEY RecrrgAcctgDocCompanyCode RecrrgAcctgDocCompanyCode 1
KEY RecrrgJournalEntryFiscalYear RecrrgJournalEntryFiscalYear 1
KEY RecurringAccountingDocument RecurringAccountingDocument 1
RecurrenceEndDate RecurrenceEndDate 1
RecurrenceStartDate RecurrenceStartDate 1 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SFIN Recurring Journal Entry'
@ObjectModel:{
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #M,
  usageType.dataClass: #TRANSACTIONAL }
@VDM.viewType: #BASIC  
@VDM.private: true
define view entity P_SFINRecurringJournalEntry
  as select from bkdf
{
  key bukrs               as RecrrgAcctgDocCompanyCode,
  key belnr               as RecurringAccountingDocument,
  key gjahr               as RecrrgJournalEntryFiscalYear,
      dbmon               as RecurrenceFrequencyType,
      dbtag               as RecurrenceRunDayOfMonth,
      dbbdt               as RecurrenceStartDate,
      dbatr               as RecurrenceNextCalculationDate,
      dbedt               as RecurrenceEndDate,
      xdelt               as RecrrgJournalEntryIsCompleted,
      dbzhl               as NumberOfCompletedRecurrences,
      dbakz               as RecurrenceSchedule,
      xfwhw               as AmountInNonTransCrcyIsTrnsfd,
      xsfhw               as TaxAmtInNonTransCrcyIsTrnsfd,
      xbllt               as RecrrgJournalEntryTextIsTrnsfd,
      recurrence_type     as RecurrenceType,
      frequency           as RecurrenceFrequency,
      occur_day_type      as OccurrenceType,
      occur_day           as OccurrenceDayByRecurrenceType,
      first_occur_date    as FirstOccurrenceDate,
      end_by_type         as RecurrenceEndType,
      last_occur_date     as LastOccurrenceDate,
      number_of_occur     as NumberOfRecurrences,
      blocked_for_posting as PostingIsBlocked,
      recur_schedule_used as RecurrenceScheduleIsUsed,
      lognumber           as ApplicationLog
}
where
  created_in_sfin = 'X'

Learn More