C_FundsMgmtActDocQry1

Funds Management: Actual Documents Query | view: CFMACTDOCIANQ1 | Extraction: Not supported | Component: Information system
Column Name Description
Column Name Description
💲 Financial Management Area Currency (FinancialManagementAreaCrcy):
PostedAmountInFMACrcy Actual Amount in Financial Management Area Currency
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
FundsMgmtUpdateDate Funds Management Update Date
ReferenceDocumentChangeDate Reference Document Change Date in Funds Management
Column Name Description
FundsMgmtAmountType Amount Type Show values
FundsMgCarryForwardLevel Carryforward Level Show values
FundsMgmtValueType Value Type Show values
IsStatisticalItem Funds Management Statistical Indicator Show values
FndsMgmtPaytCmtmtBdgtCat Budget Category in Funds Management Show values
FundsMgmtPredecessorDocCat Predecessor Document Category Show values
Column Name Description Domain name
FinMgmtAreaFiscalYear Fiscal Year GJAHR
FundsManagementDocumentItem Number of a posting line in a TR-FM line item NUMC03
Ledger Ledger FINS_LEDGER
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
FundsMgmtTransactionNumber Funds Management Transaction Number CHAR16
AccountingDocumentType Document Type BLART
FundsMgmtTradingPartnerCoId Company ID of Trading Partner RCOMP
ProfitCenter Profit Center PRCTR
FundsMgmtFinDocFiscalYear Fiscal year for FI document number GJAHR
FundsMgmtFinDocNumber FI document number BELNR
FundsMgmtFinDocItem FI Document Item BUZEI
FundsMgmtPaytDocFiscalYear Payment Document Fiscal Year GJAHR
FundsMgmtPaytDocNumber Payment Document Number BELNR
FundsMgmtPaytDocItem Item for Payment Document Number BUZEI
FundsMgmtPredecessorDocNumber Predecessor Document Number BELNR
FundsMgmtPredecessorDocOrg Predecessor Document Organization AWORG
FundsMgmtPredecessorDocItem Predecessor Document Item NUMC05
FundsMgmtPredecessorAcctAssgmt Predecessor Account Assignment NUM05
FundsMgmtPredecessorRefTrans Predecessor Reference Transaction AWTYP
FundsMgmtPredecessorLgclSyst Predecessor Logical System LOGSYS
ReferenceDocument Reference document number AWREF
ReferenceDocumentFiscalYear Reference fiscal year GJAHR
ReferenceDocumentItem Reference Document Line Item NUMC6
ReferenceDocumentType Reference procedure AWTYP
ReferenceDocumentContext Reference Organizational Units AWORG
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_FUNDSMGMTACTDOCQRY1.MANDT == T001.MANDT
  • C_FUNDSMGMTACTDOCQRY1.COMPANYCODE == T001.BUKRS
Customer Number
  • Customer Number
  • Client
  • C_FUNDSMGMTACTDOCQRY1.CUSTOMER == KNA1.KUNNR
  • C_FUNDSMGMTACTDOCQRY1.MANDT == KNA1.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • C_FUNDSMGMTACTDOCQRY1.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • C_FUNDSMGMTACTDOCQRY1.MANDT == FM01.MANDT
Financial Management Area Currency
  • Client
  • Financial Management Area Currency
  • C_FUNDSMGMTACTDOCQRY1.MANDT == TCURC.MANDT
  • C_FUNDSMGMTACTDOCQRY1.FINANCIALMANAGEMENTAREACRCY == TCURC.WAERS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_FUNDSMGMTACTDOCQRY1.MANDT == T009.MANDT
  • C_FUNDSMGMTACTDOCQRY1.FINMGMTAREAFISCALYEARVARIANT == T009.PERIV
Functional Area
  • Client
  • Functional Area
  • C_FUNDSMGMTACTDOCQRY1.MANDT == TFKB.MANDT
  • C_FUNDSMGMTACTDOCQRY1.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Client
  • Fund
  • C_FUNDSMGMTACTDOCQRY1.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_FUNDSMGMTACTDOCQRY1.MANDT == FMFINCODE.MANDT
  • C_FUNDSMGMTACTDOCQRY1.FUND == FMFINCODE.FINCODE
Funds Center
  • Financial Management Area
  • Client
  • Funds Center
  • Funds Management Update Date
  • C_FUNDSMGMTACTDOCQRY1.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • C_FUNDSMGMTACTDOCQRY1.MANDT == FMFCTR.MANDT
  • C_FUNDSMGMTACTDOCQRY1.FUNDSCENTER == FMFCTR.FICTR
  • C_FUNDSMGMTACTDOCQRY1.FUNDSMGMTUPDATEDATE == FMFCTR.DATBIS
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • C_FUNDSMGMTACTDOCQRY1.MANDT == LFA1.MANDT
  • C_FUNDSMGMTACTDOCQRY1.SUPPLIER == LFA1.LIFNR