P_CashFlowDetailedAnalysis

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

CREATE VIEW P_CashFlowDetailedAnalysis AS
SELECT
  flow.BankAccountInternalID AS BankAccountInternalID,
  flow.BusinessPartner AS BusinessPartner,
  flow.BusinessArea AS BusinessArea,
  flow.CompanyCode AS CompanyCode,
  flow.CostCenter AS CostCenter,
  flow._CompanyCode.ControllingArea AS ControllingArea,
  flow.Customer AS Customer,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.LiquidityItem AS LiquidityItem,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  flow.ProfitCenter AS ProfitCenter,
  flow.Segment AS Segment,
  flow.PartnerCompany AS TradingPartner,
  flow.Supplier AS Supplier,
  flow._WBSElement.WBSElement AS WBSElement,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.BankAccountCurrency AS TransactionCurrency,
  flow.TransactionCurrency AS OriginalTransactionCurrency,
  flow._CompanyCode.Country AS CompanyCountry,
  flow.SourceCompanyCode AS SourceCompanyCode,
  flow.TransactionDate AS CalendarDay,
  flow.FiscalYear AS FiscalYear,
  flow._CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  '' AS PostingPeriod,
  flow.ExpirationDate AS ExpirationDate
FROM I_CashFlow AS flow
;