P_PlanData_RT_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_PlanData_RT_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: PPLANDATA_01

CREATE VIEW P_PlanData_RT_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,
  tf200.rvers AS ConsolidationVersion,
  tf200.impvs AS FSItemMappingVersion,
  I_CompanyCode.ChartOfAccounts AS ReferenceChartOfAccounts,
  t881.rldnr AS ConsolidationLedger,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.LedgerFiscalYear AS FiscalYear,
  cast(Source.FiscalYearPeriod as fins_fyearperiod) AS FiscalYearPeriod,
  Source.PartnerCompany AS PartnerCompany,
  Source.TransactionCurrency AS BalanceTransactionCurrency,
  Source.CostSourceUnit 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.AmountInCompanyCodeCurrency AS AmountInLocalCurrency,
  Source.AmountInGlobalCurrency AS AmountInGroupCurrency,
  Source.ValuationQuantity 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.FinancialManagementArea AS FinancialManagementArea,
  Source.GrantID AS GrantID,
  Source.Fund AS Fund,
  Source.FinPlngEntryItemCrtnDateTime AS FinPlngEntryItemCrtnDateTime,
  Source.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Source.CompanyCodeCurrency AS CompanyCodeCurrency,
  Source.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Source.GlobalCurrency AS GlobalCurrency,
  Source.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  Source.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  Source.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  cast('000000000000000' as timestamp) AS const_zero
FROM I_FinancialPlanningEntryItem AS Source
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tfin010 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tf165 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tf200 ON /* join condition not captured in parsed metadata */
INNER JOIN I_SAPClient AS _SAPClient ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t881 ON /* join condition not captured in parsed metadata */
;