P_Liquidityforecast_Future

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_Liquidityforecast_Future.
-- 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: P_LFFUTURE
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_Language : sylangu, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW P_Liquidityforecast_Future AS
SELECT
  flow.CompanyCode AS CompanyCode,
  flowtype.DomainValueName AS DomainValueName,
  flow.ControllingArea AS ControllingArea,
  flow.Country AS Country,
  flow._CompanyCode AS _CompanyCode,
  flow.LiquidityItem AS LiquidityItem,
  flow._LiquidityItem AS _LiquidityItem,
  flow.BankAccountInternalID AS BankAccountInternalID,
  flow.TransactionCurrency AS TransactionCurrency,
  flow.OriginalTransactionCurrency AS OriginalTransactionCurrency,
  flow.BankAccountType AS BankAccountType,
  flow.Bank AS Bank,
  flow.BankAccount AS BankAccount,
  flow.BankAccountDescription AS BankAccountDescription,
  flow.BankAccountStatus AS BankAccountStatus,
  flow._BankAccount AS _BankAccount,
  sum(flow.AmountInTransactionCurrency) AS AmountInTransactionCurrency,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.GLAccount AS GLAccount,
  flow._GLAccount AS _GLAccount,
  flow.Customer AS Customer,
  flow.Supplier AS Supplier,
  flow.BusinessPartner AS BusinessPartner,
  flow.BusinessArea AS BusinessArea,
  flow.ProfitCenter AS ProfitCenter,
  flow.WBSElementInternalID AS WBSElementInternalID,
  flow.WBSElement AS WBSElement,
  flow._WBSElement AS _WBSElement,
  flow.PartnerCompany AS PartnerCompany,
  flow.CostCenter AS CostCenter,
  flow.Segment AS Segment,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow._CashPlanningGroup AS _CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  flow._PlanningLevel AS _PlanningLevel,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.SourceCompanyCode AS SourceCompanyCode,
  flow.ResponsibleCostCenter AS ResponsibleCostCenter,
  flow.Project AS Project
FROM P_Cashflow_Base
LEFT OUTER JOIN I_Liquidityforecast_Flowtype AS flowtype ON /* join condition not captured in parsed metadata */
;