P_REALTIMERPTDFINDATA_TN

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

CREATE VIEW P_REALTIMERPTDFINDATA_TN AS
SELECT
  Source.ConsolidationRecordNumber AS gl_sirid,
  Source.ConsolidationLedger AS rldnr,
  Source.ConsolidationVersion AS rvers,
  Source.FiscalYear AS ryear,
  Source.TransactionCurrency AS rtcur,
  Source.BaseUnit AS runit,
  Source.FiscalPeriod AS poper,
  Source.ConsolidationDimension AS rdimen,
  Source.ConsolidationUnit AS rbunit,
  Source.ConsolidationChartOfAccounts AS ritclg,
  Source.FinancialStatementItem AS ritem,
  Source.PartnerConsolidationUnit AS rbuptr,
  Source.CompanyCode AS robukrs,
  Source.SubItemCategory AS sityp,
  Source.SubItem AS subit,
  Source.AmountInTransactionCurrency AS tsl,
  Source.AmountInLocalCurrency AS hsl,
  Source.AmountInGroupCurrency AS ksl,
  Source.QuantityInBaseUnit AS msl,
  Source.ChartOfAccounts AS ktopl,
  Source.LocalCurrency AS rhcur,
  Source.GroupCurrency AS rkcur,
  Source.GLAccount AS racct,
  Source.AssignmentReference AS zuonr,
  Source.CostCenter AS rcntr,
  Source.ProfitCenter AS prctr,
  Source.FunctionalArea AS rfarea,
  Source.BusinessArea AS rbusa,
  Source.ControllingArea AS kokrs,
  Source.Segment AS segment,
  Source.PartnerCostCenter AS scntr,
  Source.PartnerProfitCenter AS pprctr,
  Source.PartnerFunctionalArea AS sfarea,
  Source.PartnerBusinessArea AS sbusa,
  Source.PartnerCompany AS rassc,
  Source.PartnerSegment AS psegment,
  Source.OrderID AS aufnr,
  Source.Customer AS kunnr,
  Source.Supplier AS lifnr,
  Source.Material AS matnr,
  Source.MaterialGroup AS matkl_mm,
  Source.Plant AS werks,
  Source.FinancialTransactionType AS rmvct,
  Source.WBSElementExternalID AS ps_posid,
  Source.Project AS ps_pspid,
  Source.BillingDocumentType AS fkart,
  Source.SalesOrganization AS vkorg,
  Source.DistributionChannel AS vtweg,
  Source.OrganizationDivision AS spart,
  Source.SoldProduct AS matnr_copa,
  Source.SoldProductGroup AS matkl,
  Source.CustomerGroup AS kdgrp,
  Source.CustomerSupplierCountry AS land1,
  Source.CustomerSupplierIndustry AS brsch,
  Source.SalesDistrict AS bzirk,
  Source.BillToParty AS kunre,
  Source.ShipToParty AS kunwe,
  Source.CustomerSupplierCorporateGroup AS konzs,
  Source.WBSElementInternalID AS ps_psp_pnr,
  Source.CreationDateTime AS timestamp,
  cast(I_CnsldtnDocumentType.ConsolidationDocumentType as fc_docty) AS docty,
  Source.SourceLedger AS rldnr_fin,
  cast(Source.AccountingDocument as belnr_d) AS docnr,
  cast(Source.LedgerGLLineItem as docln6) AS docln,
  cast(Source.ReferenceFiscalYear as gjahr) AS refryear,
  cast(CONCAT(Source.FiscalYear, Source.FiscalPeriod) as fis_jahrper_conv ) AS fiscyearper,
  cast(Source.FiscalPeriod as updhp) AS updhp,
  cast(_acdoca.PostingDate as budat) AS budat,
  cast(_acdoca.ReferenceDocument as belnr_d) AS refdocnr,
  cast(substring(cast(_acdoca.CreationDateTime as abap.char(19)), 1, 8) as cpudt) AS cpudt,
  cast(substring(cast(_acdoca.CreationDateTime as abap.char(19)),5,6) as cputm) AS cputm,
  cast(_acdoca.ReferenceDocumentType as awtyp) AS awtyp,
  cast(_acdoca.ReferenceDocumentContext as aworg) AS aworg,
  cast(_acdoca.LogicalSystem as logsys) AS logsys,
  cast(_acdoca.AccountingDocCreatedByUser as usnam) AS usnam,
  cast(_acdoca.PostingDate as wsdat) AS wsdat,
  cast('000000' as buzei6) AS refdocln,
  cast('0' as rrcty) AS rrcty,
  cast('0' as fc_rtflg) AS rtflg,
  cast(' ' as shkzg) AS drcrk,
  cast(' ' as fc_coicu) AS coicu,
  cast(' ' as stblg) AS rvsdocnr,
  cast('0000' as fc_revyear) AS revyear,
  cast('0000' as fc_ryacq) AS yracq,
  cast(' ' as sgtxt) AS sgtxt,
  cast(' ' as autom) AS autom,
  cast(' ' as fc_congr) AS rcongr,
  cast(' ' as bvorg) AS bvorg,
  cast(' ' as fc_coiac) AS coiac,
  cast(' ' as stbln) AS orndocnr,
  cast(' ' as fc_plevl) AS plevl,
  cast('W' as docct) AS refdocct,
  cast('A' as docct) AS docct,
  cast(' ' as fc_coinr) AS coinr,
  cast('' as glvor) AS refactiv,
  cast('' as glvor) AS activ,
  cast('0' as fc_rpflg) AS rpflg,
  cast(' ' as rcomp_d) AS rcomp,
  cast('000' as rpacq) AS pracq,
  cast('' as xblnr1) AS xblnr,
  cast('' as fc_uppcu) AS uppcu,
  cast('' as data_temperature ) AS _dataaging
FROM P_RealTimeRptdFinData
INNER JOIN I_JournalEntryItem AS _acdoca ON /* join condition not captured in parsed metadata */
;