I_GteeMBudgetEntryDocumentItem

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_GteeMBudgetEntryDocumentItem.
-- 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: IGMBDGTDOCITM

CREATE VIEW I_GteeMBudgetEntryDocumentItem AS
SELECT
  GranteeMgmtBudgetEntryDocument,
  GteeMBudgetEntryDocumentItem,
  GrantID,
  GteeMBudgetValidityNumber,
  SponsoredProgram,
  SponsoredClass,
  GteeMFinancingObjectType,
  GteeMFinancingObject,
  _Grant._CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  Fund,
  GrantCurrency,
  cast(NetBdgtAmtInGrantCrcy as gmis_bdgt_amt_net_grant_crcy ) AS NetBdgtAmtInGrantCrcy,
  GteeMIndirectCostRateInPercent,
  cast(IndirectCostBdgtAmtInGrantCrcy as gmis_bdgt_amt_idc_grant_crcy) AS IndirectCostBdgtAmtInGrantCrcy,
  cast(AwardBdgtAmtInGrantCrcy * BudgetAmountFactor as gmis_bdgt_amt_award_grant_crcy) AS AwardBdgtAmtInGrantCrcy,
  GteeMCostSharingRateInPercent,
  cast(CostShrngBdgtAmtInGrantCrcy as gmis_bdgt_amt_csh_grant_crcy) AS CostShrngBdgtAmtInGrantCrcy,
  cast(TotalBdgtAmtInGrantCrcy as gmis_bdgt_amt_total_grant_crcy) AS TotalBdgtAmtInGrantCrcy,
  GteeMBudgetEntryDocItemDesc,
  GteeMInternalBudgetingProcess,
  GranteeMgmtValueType,
  PostingDate,
  GranteeFiscalYear,
  SponsoredClassType
FROM I_GteeMBdgtEntrDocItemBasic
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
;