P_PlanBalFlowDateFunc

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_PlanBalFlowDateFunc.
-- 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.

CREATE VIEW P_PlanBalFlowDateFunc AS
SELECT
  cast( 'P' as fis_actual_plan_code preserving type ) AS ActualPlanCode,
  I_FinancialPlanningEntryItem.PlanningCategory AS PlanningCategory,
  I_FinancialPlanningEntryItem.Ledger AS Ledger,
  I_FinancialPlanningEntryItem.CompanyCode AS CompanyCode,
  P_FiscalDateFunctionValueFY.DateFunction AS DateFunction,
  I_FinancialPlanningEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  cast(cast( '2 ' as abap.char(10) ) as fis_glaccount_flow_type preserving type ) AS GLAccountFlowType,
  I_FinancialPlanningEntryItem.FiscalYearVariant AS FiscalYearVariant,
  I_FinancialPlanningEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_FinancialPlanningEntryItem.FiscalYear AS FiscalYear,
  I_FinancialPlanningEntryItem.FiscalPeriod AS FiscalPeriod,
  I_FinancialPlanningEntryItem.PostingDate AS PostingDate,
  I_FinancialPlanningEntryItem.ChartOfAccounts AS ChartOfAccounts,
  I_FinancialPlanningEntryItem.GLAccount AS GLAccount,
  I_FinancialPlanningEntryItem.ControllingArea AS ControllingArea,
  I_FinancialPlanningEntryItem.CostCenter AS CostCenter,
  I_FinancialPlanningEntryItem.ProfitCenter AS ProfitCenter,
  I_FinancialPlanningEntryItem.FunctionalArea AS FunctionalArea,
  I_FinancialPlanningEntryItem.BusinessArea AS BusinessArea,
  I_FinancialPlanningEntryItem.Segment AS Segment,
  I_FinancialPlanningEntryItem.Product AS Product,
  I_FinancialPlanningEntryItem.ProductGroup AS ProductGroup,
  I_FinancialPlanningEntryItem.SoldProduct AS SoldProduct,
  I_FinancialPlanningEntryItem.SoldProductGroup AS SoldProductGroup,
  I_FinancialPlanningEntryItem.Customer AS Customer,
  I_FinancialPlanningEntryItem.CustomerGroup AS CustomerGroup,
  I_FinancialPlanningEntryItem.OrderID AS OrderID,
  I_FinancialPlanningEntryItem.SalesDocument AS SalesDocument,
  cast( ' ' as md_supplier preserving type ) AS Supplier,
  I_FinancialPlanningEntryItem.GlobalCurrency AS GlobalCurrency,
  I_FinancialPlanningEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_FinancialPlanningEntryItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_FinancialPlanningEntryItem._GlobalCurrency AS _GlobalCurrency,
  I_FinancialPlanningEntryItem._FiscalCalendarDate AS _FiscalCalendarDate,
  I_FinancialPlanningEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_FinancialPlanningEntryItem._FiscalYearVariant AS _FiscalYearVariant
FROM I_FinancialPlanningEntryItem
INNER JOIN P_FiscalDateFunctionValueFY ON /* join condition not captured in parsed metadata */
;