I_EarmarkedFundsDocumentItem

Earmarked Funds Document Item | view: IEMRKDFNDSDOCITM | TRAN | Extraction: Not supported | Component: Funds Management
Tables used: KBLK, KBLP, FMIOI, FM01, FINSC_FISC_DATE
Column Name Description
EarmarkedFundsDocument FK Document Number for Earmarked Funds
EarmarkedFundsDocumentItem Document Item for Earmarked Funds
Column Name Description
💲 Transaction Currency (TransactionCurrency):
EmrkdFndsAmountInTransCrcy Total Reserved Amount in Transaction Currency
EmrkdFndsRelAmtInTransCrcy Item Amount to Be Released (Transaction Currency)
EmrkdFndsOpenAmtInTransCrcy Open Amount in Transaction Currency
EmrkdFndsChgdAmtInTransCrcy Amount Change to Be Approved (Transaction Currency)
EmrkdFndsCnsmdAmtInTransCrcy Funds Reservation Amount Reduced
EmrkdFndsOriglAmtInTransCrcy Original Amount in Transaction Currency
💲 Local currency key (CompanyCodeCurrency):
EmrkdFndsAmountInCCCrcy Total Reserved Amount in Local Currency
EmrkdFndsRelAmtInCCCrcy Item Amount to Be Released (Local Currency)
EmrkdFndsOpenAmtInCCCrcy Open Amount in Local Currency
EmrkdFndsChgdAmtInCCCrcy Amount Change to Be Approved (Local Currency)
EmrkdFndsCnsmdAmtInCCCrcy Funds Reservation Amount Reduced
EmrkdFndsOriglAmtInCCCrcy Original Amount in Local Currency
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
EmrkdFndsDocItmCreationDate Entered On
LastChangeDate Date of Last Change
EmrkdFndsDocItmLastChangeDate Date of Last Change
DueDate Costs Due On
EmrkdFndsItmCompletionDate Completed On
Column Name Description
EmrkdFndsItmPrdcssrDocCat Reference Doc.Category: Funds Precommitment or Reservation Show values
EmrkdFndsItmPrdcssrCompleted Used earmarked funds are set to "Completed". Show values
EmrkdFndsItmIsCompleted Completion Indicator for Earmarked Funds Document Item Show values
EmrkdFndsItmIsStatistical Funds Management Statistical Indicator Show values
EmrkdFndsItmIsDeleted Deletion Indicator Show values
EmrkdFndsItmIsSender Indicator: Sender Show values
EmrkdFndsItmIsReceiver Indicator: Receiver Show values
EmrkdFndsItmIsBlkdAgainstUsage Blocking Indicator (Item) Show values
EmrkdFndsItmIsUnlimited Usage May Exceed Reserved Amount Without Limit Show values
EmrkdFndsOverrideGlobTolerance Indicator: Override Global (Percentage-Based) Tolerance Show values
EmrkdFndsItmIsApproved Earmarked Funds Item Is Approved Show values
EmrkdFndsItmNoCarryforward Do Not Carry Forward Open Documents in the Fiscal Year Chge Show values
EmrkdFndsAcctAssgmtChangeable Account Assignment Can Be Changed in Follow-On Document Show values
EmrkdFndsHasValueAdjustments Indicator: Amount Change Only with Value Adjustment Document Show values
EmrkdFndsItmCnsmpnInCCCrcyOnly Reduction in Local Currency Only Show values
Column Name Description Domain name
FinMgmtAreaFiscalYear null
EmrkdFndsDocItmCreatedByUser Entered By USNAM
EmrkdFndsDocItmLastChgdByUsr Last Changed By USNAM
ProjectNetwork Network Number for Account Assignment AUFNR
CommitmentItemFiscalYear null
CommitmentItem Commitment Item FM_FIPEX
FundedProgram Funded Program FM_MEASURE
BudgetPeriod Budget Period FM_BUDGET_PERIOD
GrantID Grant GM_GRANT_NBR
BusinessArea Business Area GSBER
AlternativePayee Account Number of the Alternative Payee LIFNR
DocumentItemText Item Text TEXT50
ReferenceDocumentItem Reference line item AWPOS
EmrkdFndsDocItmGroupingNumber Grouping Number for Earmarked Funds NUMC10
EmrkdFndsItmPredecessor Reference Document Number: Reservation/Funds Precommitment KBLNR
EmrkdFndsItmPrdcssrItem Item in Reference Document KBLPOS
PrdcssrFundsReservationDoc Referenced Funds Reservation KBLNR
PrdcssrFundsReservationDocItem Item in Referenced Funds Reservation KBLPOS
PrdcssrFundsPreCmtmtDoc Referenced Funds Precommitment KBLNR
PrdcssrFundsPreCmtmtDocItem Item in Referenced Funds Precommitment KBLPOS
EmrkdFndsItmToleranceLmtInPct Tolerance Limit for Overrun PRZ31
EmrkdFndsDocItmNmbrOfProcgItms Number of Development Record in KBLE NUMC5
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.COMPANYCODE == T001.BUKRS
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == T001.MANDT
Controlling area
  • Controlling Area
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == TKA01.MANDT
Cost Center
  • Costs Due On
  • Controlling Area
  • Client
  • Cost Center
  • I_EARMARKEDFUNDSDOCUMENTITEM.DUEDATE == CSKS.DATBI
  • I_EARMARKEDFUNDSDOCUMENTITEM.CONTROLLINGAREA == CSKS.KOKRS
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == CSKS.MANDT
  • I_EARMARKEDFUNDSDOCUMENTITEM.COSTCENTER == CSKS.KOSTL
Cost element
  • Cost Element
  • Client
  • ?
  • I_EARMARKEDFUNDSDOCUMENTITEM.COSTELEMENT == CSKA.KSTAR
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == CSKA.MANDT
  • I_EARMARKEDFUNDSDOCUMENTITEM.[column in domain "KTOPL"] == CSKA.KTOPL
Customer Number
  • Customer Number
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.CUSTOMER == KNA1.KUNNR
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == KNA1.MANDT
Earmarked Funds Item Block
  • Earmarked Funds Item Block
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.EMRKDFNDSITMMANUALEDITBLOCK == FMRESLOCKS.LOCKTYPE
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == FMRESLOCKS.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == FM01.MANDT
Functional Area
  • Client
  • Functional Area
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == TFKB.MANDT
  • I_EARMARKEDFUNDSDOCUMENTITEM.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Fund
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_EARMARKEDFUNDSDOCUMENTITEM.FUND == FMFINCODE.FINCODE
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == FMFINCODE.MANDT
Funds Center
  • Financial Management Area
  • Client
  • ?
  • Funds Center
  • I_EARMARKEDFUNDSDOCUMENTITEM.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == FMFCTR.MANDT
  • I_EARMARKEDFUNDSDOCUMENTITEM.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • I_EARMARKEDFUNDSDOCUMENTITEM.FUNDSCENTER == FMFCTR.FICTR
G/L Account Number
  • G/L Account Number
  • Client
  • ?
  • I_EARMARKEDFUNDSDOCUMENTITEM.GLACCOUNT == SKA1.SAKNR
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == SKA1.MANDT
  • I_EARMARKEDFUNDSDOCUMENTITEM.[column in domain "KTOPL"] == SKA1.KTOPL
Order number
  • Order Number
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.INTERNALORDER == AUFK.AUFNR
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == AUFK.MANDT
Material number
  • Client
  • Product Number
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == MARA.MANDT
  • I_EARMARKEDFUNDSDOCUMENTITEM.PRODUCT == MARA.MATNR
Vendor number
  • Account Number of Supplier
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.SUPPLIER == LFA1.LIFNR
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == LFA1.MANDT
Transaction currency = document currency
  • Transaction Currency
  • Client
  • I_EARMARKEDFUNDSDOCUMENTITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_EARMARKEDFUNDSDOCUMENTITEM.MANDT == TCURC.MANDT