I_CashFlowDetailedAnalysisCube

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_CashFlowDetailedAnalysisCube.
-- 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: ICASHFDAC
-- Parameters: P_StartDate : sydate, P_EndDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_KeyDate : vdm_v_key_date

CREATE VIEW I_CashFlowDetailedAnalysisCube AS
SELECT
  flow.BankAccountInternalID AS BankAccountInternalID,
  flow.BusinessPartner AS BusinessPartner,
  flow.BusinessArea AS BusinessArea,
  flow.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.Country AS Country,
  flow.CostCenter AS CostCenter,
  flow.Customer AS Customer,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.LiquidityItem AS LiquidityItem,
  _LiquidityItem.CashFlowDirection AS CashFlowDirection,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  flow.ProfitCenter AS ProfitCenter,
  flow.Segment AS Segment,
  flow.TradingPartner AS PartnerCompany,
  flow.Supplier AS Supplier,
  flow.WBSElement AS WBSElement,
  _WBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  _WBSElement.ProjectInternalID AS ProjectInternalID,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.TransactionCurrency AS TransactionCurrency,
  flow.OriginalTransactionCurrency AS OriginalCurrency,
  flow.SourceCompanyCode AS SourceCompanyCode,
  flow.CalendarDay AS CalendarDay,
  '' AS PostingPeriod,
  flow.CashOut AS CashOut,
  flow.CashIn AS CashIn,
  flow.CashIn + flow.CashOut AS CashNet,
  :P_DisplayCurrency AS DisplayCurrency,
  flow.CashOutConverted AS CashOutConverted,
  flow.CashInConverted AS CashInConverted,
  flow.CashInConverted + flow.CashOutConverted AS CashNetConverted
FROM P_CashFlowDetailedAnalysis
LEFT OUTER JOIN I_LiquidityItem AS _LiquidityItem ON LiquidityItem = _LiquidityItem.LiquidityItem  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _SourceCompanyCode ON SourceCompanyCode = _SourceCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CashPlanningGroup AS _CashPlanningGroup ON CashPlanningGroup = _CashPlanningGroup.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _PlanningLevel ON PlanningLevel = _PlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON controllingarea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_Country AS _Country ON country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON controllingarea = _ControllingArea.ControllingArea  -- association [0..1]
;