I_GteeMCmtmtActlDocItemBasic

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_GteeMCmtmtActlDocItemBasic.
-- 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: IGMACDOCIB

CREATE VIEW I_GteeMCmtmtActlDocItemBasic AS
SELECT
  gmia.gl_sirid AS GranteeMgmtLongSequenceNumber,
  gmia.rldnr AS Ledger,
  cast( gmia.rbukrs as fis_bukrs preserving type ) AS CompanyCode,
  gmia.fm_area AS FinancialManagementArea,
  cast( gmia.co_area as fis_kokrs preserving type ) AS ControllingArea,
  gmia.rgrant_nbr AS GrantID,
  gmia.rsponsored_prog AS SponsoredProgram,
  gmia.rsponsored_class AS SponsoredClass,
  gmia.rfund AS Fund,
  gmia.rbdgt_vldty_nbr AS GteeMBudgetValidityNumber,
  cast( gmia.gl_account as fis_racct preserving type ) AS GLAccount,
  cast( gmia.bus_area as fis_rbusa preserving type ) AS BusinessArea,
  cast( gmia.funds_ctr as fm_fictr preserving type ) AS FundsCenter,
  gmia.cmmt_item AS CommitmentItem,
  gmia.farea AS FunctionalArea,
  gmia.measure AS FundedProgram,
  cast( gmia.costcenter as fis_kostl preserving type ) AS CostCenter,
  cast( gmia.assetmaino as fis_anln1 preserving type ) AS MasterFixedAsset,
  cast( gmia.assetsubno as fis_anln2 preserving type ) AS FixedAsset,
  cast( gmia.orderid as fis_aufnr preserving type ) AS OrderID,
  cast( gmia.profit_ctr as fis_prctr preserving type ) AS ProfitCenter,
  gmia.wbs_short_9 AS WBSElementInternalID,
  gmia.material AS Material,
  cast( gmia.ryear as gmis_grant_fy preserving type ) AS GrantFiscalYear,
  cast( gmia.poper as gmis_grant_fypp preserving type ) AS GrantFiscalYearPeriod,
  _Grant.GrantFiscalYearVariant AS GrantFiscalYearVariant,
  cast( gmia.rgrantee_fy_9 as gm_grantee_fy preserving type ) AS GranteeFiscalYear,
  cast( _CompanyCode.FiscalYearVariant as gmis_grantee_fyvariant preserving type ) AS GranteeFiscalYearVariant,
  cast(gmia.rtcur as gm_grant_currency preserving type ) AS GrantCurrency,
  cast(gmia.tsl as gm_amount_grant_curr ) AS AmountInGrantCurrency,
  cast(t882.curr1 as gm_comp_code_currency preserving type ) AS CompanyCodeCurrency,
  cast(gmia.hsl as gm_amount_compcode_curr ) AS AmountInCompanyCodeCurrency,
  gmia.rwcur AS OriginalCurrency,
  cast(gmia.wsl as gm_amount_original_curr ) AS AmountInOriginalCurrency,
  gmia.rvaluetype_9 AS GranteeMgmtValueType,
  cast( gmia.rtrans as fins_bttype preserving type ) AS BusinessTransactionType,
  gmia.rstats_ind AS IsStatisticalItem,
  gmia.logsys AS LogicalSystem,
  gmia.budat AS PostingDate,
  cast ( left (gmia.refdoc_detail,2) as cc_rfknt) AS RefDocAccountAssignment,
  cast ( substring (gmia.refdoc_detail, 3, 4) as cc_rftrm) AS ReferenceDocumentScheduleLine,
  gmia.cpudt AS CreationDate,
  gmia.cputm AS CreationTime,
  gmia.usnam AS CreatedByUser,
  gmia.erlkz AS GranteeMgmtItemIsCompleted,
  gmia.loekz AS GranteeMgmtItemIsDeleted,
  gmia.sgtxt AS DocumentItemText,
  gmia.bdgt_state AS GranteeMgmtBdgtWorkFlowSts,
  cast( gmia.refdocnr as awref preserving type ) AS ReferenceDocument,
  gmia.refryear AS ReferenceDocumentFiscalYear,
  cast( gmia.refdocln as fins_awitem preserving type ) AS ReferenceDocumentItem,
  gmia.awtyp AS ReferenceDocumentType,
  gmia.aworg AS ReferenceDocumentContext,
  cast( gmia.awsys as fis_awsys preserving type ) AS ReferenceDocumentLogicalSystem,
  gmia.obj_org_p AS PredecessorReferenceDocCntxt,
  gmia.obj_typ_p AS PredecessorReferenceDocType,
  gmia.obj_key_p AS PredecessorReferenceDocument,
  gmia.obj_pos_p AS PredecessorReferenceDocItem,
  gmia.billing_status AS GranteeMgmtBillingStatus,
  _CompanyCode._FiscalYearVariant AS _CompanyCodeFiscalYearVariant,
  _Grant._FiscalYearVariant AS _GrantFiscalYearVariant,
  _FinMgmtArea._FiscalYearVariant AS _FinMgmtAreaFiscalYearVariant
FROM gmia
INNER JOIN t882 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYearForCompanyCode ON GranteeFiscalYear = _FiscalYearForCompanyCode.FiscalYear AND CompanyCode = _FiscalYearForCompanyCode.CompanyCode  -- association [0..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_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _ReferenceDocLogicalSystem ON ReferenceDocumentLogicalSystem = _ReferenceDocLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_GranteeMgmtValueType AS _ValueType ON GranteeMgmtValueType = _ValueType.GranteeMgmtValueType  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON FinMgmtAreaFiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant AND PostingDate = _FiscalCalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_GteeMBillingStatus AS _BillingStatus ON GranteeMgmtBillingStatus = _BillingStatus.GranteeMgmtBillingStatus  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GrantCurrency ON GrantCurrency = _GrantCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
;