P_ReportedFinancialData_RT_01

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 P_ReportedFinancialData_RT_01.
-- 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: PREPFINDRT_01
-- Parameters: p_timestamp_from : timestamp, p_timestamp_to : timestamp

CREATE VIEW P_ReportedFinancialData_RT_01 AS
SELECT
  I_JournalEntryItem.SourceLedger AS rldnr_fin,
  I_JournalEntryItem.LedgerGLLineItem AS docln_fin,
  I_JournalEntryItem.CompanyCode AS robukrs,
  I_JournalEntryItem.PartnerCompany AS rassc,
  I_JournalEntryItem.PostingDate AS budat,
  I_JournalEntryItem.BalanceTransactionCurrency AS rtcur,
  I_JournalEntryItem.BaseUnit AS runit,
  I_JournalEntryItem.FiscalYear AS gjahr,
  I_JournalEntryItem.AccountingDocument AS belnr,
  I_JournalEntryItem.LedgerGLLineItem AS docln,
  I_JournalEntryItem.PartnerBusinessArea AS sbusa,
  I_JournalEntryItem.FinancialTransactionType AS rmvct,
  I_JournalEntryItem.FunctionalArea AS rfarea,
  I_JournalEntryItem.BusinessArea AS rbusa,
  I_JournalEntryItem.CostCenter AS rcntr,
  I_JournalEntryItem.GLAccount AS racct,
  I_JournalEntryItem.ProfitCenter AS prctr,
  I_JournalEntryItem.AccountingDocumentType AS blart,
  I_JournalEntryItem.AmountInBalanceTransacCrcy AS tsl,
  I_JournalEntryItem.AmountInCompanyCodeCurrency AS hsl,
  I_JournalEntryItem.AmountInGlobalCurrency AS ksl,
  I_JournalEntryItem.AmountInFreeDefinedCurrency1 AS osl,
  I_JournalEntryItem.AmountInFreeDefinedCurrency2 AS vsl,
  I_JournalEntryItem.AmountInFreeDefinedCurrency3 AS bsl,
  I_JournalEntryItem.AmountInFreeDefinedCurrency4 AS csl,
  I_JournalEntryItem.AmountInFreeDefinedCurrency5 AS dsl,
  I_JournalEntryItem.AmountInFreeDefinedCurrency6 AS esl,
  I_JournalEntryItem.AmountInFreeDefinedCurrency7 AS fsl,
  I_JournalEntryItem.AmountInFreeDefinedCurrency8 AS gsl,
  I_JournalEntryItem.Quantity AS msl,
  '' AS activ,
  I_JournalEntryItem.ReferenceDocument AS refdocnr,
  I_JournalEntryItem.FiscalYear AS refryear,
  '' AS refactiv,
  I_JournalEntryItem.AccountingDocCreatedByUser AS usnam,
  I_JournalEntryItem.ReferenceDocumentType AS awtyp,
  I_JournalEntryItem.ReferenceDocumentContext AS aworg,
  I_JournalEntryItem.LogicalSystem AS logsys,
  I_JournalEntryItem.CreationDateTime AS timestamp,
  I_JournalEntryItem.Segment AS Segment,
  tfin010.dimen AS rdimen,
  tfin010.bunit AS rbunit,
  tf200.rvers AS rvers,
  tf200.impvs AS impvs,
  I_CompanyCode.ChartOfAccounts AS ktopl,
  t881.rldnr AS rldnr,
  cast('000000000000000' as timestamp) AS const_zero,
  I_FiscalCalendarDate.FiscalPeriod AS poper,
  I_FiscalCalendarDate.FiscalYear AS ryear
FROM I_JournalEntryItem
LEFT OUTER JOIN tf165 ON /* join condition not captured in parsed metadata */
INNER JOIN I_SAPClient AS _SAPClient ON /* join condition not captured in parsed metadata */
INNER JOIN t881 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tf200 ON /* join condition not captured in parsed metadata */
;