C_FundsMgmtBdgtDocQry1

Funds Management: Budget Documents Query | view: CFMBUDOCIANQ1 | Extraction: Not supported | Component: Information system
Column Name Description
Column Name Description
💲 Financial Management Area Currency (FinancialManagementAreaCrcy):
BudgetAmountInFMACrcy Budget Amount in Financial Management Area Currency
Column Name Description
Column Name Description
CreationDate Date on which the object was created or updated
LastChangeDate Date on which the object was changed
BudgetEntryDocumentDate Document Date
ReferenceDocumentChangeDate Reference Document Change Date in Funds Management
Column Name Description
CommitmentItemCategory Commitment Item Category Show values
BudgetWorkFlowStatus Workflow Status of a Record in the Budget Totals Table Show values
BudgetEntryDocumentStatus Status of a budget entry document Show values
BdgtEntryDocReversalStatus Reversal Status Show values
BudgetEntryDocItemIsAdditional Indicator for Additional Line Show values
Column Name Description Domain name
FinancialManagementArea Financial Management Area FIKRS
BudgetDocumentYear Budget Entry Document Year GJAHR
BudgetEntryDocument Budget Entry Document Number BELNR
BudgetEntryDocumentItem Budget Entry Document Line DOCLN6
BudgetPeriod Budget Period FM_BUDGET_PERIOD
CommitmentItem Commitment Item FM_FIPEX
FunctionalArea Functional Area FKBER
Fund Fund BP_GEBER
FundedProgram Funded Program FM_MEASURE
FundsCenter Funds Center FISTL
FundsManagementCustomerField Customer Field for FM Actual and Commitment Data FM_USERDIM
FinMgmtAreaFiscalYear Fiscal Year GJAHR
BdgtCashEffectivityFiscalYear Year of Cash Effectivity in Budgeting GJAHR
InternalBudgetingProcess Internal Budgeting Process BUKU_PROCESS
BudgetType Budget Type CHAR4
BudgetValueType BCS Value Type BUKU_VALTYPE
BudgetEntryDocumentFamily Document Family Number BELNR
BudgetEntryDocumentDescription Header Text for Budget Entry Document TEXT50
ReversalReason Reason for Reversal of Budget Document STGRD
BudgetEntryDocDistributionKey Distribution Key SPRED
BudgetEntryDocItemDescription Item Text TEXT50
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Six-Digit Number of the Reference Posting Line BUZEI6
CommitmentItem1Subdivision Substring 1 of Commitment Item CHAR10
CommitmentItem2Subdivision Substring 2 of Commitment Item CHAR10
CommitmentItem3Subdivision Substring 3 of Commitment Item CHAR10
CommitmentItem4Subdivision Substring 4 of Commitment Item CHAR10
Funds1Subdivision Substring 1 of Fund CHAR10
Funds2Subdivision Substring 2 of Fund CHAR10
FundsCenter1Subdivision Substring 1 of Funds Center CHAR10
FundsCenter2Subdivision Substring 2 of Funds Center CHAR10
FundsCenter3Subdivision Substring 3 of Funds Center CHAR10
Master Data Relations Join Conditions
Budget Category
  • Budget Category
  • Client
  • C_FUNDSMGMTBDGTDOCQRY1.BUDGETCATEGORY == T881.RLDNR
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == T881.MANDT
Budget entry document type
  • Client
  • Budget entry document type
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == FMEDDOCTYPE.CLIENT
  • C_FUNDSMGMTBDGTDOCQRY1.BUDGETENTRYDOCUMENTTYPE == FMEDDOCTYPE.DOCTYPE
Budget Version
  • Budget Version
  • Client
  • C_FUNDSMGMTBDGTDOCQRY1.BUDGETVERSION == TKVS.VERSI
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == TKVS.MANDT
Commitment Item Subdivision ID
  • Client
  • ?
  • Commitment Item Subdivision ID
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == FMMDSTRID.MANDT
  • C_FUNDSMGMTBDGTDOCQRY1.[column in domain "FM_MASDAT_ID"] == FMMDSTRID.MASDAT_ID
  • C_FUNDSMGMTBDGTDOCQRY1.COMMITMENTITEMSUBDIVISIONID == FMMDSTRID.STR_ID
Financial Management Area Currency
  • Client
  • Financial Management Area Currency
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == TCURC.MANDT
  • C_FUNDSMGMTBDGTDOCQRY1.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == T009.MANDT
  • C_FUNDSMGMTBDGTDOCQRY1.FINMGMTAREAFISCALYEARVARIANT == T009.PERIV
Functional Area Subdivision ID
  • Client
  • Functional Area Subdivision ID
  • ?
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == FMMDSTRID.MANDT
  • C_FUNDSMGMTBDGTDOCQRY1.FUNCTIONALAREASUBDIVISIONID == FMMDSTRID.STR_ID
  • C_FUNDSMGMTBDGTDOCQRY1.[column in domain "FM_MASDAT_ID"] == FMMDSTRID.MASDAT_ID
Funds Center Subdivision ID
  • Client
  • ?
  • Funds Center Subdivision ID
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == FMMDSTRID.MANDT
  • C_FUNDSMGMTBDGTDOCQRY1.[column in domain "FM_MASDAT_ID"] == FMMDSTRID.MASDAT_ID
  • C_FUNDSMGMTBDGTDOCQRY1.FUNDSCENTERSUBDIVISIONID == FMMDSTRID.STR_ID
Grant
  • Client
  • Grant
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == GMGR.CLIENT
  • C_FUNDSMGMTBDGTDOCQRY1.GRANTID == GMGR.GRANT_NBR
Original Application
  • Client
  • Original Application
  • C_FUNDSMGMTBDGTDOCQRY1.MANDT == BUTECHORG.CLIENT
  • C_FUNDSMGMTBDGTDOCQRY1.ORIGINALBUDGETINGAPPLICATION == BUTECHORG.TECHORG
Reference procedure C_FUNDSMGMTBDGTDOCQRY1.REFERENCEDOCUMENTTYPE == TTYP.AWTYP