I_RecurringJournalEntry

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_RecurringJournalEntry.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IRECRRGJE

CREATE VIEW I_RecurringJournalEntry AS
SELECT
  bukrs AS RecrrgAcctgDocCompanyCode,
  belnr AS RecurringJournalEntry,
  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
FROM bkdf
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON RecrrgAcctgDocCompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_RecurrenceRunSchedule AS _RecurrenceRunSchedule ON RecurrenceSchedule = _RecurrenceRunSchedule.RecurrenceSchedule  -- association [1..1]
;