I_EarmarkedFundsItem

DEPRECATED -> use I_EarmarkedFundsDocumentItem | view: IEFDITEM | TRAN | Extraction: Not supported | Component: Funds Management
Tables used: KBLKKBLPFM01AUFKPRPSFINSC_PERIOD
Column Name Description
EarmarkedFunds FK Document Number for Earmarked Funds
EarmarkedFundsItem Earmarked Funds: Document Item
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
CreationDate Entered On
LastChangeDate Date of Last Change
DueDate Costs Due On
EmrkdFndsItmCompletionDate Completed On
Column Name Description
EarmarkedFundsDocumentCategory Earmarked Funds Document Category Show values
EmrkdFndsItmPrdcssrDocCat Reference Doc.Category: Funds Precommitment or Reservation Show values
EmrkdFndsItmPrdcssrCompleted Used earmarked funds are set to "Completed". Show values
EmrkdFndsItmIsCompleted Completion Indicator for Line 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
EmrkdFndsItmNoCarryforward Do Not Carry Forward Open Documents in the Fiscal Year Chge Show values
EmrkdFndsAcctAssgmtChangeable FM 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
EarmarkedFundsDocumentType Document Type: Manual Document Entry KBLART
FiscalYear Fiscal Year GJAHR
CreatedByUser Entered By USNAM
LastChangeUser Last Changed By USNAM
InternalOrderDescription Internal Order Description TEXT40
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSDescription WBS Element Name TEXT40
ProjectNetwork Network Number for Account Assignment AUFNR
CommitmentItem Commitment Item FM_FIPEX
CommitmentItemFiscalYear Fiscal Year of Commitment Item GJAHR
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
EmrkdFndsItmPredecessor Reference Document Number: Reservation/Funds Precommitment KBLNR
EmrkdFndsItmPrdcssrItem Item in Reference Document KBLPOS
EmrkdFndsItmToleranceLmtInPct Tolerance Limit for Overrun PRZ31
EmrkdFndsItmIsApproved Item Approved CHAR1
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • I_EARMARKEDFUNDSITEM.COMPANYCODE == T001.BUKRS
  • I_EARMARKEDFUNDSITEM.MANDT == T001.MANDT
Controlling area
  • Controlling Area
  • Client
  • I_EARMARKEDFUNDSITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_EARMARKEDFUNDSITEM.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • Costs Due On
  • Controlling Area
  • Client
  • I_EARMARKEDFUNDSITEM.COSTCENTER == CSKS.KOSTL
  • I_EARMARKEDFUNDSITEM.DUEDATE == CSKS.DATBI
  • I_EARMARKEDFUNDSITEM.CONTROLLINGAREA == CSKS.KOKRS
  • I_EARMARKEDFUNDSITEM.MANDT == CSKS.MANDT
Cost element
  • Cost Element
  • ?
  • Client
  • I_EARMARKEDFUNDSITEM.COSTELEMENT == CSKA.KSTAR
  • I_EARMARKEDFUNDSITEM.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_EARMARKEDFUNDSITEM.MANDT == CSKA.MANDT
Vendor number
  • Account Number of Supplier
  • Client
  • I_EARMARKEDFUNDSITEM.CREDITOR == LFA1.LIFNR
  • I_EARMARKEDFUNDSITEM.MANDT == LFA1.MANDT
Customer Number
  • Client
  • Customer Number
  • I_EARMARKEDFUNDSITEM.MANDT == KNA1.MANDT
  • I_EARMARKEDFUNDSITEM.DEBTOR == KNA1.KUNNR
Earmarked Funds Item Block
  • Client
  • Earmarked Funds Item Block
  • I_EARMARKEDFUNDSITEM.MANDT == FMRESLOCKS.MANDT
  • I_EARMARKEDFUNDSITEM.EMRKDFNDSITMMANUALEDITBLOCK == FMRESLOCKS.LOCKTYPE
Financial Management Area
  • Client
  • Financial Management Area
  • I_EARMARKEDFUNDSITEM.MANDT == FM01.MANDT
  • I_EARMARKEDFUNDSITEM.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Functional Area
  • Functional Area
  • Client
  • I_EARMARKEDFUNDSITEM.FUNCTIONALAREA == TFKB.FKBER
  • I_EARMARKEDFUNDSITEM.MANDT == TFKB.MANDT
Fund
  • Fund
  • Client
  • Financial Management Area
  • I_EARMARKEDFUNDSITEM.FUND == FMFINCODE.FINCODE
  • I_EARMARKEDFUNDSITEM.MANDT == FMFINCODE.MANDT
  • I_EARMARKEDFUNDSITEM.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
Funds Center
  • ?
  • Client
  • Financial Management Area
  • Funds Center
  • I_EARMARKEDFUNDSITEM.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • I_EARMARKEDFUNDSITEM.MANDT == FMFCTR.MANDT
  • I_EARMARKEDFUNDSITEM.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_EARMARKEDFUNDSITEM.FUNDSCENTER == FMFCTR.FICTR
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • I_EARMARKEDFUNDSITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_EARMARKEDFUNDSITEM.MANDT == SKA1.MANDT
  • I_EARMARKEDFUNDSITEM.GLACCOUNT == SKA1.SAKNR
Order number
  • Order Number
  • Client
  • I_EARMARKEDFUNDSITEM.INTERNALORDER == AUFK.AUFNR
  • I_EARMARKEDFUNDSITEM.MANDT == AUFK.MANDT
Material number
  • Client
  • Material Number
  • I_EARMARKEDFUNDSITEM.MANDT == MARA.MANDT
  • I_EARMARKEDFUNDSITEM.MATERIAL == MARA.MATNR
Transaction currency = document currency
  • Client
  • Transaction Currency
  • I_EARMARKEDFUNDSITEM.MANDT == TCURC.MANDT
  • I_EARMARKEDFUNDSITEM.TRANSACTIONCURRENCY == TCURC.WAERS