P_Cashflow_Base

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_Cashflow_Base.
-- 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: PCASHFLOWBASE
-- Parameters: P_Language : abap.lang

CREATE VIEW P_Cashflow_Base AS
SELECT
  flow.CompanyCode AS CompanyCode,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.Country AS Country,
  flow.LiquidityItem AS LiquidityItem,
  flow.BankAccountInternalID AS BankAccountInternalID,
  _BankAccount.BankAccountType AS BankAccountType,
  _BankAccount.Bank AS Bank,
  _BankAccount.BankAccountNumber AS BankAccount,
  _BankAccount._Text[1: Language = $parameters.P_Language].BankAccountDescription AS BankAccountDescription,
  _BankAccount.BankAccountStatus AS BankAccountStatus,
  flow.TransactionDate AS CalendarDay,
  _Date.YearWeek AS CalendarYearWeek,
  _Date.YearMonth AS CalendarYearMonth,
  _Date.YearQuarter AS CalendarYearQuarter,
  _Date.CalendarYear AS CalendarYear,
  flow.FiscalYear AS FiscalYear,
  flow._CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  flow.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  flow.PaymentMethod AS PaymentMethod,
  flow.OriginApplication AS OriginApplication,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.GLAccount AS GLAccount,
  flow.Customer AS Customer,
  flow.Supplier AS Supplier,
  flow.BusinessPartner AS BusinessPartner,
  flow.Material AS Material,
  flow.BusinessArea AS BusinessArea,
  flow.ProfitCenter AS ProfitCenter,
  flow.WBSElementInternalID AS WBSElementInternalID,
  flow.WBSElement AS WBSElement,
  flow.PartnerCompany AS PartnerCompany,
  flow.CostCenter AS CostCenter,
  flow.Segment AS Segment,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  flow.ExpirationDate AS ExpirationDate,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.SourceCompanyCode AS SourceCompanyCode,
  flow._WBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  flow._WBSElement._Project.Project AS Project
FROM I_CashFlow AS flow
LEFT OUTER JOIN I_CalendarDate AS _Date ON CalendarDay = _Date.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItem AS _LiquidityItem ON LiquidityItem = _LiquidityItem.LiquidityItem  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON CompanyCode = _GLAccount.CompanyCode AND GLAccount = _GLAccount.GLAccount  -- association [0..1]
;