P_IntApportnmntBasic

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_IntApportnmntBasic.
-- 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: PINTAPPRTMTBASIC
-- Parameters: P_PoolID : psm_pool_id, P_Year : num4, P_Period : num2

CREATE VIEW P_IntApportnmntBasic AS
SELECT
  GLAcctLineItem.CompanyCode AS CompanyCode,
  GLAcctLineItem.Fund AS Fund,
  GLAcctLineItem.GrantID AS GrantID,
  GLAcctLineItem.ProfitCenter AS ProfitCenter,
  GLAcctLineItem.Segment AS Segment,
  _IntrstApprtmt.InvestmentPooledFund AS InvestmentPooledFund,
  $parameters.P_Year AS PYear,
  $parameters.P_Period AS PPeriod,
  _PrtcpntAccts.InvestmentPoolUUID AS InvestmentPoolUUID,
  GLAcctLineItem.ChartOfAccounts AS ChartOfAccounts,
  GLAcctLineItem.FinancialManagementArea AS FinancialManagementArea,
  GLAcctLineItem.ControllingArea AS ControllingArea,
  GLAcctLineItem.GLAccount AS InvestmentParticipantAccount,
  GLAcctLineItem.PostingDate AS PostingDate,
  case when ( _CalendarDateByPostingDate.CalendarMonth = $parameters.P_Period and GLAcctLineItem.AccountingDocumentCategory <> 'C' ) then _CalendarDateByPostingDate.CalendarDay else '00' end as PoolDay AS CalendarDayelse00endasPoolDay,
  _CalendarYearMonth.NumberOfDays AS LastDay,
  GLAcctLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  GLAcctLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  GLAcctLineItem._ChartOfAccounts AS _ChartOfAccounts,
  GLAcctLineItem._CompanyCode AS _CompanyCode,
  GLAcctLineItem._FinancialManagementArea AS _FinancialManagementArea,
  GLAcctLineItem._ControllingArea AS _ControllingArea,
  GLAcctLineItem._Fund AS _Fund,
  GLAcctLineItem._Grant AS _Grant,
  GLAcctLineItem._Segment AS _Segment,
  GLAcctLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  GLAcctLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency
FROM I_GLAccountLineItem AS GLAcctLineItem
INNER JOIN I_PubSecPrtcpntAccts AS _PrtcpntAccts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProfitCenter AS _RealProfitCenter ON ControllingArea = _RealProfitCenter.ControllingArea AND ProfitCenter = _RealProfitCenter.ProfitCenter AND PostingDate >= _RealProfitCenter.ValidityStartDate AND PostingDate <= _RealProfitCenter.ValidityEndDate  -- association [1..1]
;