P_RealTimeRptdFinData_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_RealTimeRptdFinData_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: PREALTIMERFD_01
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW P_RealTimeRptdFinData_01 AS
SELECT
  case when t881.curt2 = '30' then _SAPClient.GroupCurrency else t881.gcurr end as GroupCurrency AS gcurrendasGroupCurrency,
  tfin010.dimen AS ConsolidationDimension,
  tfin010.bunit AS ConsolidationUnit,
  I_CompanyCode.ChartOfAccounts AS ReferenceChartOfAccounts,
  I_CnsldtnVersion.ConsolidationVersion AS ConsolidationVersion,
  I_CnsldtnVersion.FSItemMappingVersion AS FSItemMappingVersion,
  tf168.curr_group_send AS CnsldtnUnitGroupCrcySource,
  t881.rldnr AS ConsolidationLedger,
  I_FiscalCalendarDate.FiscalPeriod AS FiscalPeriod,
  I_FiscalCalendarDate.FiscalYear AS FiscalYear,
  I_FiscalCalendarDate.FiscalYearPeriod AS FiscalYearPeriod,
  Source.PartnerCompany AS PartnerCompany,
  Source.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  Source.BaseUnit AS BaseUnit,
  Source.FinancialTransactionType AS FinancialTransactionType,
  Source.FunctionalArea AS FunctionalArea,
  Source.BusinessArea AS BusinessArea,
  Source.CostCenter AS CostCenter,
  Source.GLAccount AS GLAccount,
  Source.ProfitCenter AS ProfitCenter,
  Source.AmountInBalanceTransacCrcy AS AmountInTransactionCurrency,
  Source.AmountInCompanyCodeCurrency AS AmountInLocalCurrency,
  Source.AmountInGlobalCurrency AS AmountInGroupCurrency,
  Source.Quantity AS QuantityInBaseUnit,
  Source.AmountInFreeDefinedCurrency1 AS osl,
  Source.AmountInFreeDefinedCurrency2 AS vsl,
  Source.AmountInFreeDefinedCurrency3 AS bsl,
  Source.AmountInFreeDefinedCurrency4 AS csl,
  Source.AmountInFreeDefinedCurrency5 AS dsl,
  Source.AmountInFreeDefinedCurrency6 AS esl,
  Source.AmountInFreeDefinedCurrency7 AS fsl,
  Source.AmountInFreeDefinedCurrency8 AS gsl,
  Source.Segment AS Segment,
  Source.CompanyCode AS CompanyCode,
  Source.SourceLedger AS SourceLedger,
  Source.Ledger AS Ledger,
  Source.LedgerGLLineItem AS LedgerGLLineItem,
  Source.AccountingDocument AS AccountingDocument,
  Source.FiscalYear AS ReferenceFiscalYear
FROM I_JournalEntryItem AS Source
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN tfin010 ON /* join condition not captured in parsed metadata */
INNER 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 */
INNER JOIN I_CnsldtnVersion ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalCalendarDate ON /* join condition not captured in parsed metadata */
;