P_RealTimeRptdFinData_06

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

CREATE VIEW P_RealTimeRptdFinData_06 AS
SELECT
  Source.SubItemCategory AS SubItemCategory,
  Source.SubItem AS SubItem,
  Source.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  Source.BaseUnit AS BaseUnit,
  Source.QuantityInBaseUnit AS QuantityInBaseUnit,
  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.Segment AS Segment,
  Source.AmountInLocalCurrency AS AmountInLocalCurrency,
  Source.AmountInGroupCurrency AS AmountInGroupCurrency,
  Source.FinancialStatementItem AS FinancialStatementItem,
  Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  Source.ConsolidationUnitLocalCurrency AS ConsolidationUnitLocalCurrency,
  Source.ConsolidationDimension AS ConsolidationDimension,
  Source.ConsolidationUnit AS ConsolidationUnit,
  Source.ConsolidationVersion AS ConsolidationVersion,
  Source.ConsolidationLedger AS ConsolidationLedger,
  Source.GroupCurrency AS GroupCurrency,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.FiscalYear AS FiscalYear,
  _acdoca.CompanyCode AS CompanyCode,
  _acdoca.ChartOfAccounts AS ChartOfAccounts,
  _acdoca.AssignmentReference AS AssignmentReference,
  _acdoca.ControllingArea AS ControllingArea,
  _acdoca.PartnerCostCenter AS PartnerCostCenter,
  _acdoca.PartnerProfitCenter AS PartnerProfitCenter,
  _acdoca.PartnerFunctionalArea AS PartnerFunctionalArea,
  _acdoca.PartnerBusinessArea AS PartnerBusinessArea,
  _acdoca.PartnerCompany AS PartnerCompany,
  _acdoca.PartnerSegment AS PartnerSegment,
  _acdoca.OrderID AS OrderID,
  _acdoca.Customer AS Customer,
  _acdoca.Supplier AS Supplier,
  _acdoca.Material AS Material,
  _acdoca.MaterialGroup AS MaterialGroup,
  _acdoca.ProductGroup AS ProductGroup,
  _acdoca.Plant AS Plant,
  _acdoca.WBSElement AS WBSElementExternalID,
  _acdoca.WBSElement AS WBSElement,
  _acdoca.Project AS Project,
  _acdoca.BillingDocumentType AS BillingDocumentType,
  _acdoca.SalesOrganization AS SalesOrganization,
  _acdoca.DistributionChannel AS DistributionChannel,
  _acdoca.OrganizationDivision AS OrganizationDivision,
  _acdoca.SoldProduct AS SoldProduct,
  _acdoca.SoldProductGroup AS SoldProductGroup,
  _acdoca.CustomerGroup AS CustomerGroup,
  _acdoca.CustomerSupplierCountry AS CustomerSupplierCountry,
  _acdoca.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  _acdoca.SalesDistrict AS SalesDistrict,
  _acdoca.BillToParty AS BillToParty,
  _acdoca.ShipToParty AS ShipToParty,
  _acdoca.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  _acdoca.WBSElementInternalID AS WBSElementInternalID,
  _acdoca.CreationDateTime AS CreationDateTime,
  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.SourceLedger AS SourceLedger,
  Source.Ledger AS Ledger,
  Source.LedgerGLLineItem AS LedgerGLLineItem,
  Source.AccountingDocument AS AccountingDocument,
  Source.ReferenceFiscalYear AS ReferenceFiscalYear
FROM P_RealTimeRptdFinData_05
INNER JOIN I_CnsldtnUnit ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItem AS _acdoca ON /* join condition not captured in parsed metadata */
;