P_RepFinData_RT_Aggr_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_RepFinData_RT_Aggr_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: PRFDRTAG_02
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW P_RepFinData_RT_Aggr_02 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.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,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  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.PartnerCompany AS PartnerCompany,
  Source.CompanyCode AS CompanyCode,
  Source.ChartOfAccounts AS ChartOfAccounts,
  Source.AssignmentReference AS AssignmentReference,
  Source.ControllingArea AS ControllingArea,
  Source.PartnerCostCenter AS PartnerCostCenter,
  Source.PartnerProfitCenter AS PartnerProfitCenter,
  Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  Source.PartnerBusinessArea AS PartnerBusinessArea,
  Source.PartnerSegment AS PartnerSegment,
  Source.OrderID AS OrderID,
  Source.Customer AS Customer,
  Source.Supplier AS Supplier,
  Source.Material AS Material,
  Source.MaterialGroup AS MaterialGroup,
  Source.ProductGroup AS ProductGroup,
  Source.Plant AS Plant,
  Source.WBSElementExternalID AS WBSElementExternalID,
  Source.Project AS Project,
  Source.BillingDocumentType AS BillingDocumentType,
  Source.SalesOrganization AS SalesOrganization,
  Source.DistributionChannel AS DistributionChannel,
  Source.OrganizationDivision AS OrganizationDivision,
  Source.SoldProduct AS SoldProduct,
  Source.SoldProductGroup AS SoldProductGroup,
  Source.CustomerGroup AS CustomerGroup,
  Source.CustomerSupplierCountry AS CustomerSupplierCountry,
  Source.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  Source.SalesDistrict AS SalesDistrict,
  Source.BillToParty AS BillToParty,
  Source.ShipToParty AS ShipToParty,
  Source.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  Source.WBSElementInternalID AS WBSElementInternalID,
  Source.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,
  _CashLedgerCompanyCode.ChartOfAccounts AS CnsldtnCashLedgerChartOfAccts
FROM P_RepFinData_RT_Aggr_01
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 */
LEFT OUTER JOIN I_CompanyCode AS _CashLedgerCompanyCode ON _CashLedgerCompanyCode.CompanyCode = Source.CashLedgerCompanyCode  -- association [0..1]
;