I_FundsMgmtAvailyCtrlItmC

Funds Management AVC - Cube | view: IFMAVCITMANC | TRAN | Extraction: Not supported | Component: Information system
Tables used: FMAVCP, FMAVCT, FMAVCT_RECON_YR, FMBUDGETPD, FMCI, FMHICI, FM01, BUAVCSRC, FMFINCODE, FMMEASURE, FMFCTR, TFKB, GMGR, GMGRANTNONE, GMGRTYPE, BUAVCLDGR, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
FinancialManagementArea FK Financial Management Area
AvailabilityControlLedger FK Control Ledger
FinMgmtAreaFiscalYear Fiscal Year
ControlObjectGrantID FK Grant in Control Object
ControlObjectBudgetPeriod Budget Period in Control Object
ControlObjectCommitmentItem Commitment Item in Control Object
ControlObjectFunctionalArea Functional Area in Control Object
ControlObjectFund Fund in Control Object
ControlObjectFundedProgram Funded Program in Control Object
ControlObjectFundsCenter Funds Center in Control Object
CtrlObjFundsMgmtCustomerField Customer Field in Control Object
BdgtCashEffectivityFiscalYear Year of Cash Effectivity in Budgeting
ControlObjectCoverGroup Cover Group in Control Object
FinancialManagementAreaCrcy FK Financial Management Area Currency
Column Name Description
💲 Financial Management Area Currency (FinancialManagementAreaCrcy):
AvailableAmountInFMACrcy Available Amount
ConsumableAmountInFMACrcy Consumable Amount
ConsumedAmountInFMACrcy Consumed Amount
Column Name Description
Column Name Description
ReferenceDocumentChangeDate Reference Document Change Date in Funds Management
Column Name Description
FndsMgmtPaytCmtmtBdgtCat Budget Category in Funds Management Show values
CommitmentItemCategory Commitment Item Category Show values
GLRecordType Record Type Show values
BudgetWorkFlowStatus Workflow Status of a Record in the AVC Totals Table Show values
ControlObjectAmountType Amount Type (Availability Control) Show values
Column Name Description Domain name
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
Master Data Relations Join Conditions
Control Ledger
  • Client
  • Control Ledger
  • I_FUNDSMGMTAVAILYCTRLITMC.MANDT == T881.MANDT
  • I_FUNDSMGMTAVAILYCTRLITMC.AVAILABILITYCONTROLLEDGER == T881.RLDNR
Grant in Control Object
  • Client
  • Grant in Control Object
  • I_FUNDSMGMTAVAILYCTRLITMC.MANDT == GMGR.CLIENT
  • I_FUNDSMGMTAVAILYCTRLITMC.CONTROLOBJECTGRANTID == GMGR.GRANT_NBR
Financial Management Area
  • Client
  • Financial Management Area
  • I_FUNDSMGMTAVAILYCTRLITMC.MANDT == FM01.MANDT
  • I_FUNDSMGMTAVAILYCTRLITMC.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Financial Management Area Currency
  • Client
  • Financial Management Area Currency
  • I_FUNDSMGMTAVAILYCTRLITMC.MANDT == TCURC.MANDT
  • I_FUNDSMGMTAVAILYCTRLITMC.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_FUNDSMGMTAVAILYCTRLITMC.FINMGMTAREAFISCALYEARVARIANT == T009.PERIV
  • I_FUNDSMGMTAVAILYCTRLITMC.MANDT == T009.MANDT
Grants Management: Authorization Groups
  • Grants Management: Authorization Groups
  • ?
  • Client
  • I_FUNDSMGMTAVAILYCTRLITMC.GRANTAUTHZNGRP == GMAUTHGRP.AUTHGROUP
  • I_FUNDSMGMTAVAILYCTRLITMC.[column in domain "GM_OBJECT"] == GMAUTHGRP.OBJECT
  • I_FUNDSMGMTAVAILYCTRLITMC.MANDT == GMAUTHGRP.CLIENT
Lifecycle Status I_FUNDSMGMTAVAILYCTRLITMC.GRANTLIFECYCLESTATUS == TJ02.ISTAT