I_FundsMgmtBdgtDocItmCube

Funds Management Budget Items - Cube | view: IFMBUDOCITMANC | 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, FMBUDGETPD, FMCI, FMHICI, FM01, FMFINCODE, FMMEASURE, FMFCTR, TFKB, GMGR, GMGRANTNONE, GMGRTYPE, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
BudgetChangeDocument Budget Change Document Number
FinMgmtAreaFiscalYear Fiscal Year
FinancialManagementArea Financial Management Area
BudgetCategory FK Budget Category
BudgetChangeDocumentItem Budget Change Document Line
Column Name Description
💲 Financial Management Area Currency (FinancialManagementAreaCrcy):
BudgetAmountInFMACrcy Budget Amount in Financial Management Area Currency
💲 Transaction Currency (TransactionCurrency):
BudgetAmountInTransactionCrcy Budget Amount in Transaction Currency in Funds Management
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
FndsMgmtPaytCmtmtBdgtCat Budget Category in Funds Management 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
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
BdgtCashEffectivityFiscalYear Year of Cash Effectivity in Budgeting GJAHR
BudgetValueType BCS Value Type BUKU_VALTYPE
InternalBudgetingProcess Internal Budgeting Process BUKU_PROCESS
BudgetType Budget Type CHAR4
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
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document GJAHR
ReferenceDocumentContext Reference Organizational Units AWORG
ReferenceDocumentItem Six-Digit Number of the Reference Posting Line BUZEI6
BudgetPeriodAuthznGrp Budget Period Authorization Group CHAR10
CmtmtItemFinMgmtAreaForAuthzn FM Area for Auth Grp for Commitment Item CHAR04
CommitmentItemAuthznGrp Authorization Group for Commitment Item CHAR10
FunctionalAreaAuthznGrp FM: Authorization Group of Functional Area CHAR10
FundFinMgmtAreaForAuthzn FM Area for Auth Grp for Fund CHAR04
FundAuthznGrp Fund Authorization Group CHAR10
FundedPgmFinMgmtAreaForAuthzn FM Area for Auth Grp for Funded Program CHAR04
FundedProgramAuthznGrp Funded Program Authorization Group CHAR10
FndsCenterFinMgmtAreaForAuthzn Financial Management Area FIKRS
FundsCenterAuthznGrp Funds Center Authorization Group CHAR10
CommitmentItemFiscalYear null
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
CommitmentItem5Subdivision Substring 5 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
  • I_FUNDSMGMTBDGTDOCITMCUBE.BUDGETCATEGORY == T881.RLDNR
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == T881.MANDT
Budget entry document type
  • Client
  • Budget entry document type
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == FMEDDOCTYPE.CLIENT
  • I_FUNDSMGMTBDGTDOCITMCUBE.BUDGETENTRYDOCUMENTTYPE == FMEDDOCTYPE.DOCTYPE
Budget Version
  • Client
  • Budget Version
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == TKVS.MANDT
  • I_FUNDSMGMTBDGTDOCITMCUBE.BUDGETVERSION == TKVS.VERSI
Commitment Item Subdivision ID
  • Client
  • ?
  • Commitment Item Subdivision ID
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == FMMDSTRID.MANDT
  • I_FUNDSMGMTBDGTDOCITMCUBE.[column in domain "FM_MASDAT_ID"] == FMMDSTRID.MASDAT_ID
  • I_FUNDSMGMTBDGTDOCITMCUBE.COMMITMENTITEMSUBDIVISIONID == FMMDSTRID.STR_ID
Financial Management Area Currency
  • Financial Management Area Currency
  • Client
  • I_FUNDSMGMTBDGTDOCITMCUBE.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_FUNDSMGMTBDGTDOCITMCUBE.FINMGMTAREAFISCALYEARVARIANT == T009.PERIV
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == T009.MANDT
Functional Area Subdivision ID
  • Client
  • Functional Area Subdivision ID
  • ?
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == FMMDSTRID.MANDT
  • I_FUNDSMGMTBDGTDOCITMCUBE.FUNCTIONALAREASUBDIVISIONID == FMMDSTRID.STR_ID
  • I_FUNDSMGMTBDGTDOCITMCUBE.[column in domain "FM_MASDAT_ID"] == FMMDSTRID.MASDAT_ID
Funds Center Subdivision ID
  • Funds Center Subdivision ID
  • Client
  • ?
  • I_FUNDSMGMTBDGTDOCITMCUBE.FUNDSCENTERSUBDIVISIONID == FMMDSTRID.STR_ID
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == FMMDSTRID.MANDT
  • I_FUNDSMGMTBDGTDOCITMCUBE.[column in domain "FM_MASDAT_ID"] == FMMDSTRID.MASDAT_ID
Grants Management: Authorization Groups
  • Grants Management: Authorization Groups
  • Client
  • ?
  • I_FUNDSMGMTBDGTDOCITMCUBE.GRANTAUTHZNGRP == GMAUTHGRP.AUTHGROUP
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == GMAUTHGRP.CLIENT
  • I_FUNDSMGMTBDGTDOCITMCUBE.[column in domain "GM_OBJECT"] == GMAUTHGRP.OBJECT
Grant
  • Client
  • Grant
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == GMGR.CLIENT
  • I_FUNDSMGMTBDGTDOCITMCUBE.GRANTID == GMGR.GRANT_NBR
Lifecycle Status I_FUNDSMGMTBDGTDOCITMCUBE.GRANTLIFECYCLESTATUS == TJ02.ISTAT
Original Application
  • Client
  • Original Application
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == BUTECHORG.CLIENT
  • I_FUNDSMGMTBDGTDOCITMCUBE.ORIGINALBUDGETINGAPPLICATION == BUTECHORG.TECHORG
Reference procedure I_FUNDSMGMTBDGTDOCITMCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Client
  • Transaction Currency
  • I_FUNDSMGMTBDGTDOCITMCUBE.MANDT == TCURC.MANDT
  • I_FUNDSMGMTBDGTDOCITMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS