I_GteeMBdgtEntrDocItemBasic

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_GteeMBdgtEntrDocItemBasic.
-- 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: IGMBDGTDOCITMB

CREATE VIEW I_GteeMBdgtEntrDocItemBasic AS
SELECT
  bdgt_doc_nbr AS GranteeMgmtBudgetEntryDocument,
  line AS GteeMBudgetEntryDocumentItem,
  grant_nbr AS GrantID,
  bdgt_vldty_nbr AS GteeMBudgetValidityNumber,
  sponsored_prog AS SponsoredProgram,
  sponsored_class AS SponsoredClass,
  fin_object_type AS GteeMFinancingObjectType,
  financing_object AS GteeMFinancingObject,
  Fund,
  _Grant.GrantCurrency AS GrantCurrency,
  cast(amount as gmis_bdgt_amt_net_grant_crcy) AS NetBdgtAmtInGrantCrcy,
  perc_idc AS GteeMIndirectCostRateInPercent,
  cast(amount_idc as gmis_bdgt_amt_idc_grant_crcy) AS IndirectCostBdgtAmtInGrantCrcy,
  cast(total_award as gmis_bdgt_amt_award_grant_crcy) AS AwardBdgtAmtInGrantCrcy,
  perc_csh AS GteeMCostSharingRateInPercent,
  cast(amount_csh as gmis_bdgt_amt_csh_grant_crcy) AS CostShrngBdgtAmtInGrantCrcy,
  cast(total_amount as gmis_bdgt_amt_total_grant_crcy) AS TotalBdgtAmtInGrantCrcy,
  cast(text as gmis_bdgt_doc_item_desc) AS GteeMBudgetEntryDocItemDesc,
  process AS GteeMInternalBudgetingProcess,
  valuetype AS GranteeMgmtValueType,
  posting_date AS PostingDate,
  grantee_fy AS GranteeFiscalYear,
  class_type AS SponsoredClassType
FROM gmbdgtline
LEFT OUTER JOIN I_GteeMBudgetEntryDocument AS _Header ON GranteeMgmtBudgetEntryDocument = _Header.GranteeMgmtBudgetEntryDocument  -- association [1..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_SponsoredProgram AS _SponsoredProgram ON SponsoredProgram = _SponsoredProgram.SponsoredProgram  -- association [0..1]
LEFT OUTER JOIN I_SponsoredClass AS _SponsoredClass ON SponsoredClass = _SponsoredClass.SponsoredClass  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GrantCurrency ON GrantCurrency = _GrantCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BudgetingProcess ON GteeMInternalBudgetingProcess = _BudgetingProcess.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_GranteeMgmtValueType AS _ValueType ON GranteeMgmtValueType = _ValueType.GranteeMgmtValueType  -- association [0..1]
LEFT OUTER JOIN I_SponsoredClassType AS _SponsoredClassType ON SponsoredClassType = _SponsoredClassType.SponsoredClassType  -- association [0..1]
;