I_EarmarkedFunds

DEPRECATED -> use I_EarmarkedFundsDocument | view: IEFDOCUMENT | TRAN | Extraction: Not supported | Component: Funds Management
Tables used: KBLKKBLPKBLKKBLKT001TKA02
Column Name Description
EarmarkedFunds Document Number 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 Value in Local Currency
EmrkdFndsRelAmtInCCCrcy Item Amount to Be Released (Local Currency)
EmrkdFndsOpenAmtInCCCrcy Open Amount (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
DocumentDate Document Date in Document
ExchangeRateDate Translation date
CreationDate Entered On
LastChangeDate Date of Last Change
Column Name Description
EarmarkedFundsDocumentCategory Earmarked Funds Document Category Show values
EarmarkedFundsHasLongText Long Text Exists Show values
EmrkdFndsIsMarkedForArchiving Indicator: Earmarked for Archiving Show values
EmrkdFndsHasNegativeAmounts Indicator: Document Has Negative Amounts Show values
EmrkdFndsIsBlockedAgainstUsage Blocking Indicator (Header) Show values
EarmarkedFundsIsCompleted Indicator: Final Completion (Paid) Show values
EmrkdFndsHasAddlCnsmpnLogic Additive Consumption Logic of Earmarked Funds Show values
EarmarkedFundsStartWorkflow Start Workflow Show values
EmrkdFndsHasValueAdjustments Changes to Doc. Amounts Only Using Value Adjustment Docs Show values
EarmarkedFundsEntryStatus Document Entry Status (Posted, Parked) Show values
Column Name Description Domain name
EarmarkedFundsDocumentType Earmarked Fund Document Type FMRE_BLART
CompanyCodeName Name of Company Code or Company TEXT25
DocumentReferenceID Reference Document Number XBLNR1
EarmarkedFundsHeaderText Document Header Text TEXT50
ExchangeRate Exchange rate KURSF
CreatedByUser Entered By USNAM
LastChangeUser Last Changed By USNAM
ReferenceDocumentType Reference procedure AWTYP
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Organizational Units AWORG
ReferenceDocumentLogicalSystem Logical system of source document LOGSYS
EarmarkedFundsIsApproved Indicator: Document Is Approved CHAR1
EmrkdFndsWasAlreadyAprvdOnce Document Already Approved Once CHAR1
EarmarkedFundsDecisionReason Reason for Decision for Workflow FMREASON
Master Data Relations Join Conditions
Company code
  • Client
  • Company Code
  • I_EARMARKEDFUNDS.MANDT == T001.MANDT
  • I_EARMARKEDFUNDS.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_EARMARKEDFUNDS.MANDT == TKA01.MANDT
  • I_EARMARKEDFUNDS.CONTROLLINGAREA == TKA01.KOKRS
Funds Precommitment Document Block
  • Client
  • Funds Precommitment Document Block
  • I_EARMARKEDFUNDS.MANDT == FMRESLOCKS.MANDT
  • I_EARMARKEDFUNDS.EARMARKEDFUNDSMANUALEDITBLOCK == FMRESLOCKS.LOCKTYPE
Financial Management Area
  • Client
  • Financial Management Area
  • I_EARMARKEDFUNDS.MANDT == FM01.MANDT
  • I_EARMARKEDFUNDS.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Transaction currency = document currency
  • Client
  • Transaction Currency
  • I_EARMARKEDFUNDS.MANDT == TCURC.MANDT
  • I_EARMARKEDFUNDS.TRANSACTIONCURRENCY == TCURC.WAERS