P_ActualBalFlowDateFunc

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_ActualBalFlowDateFunc.
-- 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_ActualBalFlowDateFunc AS
SELECT
  cast( 'A' as fis_actual_plan_code preserving type ) AS ActualPlanCode,
  cast( 'ACT01 ' as fcom_category preserving type ) AS PlanningCategory,
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  P_FiscalDateFunctionValueFY.DateFunction AS DateFunction,
  I_GLAccountLineItem.FiscalYearPeriod AS FiscalYearPeriod,
  cast(cast( '2 ' as abap.char(10) ) as fis_glaccount_flow_type preserving type ) AS GLAccountFlowType,
  I_GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItem.PostingDate AS PostingDate,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.BusinessArea AS BusinessArea,
  I_GLAccountLineItem.Segment AS Segment,
  I_GLAccountLineItem.Product AS Product,
  I_GLAccountLineItem.ProductGroup AS ProductGroup,
  I_GLAccountLineItem.SoldProduct AS SoldProduct,
  I_GLAccountLineItem.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItem.Customer AS Customer,
  I_GLAccountLineItem.CustomerGroup AS CustomerGroup,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_GLAccountLineItem.SalesDocument AS SalesDocument,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_GLAccountLineItem._GlobalCurrency AS _GlobalCurrency,
  I_GLAccountLineItem._FiscalCalendarDate AS _FiscalCalendarDate,
  I_GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts
FROM I_GLAccountLineItem
INNER JOIN P_FiscalDateFunctionValueFY ON /* join condition not captured in parsed metadata */
;