I_GranteeMgmtBdgtActlCube

GM Budget Cmtmt and Actual Items - Cube | view: IGMBDACTANC | TRAN | Extraction: Not supported | Component: Information System
Tables used: GMIP, GMBDGTLINE, GMBDGTHEADER, GMIA, T001, TKA02, FM01, GMGR, GMGRANTNONE, GMVALUETYPE, GMGRTYPE, T882, T882, GMSPCLASS, PRPS, GMBDGTVERSION, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Grant currency (GrantCurrency):
AmountInGrantCurrency GM Amount in Grant Currency
CmtmtAmountInGrantCrcy Commitment Amount in Grant Currency in Grantee Mgmt
ActlAmountInGrantCrcy Actual Amount in Grant Currency in Grantee Management
BudgetAmountInGrantCrcy Budget Amount in Grant Currency in Grantee Management
💲 GM Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency GM Amount in Company Code Currency
BudgetAmountInCompanyCodeCrcy Budget Amount in Company Code Currency in Grantee Management
CmtmtAmtInCompanyCodeCurrency Commitment Amount in Company Code Currency in Grantee Mgmt
ActualAmountInCompanyCodeCrcy Actual 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
SponsoredClassType Sponsored Class Type Show values
GranteeMgmtBdgtPhase Budget Phase Show values
GranteeMgmtBdgtWorkFlowSts Workflow State of a Record in the Budget Totals Table Show values
Column Name Description Domain name
GranteeMgmtBudgetVersion Version RVERS
FinancialManagementArea Financial Management Area FIKRS
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
GrantFiscalYearPeriod Posting Period of Sponsor (is Grant Posting Period) POPER
GranteeFiscalYear Fiscal Year for Grantee Organization GJAHR
GranteeMgmtValueType GM Value Type GM_VALUETYPE
BusinessTransactionType Business Transaction Category FINS_BTTYPE
CreatedByUser User Name XUBNAME
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Line Item NUMC6
ReferenceDocumentFiscalYear Reference fiscal year GJAHR
ReferenceDocumentContext Reference Organizational Units AWORG
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_GRANTEEMGMTBDGTACTLCUBE.COMPANYCODE == T001.BUKRS
  • I_GRANTEEMGMTBDGTACTLCUBE.MANDT == T001.MANDT
GM Company Code Currency
  • GM Company Code Currency
  • Client
  • I_GRANTEEMGMTBDGTACTLCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_GRANTEEMGMTBDGTACTLCUBE.MANDT == TCURC.MANDT
Grant currency
  • Grant currency
  • Client
  • I_GRANTEEMGMTBDGTACTLCUBE.GRANTCURRENCY == TCURC.WAERS
  • I_GRANTEEMGMTBDGTACTLCUBE.MANDT == TCURC.MANDT
Fiscal Year Variant of Grantee Organization (Company Code)
  • Client
  • Fiscal Year Variant of Grantee Organization (Company Code)
  • I_GRANTEEMGMTBDGTACTLCUBE.MANDT == T009.MANDT
  • I_GRANTEEMGMTBDGTACTLCUBE.GRANTEEFISCALYEARVARIANT == T009.PERIV
Grant Sponsor
  • Client
  • Grant Sponsor
  • I_GRANTEEMGMTBDGTACTLCUBE.MANDT == BUT000.CLIENT
  • I_GRANTEEMGMTBDGTACTLCUBE.GRANTEEMGMTSPONSOR == BUT000.PARTNER
Fiscal year variant of grant
  • Client
  • Fiscal year variant of grant
  • I_GRANTEEMGMTBDGTACTLCUBE.MANDT == T009.MANDT
  • I_GRANTEEMGMTBDGTACTLCUBE.GRANTFISCALYEARVARIANT == T009.PERIV
Lifecycle Status I_GRANTEEMGMTBDGTACTLCUBE.GRANTLIFECYCLESTATUS == TJ02.ISTAT
Ledger
  • Ledger
  • Client
  • I_GRANTEEMGMTBDGTACTLCUBE.LEDGER == T881.RLDNR
  • I_GRANTEEMGMTBDGTACTLCUBE.MANDT == T881.MANDT
Logical system I_GRANTEEMGMTBDGTACTLCUBE.LOGICALSYSTEM == TBDLS.LOGSYS
Reference procedure I_GRANTEEMGMTBDGTACTLCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP