C_FundsMgmtCmtmtDocQry1

Funds Management: Commitment Documents Query | view: CFMCMOIANQ1 | Extraction: Not supported | Component: Information system
Column Name Description
Column Name Description
💲 Financial Management Area Currency (FinancialManagementAreaCrcy):
OpenCmtmtAmountInFMACrcy Commitment Amount in Financial Management Area Currency
Column Name Description
Column Name Description
Column Name Description
FundsMgmtRefDocumentCategory Reference Document Category Show values
FundsMgmtAmountType Amount Type Show values
FndsMgmtPaytCmtmtBdgtCat Budget Category in Funds Management Show values
FundsMgCarryForwardLevel Carryforward Level Show values
FundsMgmtCmtmtCarryFwdStatus FM Commitment Carryforward: Status Show values
FundsMgmtCmtmtItemIsCompleted Completed Indicator for Open Items Show values
FundsMgmtCmtmtItemIsDeleted Deletion Indicator Show values
FundsMgmtValueType Value Type Show values
IsStatisticalItem Funds Management Statistical Indicator Show values
Column Name Description Domain name
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Organizational Units AWORG
ReferenceDocumentItem Item Number of Reference Document NUMC05
RefDocAccountAssignment Account Assignment Number of Reference Document NUMC05
ReferenceDocumentScheduleLine Reference Document Classification Number ETENR
RefDocPricingElementContent Counter Conditions and Level Number RCOND
ReferenceDocumentType Reference procedure AWTYP
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
FinMgmtAreaFiscalYear Fiscal Year GJAHR
FundsMgmtSequenceNumber Number That Clearly Identifies the Line Key in Database CHAR16
BudgetPeriod Budget Period FM_BUDGET_PERIOD
CommitmentItem Commitment Item FM_FIPEX
FundedProgram Funded Program FM_MEASURE
GrantID Grant GM_GRANT_NBR
FundsManagementCustomerField Customer Field for FM Actual and Commitment Data FM_USERDIM
BusinessArea Business Area GSBER
GLAccount General Ledger Account SAKNR
FinMgmtAreaPeriod Period PERBL
CashEffectivityFiscalYear Year of Cash Effectivity GJAHR
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
EarmarkedFundsDocumentItem Earmarked Funds: Document Item KBLPOS
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_FUNDSMGMTCMTMTDOCQRY1.MANDT == T001.MANDT
  • C_FUNDSMGMTCMTMTDOCQRY1.COMPANYCODE == T001.BUKRS
Financial Management Area
  • Client
  • Financial Management Area
  • C_FUNDSMGMTCMTMTDOCQRY1.MANDT == FM01.MANDT
  • C_FUNDSMGMTCMTMTDOCQRY1.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Financial Management Area Currency
  • Client
  • Financial Management Area Currency
  • C_FUNDSMGMTCMTMTDOCQRY1.MANDT == TCURC.MANDT
  • C_FUNDSMGMTCMTMTDOCQRY1.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_FUNDSMGMTCMTMTDOCQRY1.MANDT == T009.MANDT
  • C_FUNDSMGMTCMTMTDOCQRY1.FINMGMTAREAFISCALYEARVARIANT == T009.PERIV
Functional Area
  • Client
  • Functional Area
  • C_FUNDSMGMTCMTMTDOCQRY1.MANDT == TFKB.MANDT
  • C_FUNDSMGMTCMTMTDOCQRY1.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Fund
  • Financial Management Area
  • C_FUNDSMGMTCMTMTDOCQRY1.MANDT == FMFINCODE.MANDT
  • C_FUNDSMGMTCMTMTDOCQRY1.FUND == FMFINCODE.FINCODE
  • C_FUNDSMGMTCMTMTDOCQRY1.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
Funds Center
  • Client
  • Funds Center
  • ?
  • Financial Management Area
  • C_FUNDSMGMTCMTMTDOCQRY1.MANDT == FMFCTR.MANDT
  • C_FUNDSMGMTCMTMTDOCQRY1.FUNDSCENTER == FMFCTR.FICTR
  • C_FUNDSMGMTCMTMTDOCQRY1.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • C_FUNDSMGMTCMTMTDOCQRY1.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
Ledger
  • Client
  • Ledger
  • C_FUNDSMGMTCMTMTDOCQRY1.MANDT == T881.MANDT
  • C_FUNDSMGMTCMTMTDOCQRY1.LEDGER == T881.RLDNR