P_PlanData_RT_05

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

CREATE VIEW P_PlanData_RT_05 AS
SELECT
  case when tf103a_subit.BreakdownType = '0' or tf103a_subit.BreakdownType is null then '' when tf103a_subit.BreakdownType = '1' or tf103a_subit.BreakdownType = '4' then Source.SubItem when tf103a_subit.BreakdownType = '2' or tf103a_subit.BreakdownType = '3' then case Source.SubItem when '' then coalesce(tf040_subit.CnsldtnSubassignmentValue,'') else Source.SubItem end end as SubItem AS SubItemendendasSubItem,
  case when tf103a_runit.BreakdownType = '0' or tf103a_runit.BreakdownType is null then '' when tf103a_runit.BreakdownType = '3' then case Source.BaseUnit when '' then coalesce(tf103a_runit.BreakdownCategoryFixedValue, '') else Source.BaseUnit end end as BaseUnit AS BaseUnitendendasBaseUnit,
  Source.SubItemCategory AS SubItemCategory,
  Source.CnsldtnSubitemSource AS CnsldtnSubitemSource,
  Source.BreakdownCategory AS BreakdownCategory,
  Source.FinancialStatementItem AS FinancialStatementItem,
  Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  Source.ConsolidationUnitLocalCurrency AS ConsolidationUnitLocalCurrency,
  Source.CnsldtnUnitLocalCrcySource AS CnsldtnUnitLocalCrcySource,
  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,
  Source.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  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.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.FinancialManagementArea AS FinancialManagementArea,
  Source.GrantID AS GrantID,
  Source.Fund AS Fund,
  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
FROM P_PlanData_RT_04
;