I_EarmarkedFundsItem_Basic

DEPRECATED -> use I_EarmarkedFundsDocumentItem | view: IEFDITEMB | TRAN | Extraction: Not supported | Component: Funds Management
Tables used: KBLKKBLP
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
ProjectNetwork Network Number for Account Assignment AUFNR
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
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
  • Client
  • Company Code
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == T001.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == TKA01.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • Client
  • Costs Due On
  • Controlling Area
  • I_EARMARKEDFUNDSITEM_BASIC.COSTCENTER == CSKS.KOSTL
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == CSKS.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.DUEDATE == CSKS.DATBI
  • I_EARMARKEDFUNDSITEM_BASIC.CONTROLLINGAREA == CSKS.KOKRS
Cost element
  • Cost Element
  • Client
  • ?
  • I_EARMARKEDFUNDSITEM_BASIC.COSTELEMENT == CSKA.KSTAR
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == CSKA.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.[column in domain "KTOPL"] == CSKA.KTOPL
Vendor number
  • Client
  • Account Number of Supplier
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == LFA1.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.CREDITOR == LFA1.LIFNR
Customer Number
  • Customer Number
  • Client
  • I_EARMARKEDFUNDSITEM_BASIC.DEBTOR == KNA1.KUNNR
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == KNA1.MANDT
Earmarked Funds Item Block
  • Client
  • Earmarked Funds Item Block
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == FMRESLOCKS.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.EMRKDFNDSITMMANUALEDITBLOCK == FMRESLOCKS.LOCKTYPE
Financial Management Area
  • Financial Management Area
  • Client
  • I_EARMARKEDFUNDSITEM_BASIC.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == FM01.MANDT
Functional Area
  • Client
  • Functional Area
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == TFKB.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_EARMARKEDFUNDSITEM_BASIC.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == FMFINCODE.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.FUND == FMFINCODE.FINCODE
Funds Center
  • Financial Management Area
  • Client
  • ?
  • Funds Center
  • I_EARMARKEDFUNDSITEM_BASIC.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == FMFCTR.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • I_EARMARKEDFUNDSITEM_BASIC.FUNDSCENTER == FMFCTR.FICTR
G/L Account Number
  • Client
  • ?
  • G/L Account Number
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == SKA1.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_EARMARKEDFUNDSITEM_BASIC.GLACCOUNT == SKA1.SAKNR
Order number
  • Order Number
  • Client
  • I_EARMARKEDFUNDSITEM_BASIC.INTERNALORDER == AUFK.AUFNR
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == AUFK.MANDT
Material number
  • Client
  • Material Number
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == MARA.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.MATERIAL == MARA.MATNR
Transaction currency = document currency
  • Client
  • Transaction Currency
  • I_EARMARKEDFUNDSITEM_BASIC.MANDT == TCURC.MANDT
  • I_EARMARKEDFUNDSITEM_BASIC.TRANSACTIONCURRENCY == TCURC.WAERS