I_CshFlwFcstComprnTimeStamp

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_CshFlwFcstComprnTimeStamp.
-- 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: ISNAPCOMPARESS
-- Parameters: P_StartDate : sydate, P_EndDate : sydate, P_CashFlowForecastStartDate : sydate, P_CashFlowForecastEndDate : sydate, P_Language : sylangu, P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_CashFlowSnapshotTime1 : syuzeit, P_CashFlowSnapshotTime2 : syuzeit

CREATE VIEW I_CshFlwFcstComprnTimeStamp AS
SELECT
  sapclient,
  Language,
  CashFlow,
  OriginDocument,
  BankAccountInternalID,
  snapshotdate AS CashFlowSnapshotDate,
  CalendarDate,
  CalendarDay,
  WeekDay,
  TransactionDate,
  _BankAccount.Bank AS Bank,
  _BankAccount.BankAccountNumber AS BankAccount,
  _BankAccount.BankAccountType AS BankAccountType,
  _BankAccount.BankCountry AS BankCountry,
  _BankAccountText.BankAccountDescription AS BankAccountDescription,
  _BankGroupInfo.BankHeadquarter AS BankGroup,
  _BankGroupInfo.BankHeadquarterName AS BankGroupName,
  BankAccountCurrency,
  BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  CertaintyLevel,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  TransactionCurrency,
  GLAccount,
  HouseBank,
  HouseBankAccount,
  LiquidityItem,
  _LiquidityItem.CashFlowDirection AS CashFlowDirection,
  _LiquidityItemText.LiquidityItemName AS LiquidityItemName,
  planninggroup AS CashPlanningGroup,
  _CashPlanningGroupText.CashPlanningGroupName AS CashPlanningGroupName,
  PlanningLevel,
  _PlanningLevelText.PlanningLevelName AS PlanningLevelName,
  ProfitCenter,
  Segment,
  TradingPartner,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  AmountInTransactionCurrency1,
  AmountInTransactionCurrency2,
  AmountInTransactionCurrency3
FROM P_FCLM_SNAPSHOTCOMPARSION_SS
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountText AS _BankAccountText ON BankAccountInternalID = _BankAccountText.BankAccountInternalID AND Language = _BankAccountText.Language  -- association [0..1]
LEFT OUTER JOIN I_BankAccountWithBGN AS _BankGroupInfo ON BankAccountInternalID = _BankGroupInfo.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItem AS _LiquidityItem ON LiquidityItem = _LiquidityItem.LiquidityItem  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItemText AS _LiquidityItemText ON LiquidityItem = _LiquidityItemText.LiquidityItem AND Language = _LiquidityItemText.Language  -- association [0..1]
LEFT OUTER JOIN I_CashPlanningGroup AS _CashPlanningGroup ON CashPlanningGroup = _CashPlanningGroup.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_CashPlanningGroupText AS _CashPlanningGroupText ON CashPlanningGroup = _CashPlanningGroupText.CashPlanningGroup AND Language = _CashPlanningGroupText.Language  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _PlanningLevel ON PlanningLevel = _PlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON PlanningLevel = _PlanningLevelText.PlanningLevel AND Language = _PlanningLevelText.Language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND Language = _BusinessAreaText.Language  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_WeekDay AS _WeekDay ON WeekDay = _WeekDay.WeekDay  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON CalendarDate = _CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
;