I_Liquidityforecastdetails

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 I_Liquidityforecastdetails.
-- 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: ILIQFOREDETAILS
-- Parameters: P_StartDate : sydate, P_EndDate : sydate, P_Language : sylangu, P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_Liquidityforecastdetails AS
SELECT
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  TransactionCurrency AS Currency,
  LiquidityItem,
  _LiquidityItem.CashFlowDirection AS CashFlowDirection,
  BankAccountInternalID,
  Bank,
  BankAccountType,
  BankAccount,
  BankAccountDescription,
  BankAccountStatus,
  BusinessArea,
  BusinessPartner,
  ControllingArea,
  CostCenter,
  Country,
  Customer,
  HouseBank,
  HouseBankAccount,
  CashPlanningGroup,
  PlanningLevel,
  ProfitCenter,
  Segment,
  PartnerCompany,
  Supplier,
  WBSElement,
  SourceCompanyCode,
  ResponsibleCostCenter,
  Project,
  $parameters.P_StartDate AS CalendarDay,
  DomainValueName,
  CertaintyLevel,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  P_EndDate: $parameters.P_EndDate AS P_EndDate
FROM P_Liquidityforecast_Overdueday
LEFT OUTER JOIN P_Cashflow_Base ON /* join condition not captured in parsed metadata */
INNER JOIN I_Liquidityforecast_Flowtype AS flowtype ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_Liquidityforecast_Daterange, P_Liquidityforecast_Future
;