I_GranteeMgmtEntryItemBasic

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_GranteeMgmtEntryItemBasic.
-- 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: IGMIAB

CREATE VIEW I_GranteeMgmtEntryItemBasic AS
SELECT
  gmia.gl_sirid AS GranteeMgmtLongSequenceNumber,
  gmia.rldnr AS Ledger,
  gmia.ryear AS FiscalYear,
  _FinMgmtArea.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  gmia.rtcur AS TransactionCurrency,
  gmia.poper AS FiscalYearPeriod,
  cast( gmia.rbukrs as fis_bukrs preserving type ) AS CompanyCode,
  gmia.rgrant_nbr AS GrantID,
  gmia.rsponsored_prog AS SponsoredProgram,
  gmia.rsponsored_class AS SponsoredClass,
  gmia.rbdgt_vldty_nbr AS GteeMBudgetValidityNumber,
  gmia.rfund AS Fund,
  gmia.rvaluetype_9 AS GranteeMgmtValueType,
  cast( gmia.rtrans as fins_bttype preserving type ) AS BusinessTransactionType,
  gmia.rstats_ind AS IsStatisticalItem,
  cast( gmia.rgrantee_fy_9 as gm_grantee_fy preserving type ) AS GranteeFiscalYear,
  gmia.logsys AS LogicalSystem,
  cast(t882.curr1 as gm_comp_code_currency preserving type ) AS CompanyCodeCurrency,
  gmia.tsl AS AmountInTransactionCurrency,
  gmia.budat AS PostingDate,
  cast( gmia.refdocnr as awref preserving type ) AS ReferenceDocument,
  cast( gmia.refdocln as fins_awitem preserving type ) AS ReferenceDocumentItem,
  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.awtyp AS ReferenceDocumentType,
  gmia.aworg AS ReferenceDocumentContext,
  cast( gl_account as fis_racct preserving type ) AS GLAccount,
  cast( co_area as fis_kokrs preserving type ) AS ControllingArea,
  cast( costcenter as fis_kostl preserving type ) AS CostCenter,
  gmia.fm_area AS FinancialManagementArea,
  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,
  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.rwcur AS OriginalCurrency,
  gmia.wsl AS AmountInOriginalCurrency,
  gmia.erlkz AS GranteeMgmtItemIsCompleted,
  gmia.loekz AS GranteeMgmtItemIsDeleted,
  gmia.awsys AS ReferenceDocumentLogicalSystem
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 FiscalYear = _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_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _OriginalCurrency ON OriginalCurrency = _OriginalCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
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]
;