C_GranteeMgmtBdgtDocQry1

Grantee Management Budget Document Items Query | view: CGMBDGTDOCIANQ1 | Extraction: Not supported | Component: Information System
Tables used: GMIP, GMBDGTLINE, GMBDGTHEADER, T001, TKA02, GMGR, GMGRANTNONE, GMVALUETYPE, GMGRTYPE, T882, GMBDGTVERSION
Column Name Description
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
IsStatisticalItem Statistical Indicator Show values
GranteeMgmtBdgtPhase Budget Phase Show values
GranteeMgmtBudgetStatus Budget Status: Unreleased/Released 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
GrantFiscalYear Fiscal Year of Sponsor (is Grant Fiscal Year) GJAHR
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
GteeMBudgetEntryDocItemDesc Item Text TEXT50
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
  • C_GRANTEEMGMTBDGTDOCQRY1.MANDT == T001.MANDT
  • C_GRANTEEMGMTBDGTDOCQRY1.COMPANYCODE == T001.BUKRS
GM Company Code Currency
  • Client
  • GM Company Code Currency
  • C_GRANTEEMGMTBDGTDOCQRY1.MANDT == TCURC.MANDT
  • C_GRANTEEMGMTBDGTDOCQRY1.COMPANYCODECURRENCY == TCURC.WAERS
Financial Management Area
  • Client
  • Financial Management Area
  • C_GRANTEEMGMTBDGTDOCQRY1.MANDT == FM01.MANDT
  • C_GRANTEEMGMTBDGTDOCQRY1.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Grant currency
  • Client
  • Grant currency
  • C_GRANTEEMGMTBDGTDOCQRY1.MANDT == TCURC.MANDT
  • C_GRANTEEMGMTBDGTDOCQRY1.GRANTCURRENCY == TCURC.WAERS
Version
  • Client
  • ?
  • Version
  • C_GRANTEEMGMTBDGTDOCQRY1.MANDT == T894.MANDT
  • C_GRANTEEMGMTBDGTDOCQRY1.[column in domain "RLDNR"] == T894.RLDNR
  • C_GRANTEEMGMTBDGTDOCQRY1.GRANTEEMGMTBUDGETVERSION == T894.RVERS
Grant Sponsor
  • Client
  • Grant Sponsor
  • C_GRANTEEMGMTBDGTDOCQRY1.MANDT == BUT000.CLIENT
  • C_GRANTEEMGMTBDGTDOCQRY1.GRANTEEMGMTSPONSOR == BUT000.PARTNER
Document Type
  • Client
  • Budget Document Type
  • C_GRANTEEMGMTBDGTDOCQRY1.MANDT == GMBDGTDOCTYPE.CLIENT
  • C_GRANTEEMGMTBDGTDOCQRY1.GTEEMBUDGETENTRYDOCUMENTTYPE == GMBDGTDOCTYPE.DOC_TYPE
Logical system C_GRANTEEMGMTBDGTDOCQRY1.LOGICALSYSTEM == TBDLS.LOGSYS
Reference procedure C_GRANTEEMGMTBDGTDOCQRY1.REFERENCEDOCUMENTTYPE == TTYP.AWTYP