I_FundBasic

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_FundBasic.
-- 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: IFUNDBASIC

CREATE VIEW I_FundBasic AS
SELECT
  fikrs AS FinancialManagementArea,
  fincode AS Fund,
  sponsor AS Customer,
  finuse AS ApplicationOfFunds,
  cast( erfname as fmis_fund_createdby preserving type) AS FundCreatedBy,
  cast( erfdat as fmis_fund_createdat preserving type) AS FundCreatedAt,
  cast( aenname as fmis_fund_lastchangebyuser preserving type) AS LastChangeUser,
  cast( aendat as fmis_fund_lastchangedate preserving type ) AS LastChangeDate,
  augrp AS FundAuthznGrp,
  cast( datab as fmis_fund_validitystartdate preserving type) AS ValidityStartDate,
  cast( datbis as fmis_fund_validityenddate preserving type) AS ValidityEndDate,
  cast( date_can as fmis_fund_reversaldate preserving type) AS FundReversalDate,
  cast( date_exp as fmis_fund_expirationdate preserving type) AS FundExpirationDate,
  type AS FundType,
  periodicity AS FundPeriodicity,
  fund_resp AS FundResponsibleUser
FROM fmfincode
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FundText AS _Text ON FinancialManagementArea = _Text.FinancialManagementArea AND Fund = _Text.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundType AS _FundType ON FinancialManagementArea = _FundType.FinancialManagementArea AND FundType = _FundType.FundType  -- association [1..1]
LEFT OUTER JOIN I_FundAuthznGrp AS _FundAuthznGrp ON FundAuthznGrp = _FundAuthznGrp.FundAuthznGrp  -- association [1..1]
LEFT OUTER JOIN I_FundPeriodicity AS _FundPeriodicity ON FundPeriodicity = _FundPeriodicity.FundPeriodicity  -- association [1..1]
LEFT OUTER JOIN I_ApplicationOfFund AS _ApplicationOfFund ON FinancialManagementArea = _ApplicationOfFund.FinancialManagementArea AND ApplicationOfFunds = _ApplicationOfFund.ApplicationOfFunds  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON FundCreatedBy = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangeUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_FundHierarchyNode AS _FundHierarchyNode ON FinancialManagementArea = _FundHierarchyNode.FinancialManagementArea AND Fund = _FundHierarchyNode.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundToBudgetPeriod AS _FundToBudgetPeriod ON FinancialManagementArea = _FundToBudgetPeriod.FinancialManagementArea AND Fund = _FundToBudgetPeriod.Fund  -- association [0..*]
;