P_RealTimeRptdFinData_02

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_02.
-- 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_02
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW P_RealTimeRptdFinData_02 AS
SELECT
  I_FSItemMappingAssgmtWithVers.FinancialStatementItem AS FinancialStatementItem,
  I_FSItemMappingAssgmtWithVers.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  coalesce(tfin010.bunit,'') AS PartnerConsolidationUnit,
  P_ConsolidationUnitCurrency.curr AS ConsolidationUnitLocalCurrency,
  P_ConsolidationUnitCurrency.curr_local_send AS CnsldtnUnitLocalCrcySource,
  Source.ConsolidationDimension AS ConsolidationDimension,
  Source.ConsolidationUnit AS ConsolidationUnit,
  Source.ConsolidationVersion AS ConsolidationVersion,
  Source.ConsolidationLedger AS ConsolidationLedger,
  Source.GroupCurrency AS GroupCurrency,
  Source.CnsldtnUnitGroupCrcySource AS CnsldtnUnitGroupCrcySource,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.FiscalYear AS FiscalYear,
  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.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Source.AmountInLocalCurrency AS AmountInLocalCurrency,
  Source.AmountInGroupCurrency AS AmountInGroupCurrency,
  Source.QuantityInBaseUnit AS QuantityInBaseUnit,
  Source.osl AS osl,
  Source.vsl AS vsl,
  Source.bsl AS bsl,
  Source.csl AS csl,
  Source.dsl AS dsl,
  Source.esl AS esl,
  Source.fsl AS fsl,
  Source.gsl AS gsl,
  Source.Segment AS Segment,
  Source.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  Source.FinancialServicesBranch AS FinancialServicesBranch,
  Source.FinancialDataSource AS FinancialDataSource,
  Source.FinancialManagementArea AS FinancialManagementArea,
  Source.GrantID AS GrantID,
  Source.Fund AS Fund,
  Source.PartnerFund AS PartnerFund,
  Source.CashLedgerAccount AS CashLedgerAccount,
  Source.CnsldtnCashLedgerChartOfAccts AS CnsldtnCashLedgerChartOfAccts,
  Source.CompanyCode AS CompanyCode,
  Source.SourceLedger AS SourceLedger,
  Source.Ledger AS Ledger,
  Source.LedgerGLLineItem AS LedgerGLLineItem,
  Source.AccountingDocument AS AccountingDocument,
  Source.ReferenceFiscalYear AS ReferenceFiscalYear
FROM P_RealTimeRptdFinData_01
INNER JOIN P_ConsolidationUnitCurrency ON /* join condition not captured in parsed metadata */
;