I_PubSecIntrstApprtmt

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 I_PubSecIntrstApprtmt.
-- 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: IPSMINTAPPRTMT

CREATE VIEW I_PubSecIntrstApprtmt AS
SELECT
  pool_uuid AS InvestmentPoolUUID,
  pool_id AS InvestmentPoolID,
  pooled_fund AS InvestmentPooledFund,
  company_code AS CompanyCode,
  created_by AS InvestmentPoolIDCreatedBy,
  IntrstApprtmt.created_on AS InvestmentPoolIDCreateDateTime,
  modified_by AS InvestmentPoolIDChangedBy,
  IntrstApprtmt.modified_on AS InvestmentPoolIDChangeDateTime,
  last_changed_at AS LastChangeDateTime,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  I_User.UserDescription AS UserDescription,
  I_User.UserID AS UserName
FROM psm_inta_header AS IntrstApprtmt
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;