C_GranteeMgmtBdgtActlQry1

Grantee Management Commitments/Actuals and Budget Query | view: CGMBDACTANQ | 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):
BudgetAmountInGrantCrcy Budget Amount in Grant Currency in Grantee Management
AmountInGrantCurrency GM Amount in Grant Currency
CmtmtAmountInGrantCrcy Commitment Amount in Grant Currency in Grantee Mgmt
ActlAmountInGrantCrcy Actual Amount in Grant Currency in Grantee Management
CmtmtAmtInCompanyCodeCurrency Commitment Amount in Company Code Currency in Grantee Mgmt
ActualAmountInCompanyCodeCrcy Actual Amount in Company Code Currency in Grantee Management
💲 GM Company Code Currency (CompanyCodeCurrency):
BudgetAmountInCompanyCodeCrcy Budget Amount in Company Code Currency in Grantee Management
AmountInCompanyCodeCurrency GM Amount in Company Code Currency
DifferenceAmtInCoCodeCrcy Amount Difference in Company Code Currency in Grantee Mgmt
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
SponsoredClassType Sponsored Class Type Show values
Column Name Description Domain name
GrantFiscalYear Fiscal Year of Sponsor (is Grant Fiscal Year) GJAHR
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
GteeMBudgetValidityNumber Budget Validity Number GM_BDGT_VLDTY_NBR
Fund Fund BP_GEBER
GranteeMgmtValueType GM Value Type GM_VALUETYPE
BusinessTransactionType Business Transaction Category FINS_BTTYPE
GranteeFiscalYear Fiscal Year for Grantee Organization GJAHR
GrantFiscalYearPeriod Posting Period of Sponsor (is Grant Posting Period) POPER
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
  • C_GRANTEEMGMTBDGTACTLQRY1.COMPANYCODE == T001.BUKRS
  • C_GRANTEEMGMTBDGTACTLQRY1.MANDT == T001.MANDT
GM Company Code Currency
  • GM Company Code Currency
  • Client
  • C_GRANTEEMGMTBDGTACTLQRY1.COMPANYCODECURRENCY == TCURC.WAERS
  • C_GRANTEEMGMTBDGTACTLQRY1.MANDT == TCURC.MANDT
Grant currency
  • Grant currency
  • Client
  • C_GRANTEEMGMTBDGTACTLQRY1.GRANTCURRENCY == TCURC.WAERS
  • C_GRANTEEMGMTBDGTACTLQRY1.MANDT == TCURC.MANDT
Grant Sponsor
  • Grant Sponsor
  • Client
  • C_GRANTEEMGMTBDGTACTLQRY1.GRANTEEMGMTSPONSOR == BUT000.PARTNER
  • C_GRANTEEMGMTBDGTACTLQRY1.MANDT == BUT000.CLIENT
Lifecycle Status C_GRANTEEMGMTBDGTACTLQRY1.GRANTLIFECYCLESTATUS == TJ02.ISTAT
Logical system C_GRANTEEMGMTBDGTACTLQRY1.LOGICALSYSTEM == TBDLS.LOGSYS
Reference procedure C_GRANTEEMGMTBDGTACTLQRY1.REFERENCEDOCUMENTTYPE == TTYP.AWTYP