I_FundsMgmtBdgtActlCube

FM Budget Cmtmt and Actual Items - Cube | view: IFMBUDACTANC | TRAN | 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
ConsumableAmountInFMACrcy Consumable Amount
ConsumedAmountInFMACrcy Consumed Amount
💲 Transaction Currency (TransactionCurrency):
BudgetAmountInTransactionCrcy Budget Amount in Transaction Currency in Funds Management
CmtmtOpenItemAmountInTransCrcy Commitment Amount in Transaction Currency in FM
FndsMgmtActlAmountInTransCrcy Actual Amount in Transaction Currency in Funds Management
CtrlgItemAmountInTransCrcy Controlling Amount in Transaction Currency in FM
Column Name Description
Column Name Description
FundsMgmtUpdateDate Funds Management Update Date
Column Name Description
FndsMgmtAnalysisSourceTech Funds Management Analysis Source Show values
FndsMgmtPaytCmtmtBdgtCat Budget Category in Funds Management Show values
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
FundsMgCarryForwardLevel Carryforward Level Show values
Column Name Description Domain name
FinancialManagementArea Financial Management Area FIKRS
CommitmentItem Commitment Item FM_FIPEX
BudgetPeriod Budget Period FM_BUDGET_PERIOD
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
BusinessArea Business Area GSBER
CompanyCode Company Code BUKRS
GLAccount General Ledger Account SAKNR
FinMgmtAreaFiscalYear Fiscal Year GJAHR
FinMgmtAreaPeriod Period PERBL
BdgtCashEffectivityFiscalYear Year of Cash Effectivity in Budgeting GJAHR
BudgetType Budget Type CHAR4
BudgetValueType BCS Value Type BUKU_VALTYPE
InternalBudgetingProcess Budgeting Process BUKU_PROCESS_UI
AvailabilityControlLedger Control Ledger RLDNR
BusinessTransactionType CO Business Transaction J_VORGANG
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
ControlObjectCoverGroup Cover Group FMCE_CVRGRP
ReferenceDocument Reference document number AWREF
ReferenceDocumentFiscalYear Reference fiscal year GJAHR
ReferenceDocumentItem Reference Document Line Item NUMC6
ReferenceDocumentContext Reference Organizational Units AWORG
CommitmentItemFiscalYear null
BudgetPeriodAuthznGrp Budget Period Authorization Group CHAR10
CmtmtItemFinMgmtAreaForAuthzn FM Area for Auth Grp for Commitment Item CHAR04
CommitmentItemAuthznGrp Authorization Group for Commitment Item CHAR10
FndsCenterFinMgmtAreaForAuthzn Financial Management Area FIKRS
FunctionalAreaAuthznGrp FM: Authorization Group of Functional Area CHAR10
FundAuthznGrp Fund Authorization Group CHAR10
FundFinMgmtAreaForAuthzn FM Area for Auth Grp for Fund CHAR04
FundedPgmFinMgmtAreaForAuthzn FM Area for Auth Grp for Funded Program CHAR04
FundedProgramAuthznGrp Funded Program Authorization Group CHAR10
FundsCenterAuthznGrp Funds Center Authorization Group CHAR10
Master Data Relations Join Conditions
Budget Category
  • Budget Category
  • Client
  • I_FUNDSMGMTBDGTACTLCUBE.BUDGETCATEGORY == T881.RLDNR
  • I_FUNDSMGMTBDGTACTLCUBE.MANDT == T881.MANDT
Budget entry document type
  • Client
  • Budget entry document type
  • I_FUNDSMGMTBDGTACTLCUBE.MANDT == FMEDDOCTYPE.CLIENT
  • I_FUNDSMGMTBDGTACTLCUBE.BUDGETENTRYDOCUMENTTYPE == FMEDDOCTYPE.DOCTYPE
Budget Version
  • Client
  • Budget Version
  • I_FUNDSMGMTBDGTACTLCUBE.MANDT == TKVS.MANDT
  • I_FUNDSMGMTBDGTACTLCUBE.BUDGETVERSION == TKVS.VERSI
Financial Management Area Currency
  • Client
  • Financial Management Area Currency
  • I_FUNDSMGMTBDGTACTLCUBE.MANDT == TCURC.MANDT
  • I_FUNDSMGMTBDGTACTLCUBE.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_FUNDSMGMTBDGTACTLCUBE.FINMGMTAREAFISCALYEARVARIANT == T009.PERIV
  • I_FUNDSMGMTBDGTACTLCUBE.MANDT == T009.MANDT
Grants Management: Authorization Groups
  • ?
  • Client
  • Grants Management: Authorization Groups
  • I_FUNDSMGMTBDGTACTLCUBE.[column in domain "GM_OBJECT"] == GMAUTHGRP.OBJECT
  • I_FUNDSMGMTBDGTACTLCUBE.MANDT == GMAUTHGRP.CLIENT
  • I_FUNDSMGMTBDGTACTLCUBE.GRANTAUTHZNGRP == GMAUTHGRP.AUTHGROUP
Grant
  • Grant
  • Client
  • I_FUNDSMGMTBDGTACTLCUBE.GRANTID == GMGR.GRANT_NBR
  • I_FUNDSMGMTBDGTACTLCUBE.MANDT == GMGR.CLIENT
Lifecycle Status I_FUNDSMGMTBDGTACTLCUBE.GRANTLIFECYCLESTATUS == TJ02.ISTAT
Reference procedure I_FUNDSMGMTBDGTACTLCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • I_FUNDSMGMTBDGTACTLCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_FUNDSMGMTBDGTACTLCUBE.MANDT == TCURC.MANDT