I_BudgetEntryItemSearch

Budget Entry Item Search | view: IFMBDGECDOCS | Extraction: Not supported | Component: Budget Control System
Tables used: FMBCSSUBDIVFMBL, FMBDP, FMBH, FMBL, BUBUDCATT, FMBUDGETPD, FMBUDTYPE, FMBUDTYPET, BUVALTYPE, BUVALTYPET, FMCI, FMHICI, FM01, FMFINCODE, FMMEASURE, TFKB, FMFUNDBPD, GMGR, GMGRANTNONE, GMGRTYPE, BUPROCESS, BUPROCESST, 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
💲 Transaction Currency (TransactionCurrency):
BudgetAmountInTransactionCrcy Budget Amount in Transaction Currency in Funds Management
💲 Financial Management Area Currency (FinancialManagementAreaCrcy):
BudgetAmountInFMACrcy Budget Amount in Financial Management Area Currency
Column Name Description
Column Name Description
BudgetChangeDocCreationDate Budget Change Document Creation Date
CreationDate Date on which the object was created or updated
LastChangeDate Date on which the object was changed
BudgetEntryDocumentDate Document Date
FinMgmtAreaFiscalYearEndDate End Date of Next Fiscal Year
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
BudgetDocumentYear Budget Entry Document Year GJAHR
BudgetEntryDocument Budget Entry Document Number
BudgetEntryDocumentItem Budget Entry Document Line
BudgetedFund Budgeted Fund BP_GEBER
BudgetedFundsCenter Budgeted Funds Center FISTL
BudgetedCommitmentItem Budgeted Commitment Item FM_FIPEX
BudgetedFunctionalArea Budgeted Functional Area FKBER
BudgetedFundedProgram Budgeted Funded Program FM_MEASURE
BudgetedBudgetPeriod Budgeted Budget Period FM_BUDGET_PERIOD
BudgetedFundsMgmtCustomerField Budgeted Customer Field for FM 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
CreatedByUser User Who Created or Updated the Object USERNAME
LastChangedByUser Last user to change object USERNAME
BudgetEntryDocumentDescription Header Text for Budget Entry Document TEXT50
ReversalReason Reason for Reversal of Budget Document STGRD
ReversalRefBudgetEntryDocument Reversal Reference Document Number BELNR
LogicalSystem Logical system LOGSYS
FiscalTreasuryLoanCohort Reporting Year for Cohort FM_COHORT
PublicLaw Public Law Cited FM_PUBLAW
FiscalTreasuryLegislationType Type of Legislation FM_LEGIS
FiscalTreasuryAgency Transfer Agency FMFG_TRANSFER
FiscalTreasuryBudgetAccount Transfer Account FMFG_TRAN_ACCT
PartnerCompany Company ID of Trading Partner RCOMP
BudgetEntryDocDistributionKey Distribution Key SPRED
BudgetEntryDocItemDescription Item Text TEXT50
ReferenceDocument Reference document number AWREF
ReferenceDocumentFiscalYear Fiscal Year GJAHR
ReferenceDocumentItem Six-Digit Number of the Reference Posting Line BUZEI6
ReferenceDocumentContext Reference Organizational Units AWORG
CommitmentItemAuthznGrp Authorization Group for Commitment Item CHAR10
FundAuthznGrp Fund Authorization Group CHAR10
FunctionalAreaAuthznGrp FM: Authorization Group of Functional Area CHAR10
FundedPgmFinMgmtAreaForAuthzn FM Area for Auth Grp for Funded Program CHAR04
BudgetPeriodAuthznGrp Budget Period Authorization Group CHAR10
BudgetCategoryName Text (15 characters) TEXT15
BudgetEntryDocumentStatusName Budget Document Status Name TEXT45
InternalBudgetingProcessName Budgeting Process Name (with sender/receiver) TEXT15
BudgetTypeName1 Budget type short text (5) TEXT5
BudgetValueTypeName Budget Value Type Name TEXT15
Master Data Relations Join Conditions
Budget Category
  • Client
  • Budget Category
  • I_BUDGETENTRYITEMSEARCH.MANDT == T881.MANDT
  • I_BUDGETENTRYITEMSEARCH.BUDGETCATEGORY == T881.RLDNR
Budgeted Grant
  • Client
  • Budgeted Grant
  • I_BUDGETENTRYITEMSEARCH.MANDT == GMGR.CLIENT
  • I_BUDGETENTRYITEMSEARCH.BUDGETEDGRANTID == GMGR.GRANT_NBR
Budget entry document type
  • Client
  • Budget entry document type
  • I_BUDGETENTRYITEMSEARCH.MANDT == FMEDDOCTYPE.CLIENT
  • I_BUDGETENTRYITEMSEARCH.BUDGETENTRYDOCUMENTTYPE == FMEDDOCTYPE.DOCTYPE
Budget Version
  • Client
  • Budget Version
  • I_BUDGETENTRYITEMSEARCH.MANDT == TKVS.MANDT
  • I_BUDGETENTRYITEMSEARCH.BUDGETVERSION == TKVS.VERSI
Financial Management Area Currency
  • Financial Management Area Currency
  • Client
  • I_BUDGETENTRYITEMSEARCH.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
  • I_BUDGETENTRYITEMSEARCH.MANDT == TCURC.MANDT
Functional Area Subdivision ID
  • Client
  • ?
  • Functional Area Subdivision ID
  • I_BUDGETENTRYITEMSEARCH.MANDT == FMMDSTRID.MANDT
  • I_BUDGETENTRYITEMSEARCH.[column in domain "FM_MASDAT_ID"] == FMMDSTRID.MASDAT_ID
  • I_BUDGETENTRYITEMSEARCH.FUNCTIONALAREASUBDIVISIONID == FMMDSTRID.STR_ID
Grants Management: Authorization Groups
  • Client
  • Grants Management: Authorization Groups
  • ?
  • I_BUDGETENTRYITEMSEARCH.MANDT == GMAUTHGRP.CLIENT
  • I_BUDGETENTRYITEMSEARCH.GRANTAUTHZNGRP == GMAUTHGRP.AUTHGROUP
  • I_BUDGETENTRYITEMSEARCH.[column in domain "GM_OBJECT"] == GMAUTHGRP.OBJECT
Original Application
  • Client
  • Original Application
  • I_BUDGETENTRYITEMSEARCH.MANDT == BUTECHORG.CLIENT
  • I_BUDGETENTRYITEMSEARCH.ORIGINALBUDGETINGAPPLICATION == BUTECHORG.TECHORG
Reference procedure I_BUDGETENTRYITEMSEARCH.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Client
  • Transaction Currency
  • I_BUDGETENTRYITEMSEARCH.MANDT == TCURC.MANDT
  • I_BUDGETENTRYITEMSEARCH.TRANSACTIONCURRENCY == TCURC.WAERS