PCashOpeningBalance

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 PCashOpeningBalance.
-- 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: FCLMCASHBAL
-- Parameters: P_StartDate : vdm_v_start_date, P_KeyDate : vdm_v_key_date

CREATE VIEW PCashOpeningBalance AS
SELECT
  openingBal.CompanyCode AS CompanyCode,
  _CompanyCode._Country.Country AS CompanyCountry,
  _PlanningUnit.PlanningUnit AS PlanningUnit,
  'LP_CASHOP' AS LiquidityItem,
  openingBal.BankAccountCurrency AS Currency,
  openingBal.OpeningBalAmtInBankAcctCrcy AS OpeningBalance,
  openingBal.TransactionDate AS TransactionDate,
  _Date.YearMonth AS CalMonth,
  _Date.YearQuarter AS CalQuarter,
  _Date.YearWeek AS CalWeek,
  _Date.CalendarYear AS CalYear,
  _CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  '' AS FiscalYear,
  '' AS PostingPeriod,
  openingBal._BankAccount.BankAccountNumber AS AccNum,
  openingBal._BankAccount.Bank AS Bank,
  openingBal._BankAccount.BankCountry AS BankCountry
FROM I_OpeningBalanceBkAcctCrcy
LEFT OUTER JOIN I_CalendarDate AS _Date ON TransactionDate = _Date.CalendarDate  -- association [0..1]
LEFT OUTER JOIN PActivePlanningUnit AS _PlanningUnit ON CompanyCode = _PlanningUnit.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;