C_TH_StRpCashFlowLqdyItemQuery

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 C_TH_StRpCashFlowLqdyItemQuery.
-- 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: CTHSRCASHLQITMQ
-- Parameters: P_LiquidityItemHierarchy : fclm_hier_name, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_ComprnFromPostingDate : fis_comprn_budat_from, P_ComprnToPostingDate : fis_comprn_budat_to, P_HistoryDateTime : timestampl, P_DisplayCurrency : vdm_v_display_currency, P_Language : sylangu, P_ExchangeRateType : kurst_curr, P_ExchangeRateDate : vdm_v_exchange_rate_date

CREATE VIEW C_TH_StRpCashFlowLqdyItemQuery AS
SELECT
  _LiquidityItem._Text[1: Language = :P_Language].LiquidityItemName AS LiquidityItemName,
  LiquidityItem,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  DisplayCurrency,
  PeriodBalAmtInDspCrcy,
  ComprnPerdBalAmtInDspCrcy,
  GLAccount,
  BankAccountInternalID,
  BusinessArea,
  BusinessPartner,
  CertaintyLevel,
  ControllingArea,
  CostCenter,
  Country,
  HouseBank,
  HouseBankAccount,
  CashPlanningGroup,
  PlanningLevel,
  ProfitCenter,
  Segment,
  TradingPartner,
  WBSElement,
  CashFlowDirection
FROM I_StRpCashFlowLqdyItemCube
;