C_FundsMgmtBdgtActlQuery

Funds Management: Commitments/Actuals and Budget Query | view: CFMBUDACTANQ | Extraction: Not supported | Component: Information system
Tables used: FMBCSSUBDIVFMBL, FMBDP, FMBH, FMBL, FMBDP, FMBH, FMBL, FMBDP, FMBH, FMBL, FMBDP, FMBH, FMBL, FMBDP, FMBH, FMBL, FMIFIIT, FMIFIHD, FMIOI, FMIA, BKPF, FMAVCP, FMAVCT, FMAVCT_RECON_YR, FMBUDGETPD, FMCI, FMHICI, FM01, BUAVCSRC, FMFINCODE, FMMEASURE, FMFCTR, TFKB, FM01, FMUP00, GMGR, GMGRANTNONE, GMGRTYPE, BUAVCLDGR, FMUP01, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
💲 Financial Management Area Currency (FinancialManagementAreaCrcy):
BudgetAmountInFMACrcy Budget Amount in Financial Management Area Currency
CmtmtOpenItemAmountInFMACrcy Commitment Amount in Financial Management Area Currency
ActualAmountInFMACrcy Actual Amount in Financial Management Area Currency
CtrlgItemAmountInFMACrcy Controlling Amount in Financial Management Area Currency
DifferenceAmtInFMACrcy Amount Difference in Financial Management Area Currency
Column Name Description
Column Name Description
Column Name Description
FundsMgmtValueType Value Type Show values
BudgetWorkFlowStatus Workflow Status of a Record in the Budget Totals Table Show values
FundsMgmtAmountType Amount Type Show values
IsStatisticalItem Funds Management Statistical Indicator Show values
Column Name Description Domain name
BudgetPeriod Budget Period FM_BUDGET_PERIOD
CommitmentItem Commitment Item FM_FIPEX
FinMgmtAreaFiscalYear Fiscal Year GJAHR
FinMgmtAreaPeriod Period PERBL
FinancialManagementArea Financial Management Area FIKRS
FunctionalArea Functional Area FKBER
Fund Fund BP_GEBER
FundedProgram Funded Program FM_MEASURE
FundsCenter Funds Center FISTL
BudgetValueType BCS Value Type BUKU_VALTYPE
InternalBudgetingProcess Budgeting Process BUKU_PROCESS_UI
BudgetType Budget Type CHAR4
BdgtCashEffectivityFiscalYear Year of Cash Effectivity in Budgeting GJAHR
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
Budget entry document type
  • Client
  • Budget entry document type
  • C_FUNDSMGMTBDGTACTLQUERY.MANDT == FMEDDOCTYPE.CLIENT
  • C_FUNDSMGMTBDGTACTLQUERY.BUDGETENTRYDOCUMENTTYPE == FMEDDOCTYPE.DOCTYPE
Budget Version
  • Budget Version
  • Client
  • C_FUNDSMGMTBDGTACTLQUERY.BUDGETVERSION == TKVS.VERSI
  • C_FUNDSMGMTBDGTACTLQUERY.MANDT == TKVS.MANDT
Financial Management Area Currency
  • Client
  • Financial Management Area Currency
  • C_FUNDSMGMTBDGTACTLQUERY.MANDT == TCURC.MANDT
  • C_FUNDSMGMTBDGTACTLQUERY.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
Grant
  • Grant
  • Client
  • C_FUNDSMGMTBDGTACTLQUERY.GRANTID == GMGR.GRANT_NBR
  • C_FUNDSMGMTBDGTACTLQUERY.MANDT == GMGR.CLIENT
Reference procedure C_FUNDSMGMTBDGTACTLQUERY.REFERENCEDOCUMENTTYPE == TTYP.AWTYP