C_FundCoreTP

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_FundCoreTP.
-- 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: CFMFUNDCORETP

CREATE VIEW C_FundCoreTP AS
SELECT
  iFund.FinancialManagementArea AS FinancialManagementArea,
  iFund.Fund AS Fund,
  cast('' as fins_ledger) AS Ledger,
  cast('' as fins_ledger_pers) AS SourceLedger,
  cast('' as /uif/lrep_name) AS FundLayoutVariantIdentifier,
  cast('' as fm_budget_period) AS BudgetPeriod,
  cast( '' as fis_bukrs) AS CompanyCode,
  cast( '' as fcom_category) AS PlanningCategory,
  cast( '2000' as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  iFund.FinancialManagementAreaForEdit AS FinancialManagementAreaForEdit,
  iFund.FundForEdit AS FundForEdit,
  iFund.FundName AS FundName,
  iFund.FundDescription AS FundDescription,
  iFund.FundType AS FundType,
  iFund._FundType._Text[1:Language = $session.system_language].FundTypeDescription AS FundTypeDescription,
  iFund.FundPeriodicity AS FundPeriodicity,
  iFund._FundPeriodicity._Text[1:Language = $session.system_language].FundPeriodicityText AS FundPeriodicityText,
  iFund.FundAuthznGrp AS FundAuthznGrp,
  iFund._FundAuthznGrp._Text[1:Language = $session.system_language].FundAuthznGrpText AS FundAuthznGrpText,
  iFund.FundResponsibleUser AS FundResponsibleUser,
  iFund.ValidityStartDate AS ValidityStartDate,
  iFund.ValidityEndDate AS ValidityEndDate,
  iFund.FundCreatedBy AS FundCreatedBy,
  iFund.CreatedByUserDescription AS CreatedByUserDescription,
  iFund.FundCreatedAt AS FundCreatedAt,
  iFund.LastChangedByUser AS LastChangedByUser,
  iFund.LastChangedByUserDescription AS LastChangedByUserDescription,
  iFund.LastChangeDate AS LastChangeDate,
  iFund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  iFund._FinMgmtArea AS _FinMgmtArea,
  iFund._FinMgmtAreaForEdit AS _FinMgmtAreaForEdit,
  iFund._FundAuthznGrp AS _FundAuthznGrp,
  iFund._FundType AS _FundType,
  iFund._FundPeriodicity AS _FundPeriodicity,
  iFund.ObjectKey AS ObjectKey
FROM I_FundCoreTP AS iFund
;