P_FundsMgmtBdgtActlCmtmt

Funds Management: Commitments/Actuals and Budget | view: PFMBUDACANA | 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
FinancialManagementArea Financial Management Area
FinMgmtAreaFiscalYear Fiscal Year
BudgetPeriod Budget Period
CommitmentItem Commitment Item
FunctionalArea Functional Area
Fund Fund
FundedProgram Funded Program
FundsCenter Funds Center
GrantID FK Grant
FundsManagementCustomerField Customer Field for FM Actual and Commitment Data
FinancialManagementAreaCrcy FK Financial Management Area Currency
TransactionCurrency FK Transaction Currency
FndsMgmtAnalysisSourceTech Funds Management Analysis Source Show values
BusinessArea Business Area
CompanyCode Company Code
GLAccount General Ledger Account
FndsMgmtPaytCmtmtBdgtCat Budget Category in Funds Management Show values
FundsMgmtValueType Value Type Show values
BudgetVersion FK Budget Version
BudgetType Budget Type
InternalBudgetingProcess Internal Budgeting Process
BudgetValueType BCS Value Type
BdgtCashEffectivityFiscalYear Year of Cash Effectivity in Budgeting
BudgetCategory FK Budget Category
AvailabilityControlLedger Control Ledger
BudgetWorkFlowStatus Workflow Status of a Record in the Budget Totals Table Show values
FundsMgmtAmountType Amount Type Show values
BusinessTransactionType CO Business Transaction
IsStatisticalItem Funds Management Statistical Indicator Show values
Supplier Account Number of Supplier
Customer Customer Number
FundsMgCarryForwardLevel Carryforward Level Show values
ControlObjectCoverGroup Cover Group
ReferenceDocument Reference document number
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document
ReferenceDocumentItem Six-Digit Number of the Reference Posting Line
ReferenceDocumentType FK Reference procedure
ReferenceDocumentContext Reference Organizational Units
BudgetPeriodAuthznGrp Budget Period Authorization Group
CmtmtItemFinMgmtAreaForAuthzn FM Area for Auth Grp for Commitment Item
CommitmentItemAuthznGrp Authorization Group for Commitment Item
FndsCenterFinMgmtAreaForAuthzn Financial Management Area
FunctionalAreaAuthznGrp FM: Authorization Group of Functional Area
FundAuthznGrp Fund Authorization Group
FundFinMgmtAreaForAuthzn FM Area for Auth Grp for Fund
FundedPgmFinMgmtAreaForAuthzn FM Area for Auth Grp for Funded Program
FundedProgramAuthznGrp Funded Program Authorization Group
FundsCenterAuthznGrp Funds Center Authorization Group
GrantAuthznGrp FK Grants Management: Authorization Groups
GrantLifecycleStatus FK Lifecycle Status
FinMgmtAreaPeriod Period
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
CmtmtOpenItemAmountInFMACrcy Commitment Amount in Financial Management Area Currency
CmtmtOpenItemAmountInTransCrcy Commitment Amount in Transaction Currency in FM
ActualAmountInFMACrcy Actual Amount in Financial Management Area Currency
FndsMgmtActlAmountInTransCrcy Actual Amount in Transaction Currency in Funds Management
CtrlgItemAmountInFMACrcy Controlling Amount in Financial Management Area Currency
CtrlgItemAmountInTransCrcy Controlling Amount in Transaction Currency in FM
ConsumableAmountInFMACrcy Consumable Amount
ConsumedAmountInFMACrcy Consumed Amount
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
CommitmentItemFiscalYear null
Master Data Relations Join Conditions
Budget Category
  • Client
  • Budget Category
  • P_FUNDSMGMTBDGTACTLCMTMT.MANDT == T881.MANDT
  • P_FUNDSMGMTBDGTACTLCMTMT.BUDGETCATEGORY == T881.RLDNR
Budget entry document type
  • Client
  • Budget entry document type
  • P_FUNDSMGMTBDGTACTLCMTMT.MANDT == FMEDDOCTYPE.CLIENT
  • P_FUNDSMGMTBDGTACTLCMTMT.BUDGETENTRYDOCUMENTTYPE == FMEDDOCTYPE.DOCTYPE
Budget Version
  • Budget Version
  • Client
  • P_FUNDSMGMTBDGTACTLCMTMT.BUDGETVERSION == TKVS.VERSI
  • P_FUNDSMGMTBDGTACTLCMTMT.MANDT == TKVS.MANDT
Financial Management Area Currency
  • Client
  • Financial Management Area Currency
  • P_FUNDSMGMTBDGTACTLCMTMT.MANDT == TCURC.MANDT
  • P_FUNDSMGMTBDGTACTLCMTMT.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_FUNDSMGMTBDGTACTLCMTMT.FINMGMTAREAFISCALYEARVARIANT == T009.PERIV
  • P_FUNDSMGMTBDGTACTLCMTMT.MANDT == T009.MANDT
Grants Management: Authorization Groups
  • Client
  • ?
  • Grants Management: Authorization Groups
  • P_FUNDSMGMTBDGTACTLCMTMT.MANDT == GMAUTHGRP.CLIENT
  • P_FUNDSMGMTBDGTACTLCMTMT.[column in domain "GM_OBJECT"] == GMAUTHGRP.OBJECT
  • P_FUNDSMGMTBDGTACTLCMTMT.GRANTAUTHZNGRP == GMAUTHGRP.AUTHGROUP
Grant
  • Client
  • Grant
  • P_FUNDSMGMTBDGTACTLCMTMT.MANDT == GMGR.CLIENT
  • P_FUNDSMGMTBDGTACTLCMTMT.GRANTID == GMGR.GRANT_NBR
Lifecycle Status P_FUNDSMGMTBDGTACTLCMTMT.GRANTLIFECYCLESTATUS == TJ02.ISTAT
Reference procedure P_FUNDSMGMTBDGTACTLCMTMT.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • P_FUNDSMGMTBDGTACTLCMTMT.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_FUNDSMGMTBDGTACTLCMTMT.MANDT == TCURC.MANDT