I_GranteeMgmtBdgtDocCube

Grantee Management Budget Items - Cube | view: IGMBDGTDOCIANC | TRAN | Extraction: Not supported | Component: Information System
Tables used: GMIP, GMBDGTLINE, GMBDGTHEADER, T001, TKA02, GMGR, GMGRANTNONE, GMVALUETYPE, GMGRTYPE, T882, GMBDGTVERSION
Column Name Description
GranteeMgmtLongSequenceNumber Record number of the line item record
Column Name Description
💲 Grant currency (GrantCurrency):
BudgetAmountInGrantCrcy Budget Amount in Grant Currency in Grantee Management
💲 GM Company Code Currency (CompanyCodeCurrency):
BudgetAmountInCompanyCodeCrcy Budget Amount in Company Code Currency in Grantee Management
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
Column Name Description
GranteeMgmtValueTypeCategory GM Value Type Category Show values
GranteeMgmtBudgetStatus Budget Status: Unreleased/Released Show values
IsStatisticalItem Statistical Indicator Show values
GranteeMgmtBdgtPhase Budget Phase Show values
GranteeMgmtBdgtWorkFlowSts Workflow State of a Record in the Budget Totals Table Show values
SponsoredClassType Sponsored Class Type Show values
Column Name Description Domain name
GrantID Grant GM_GRANT_NBR
SponsoredProgram Sponsored Program GM_SPONSORED_PROG
SponsoredClass Sponsored Class GM_SPONSORED_CLASS
Fund Fund BP_GEBER
GteeMBudgetValidityNumber Budget Validity Number GM_BDGT_VLDTY_NBR
GrantFiscalYear Fiscal Year of Sponsor (is Grant Fiscal Year) GJAHR
GranteeFiscalYear Fiscal Year for Grantee Organization GJAHR
GranteeMgmtValueType GM Value Type GM_VALUETYPE
BusinessTransactionType Business Transaction Category FINS_BTTYPE
GteeMBudgetEntryDocItemDesc Item Text TEXT50
CreatedByUser User Name XUBNAME
ReferenceDocument Reference document number AWREF
ReferenceDocumentFiscalYear Reference fiscal year GJAHR
ReferenceDocumentItem Reference Document Line Item NUMC6
ReferenceDocumentContext Reference Organizational Units AWORG
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == T001.MANDT
  • I_GRANTEEMGMTBDGTDOCCUBE.COMPANYCODE == T001.BUKRS
GM Company Code Currency
  • GM Company Code Currency
  • Client
  • I_GRANTEEMGMTBDGTDOCCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == TCURC.MANDT
Financial Management Area
  • Client
  • Financial Management Area
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == FM01.MANDT
  • I_GRANTEEMGMTBDGTDOCCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Grant currency
  • Client
  • Grant currency
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == TCURC.MANDT
  • I_GRANTEEMGMTBDGTDOCCUBE.GRANTCURRENCY == TCURC.WAERS
Fiscal Year Variant of Grantee Organization (Company Code)
  • Client
  • Fiscal Year Variant of Grantee Organization (Company Code)
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == T009.MANDT
  • I_GRANTEEMGMTBDGTDOCCUBE.GRANTEEFISCALYEARVARIANT == T009.PERIV
Version
  • Client
  • Ledger
  • Version
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == T894.MANDT
  • I_GRANTEEMGMTBDGTDOCCUBE.LEDGER == T894.RLDNR
  • I_GRANTEEMGMTBDGTDOCCUBE.GRANTEEMGMTBUDGETVERSION == T894.RVERS
Grant Sponsor
  • Client
  • Grant Sponsor
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == BUT000.CLIENT
  • I_GRANTEEMGMTBDGTDOCCUBE.GRANTEEMGMTSPONSOR == BUT000.PARTNER
Fiscal year variant of grant
  • Client
  • Fiscal year variant of grant
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == T009.MANDT
  • I_GRANTEEMGMTBDGTDOCCUBE.GRANTFISCALYEARVARIANT == T009.PERIV
Lifecycle Status I_GRANTEEMGMTBDGTDOCCUBE.GRANTLIFECYCLESTATUS == TJ02.ISTAT
Document Type
  • Client
  • Budget Document Type
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == GMBDGTDOCTYPE.CLIENT
  • I_GRANTEEMGMTBDGTDOCCUBE.GTEEMBUDGETENTRYDOCUMENTTYPE == GMBDGTDOCTYPE.DOC_TYPE
Ledger
  • Client
  • Ledger
  • I_GRANTEEMGMTBDGTDOCCUBE.MANDT == T881.MANDT
  • I_GRANTEEMGMTBDGTDOCCUBE.LEDGER == T881.RLDNR
Logical system I_GRANTEEMGMTBDGTDOCCUBE.LOGICALSYSTEM == TBDLS.LOGSYS
Reference procedure I_GRANTEEMGMTBDGTDOCCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP