I_EmrkdFndsDocumentItemStdVH

Earmarked Funds Doc. Item Std Value Help | view: IEFDITMSTDVH | TRAN | Extraction: Not supported | Component: Funds Management
Tables used: KBLK, KBLP, FMIOI, FM01, PRPS, 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):
EmrkdFndsOpenAmtInTransCrcy Open Amount in Transaction Currency
Column Name Description
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
EmrkdFndsDocItmCreationDate Entered On
EmrkdFndsDocItmLastChangeDate Date of Last Change
DueDate Costs Due On
Column Name Description
EarmarkedFundsDocumentCategory Document Category of an Earmarked Funds Document Show values
EarmarkedFundsDocEntryStatus Document Entry Status (Posted, Parked) Show values
EmrkdFndsItmIsCompleted Completion Indicator for Earmarked Funds Document Item Show values
EmrkdFndsItmIsBlkdAgainstUsage Blocking Indicator (Item) Show values
EmrkdFndsItmIsApproved Earmarked Funds Item Is Approved Show values
Column Name Description Domain name
EarmarkedFundsDocumentType Earmarked Fund Document Type FMRE_BLART
EmrkdFndsDocItmCreatedByUser Entered By USNAM
EmrkdFndsDocItmLastChgdByUsr Last Changed By USNAM
DocumentItemText Item Text TEXT50
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSDescription WBS Element Name TEXT40
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
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.COMPANYCODE == T001.BUKRS
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == T001.MANDT
Controlling area
  • Controlling Area
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.CONTROLLINGAREA == TKA01.KOKRS
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • Controlling Area
  • Costs Due On
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.COSTCENTER == CSKS.KOSTL
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.CONTROLLINGAREA == CSKS.KOKRS
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.DUEDATE == CSKS.DATBI
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == CSKS.MANDT
Cost element
  • ?
  • Cost Element
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.COSTELEMENT == CSKA.KSTAR
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == CSKA.MANDT
Customer Number
  • Customer Number
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.CUSTOMER == KNA1.KUNNR
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == KNA1.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == FM01.MANDT
Functional Area
  • Functional Area
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.FUNCTIONALAREA == TFKB.FKBER
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == TFKB.MANDT
Fund
  • Financial Management Area
  • Fund
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.FUND == FMFINCODE.FINCODE
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == FMFINCODE.MANDT
Funds Center
  • Funds Center
  • ?
  • Financial Management Area
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.FUNDSCENTER == FMFCTR.FICTR
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == FMFCTR.MANDT
G/L Account Number
  • G/L Account Number
  • ?
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.GLACCOUNT == SKA1.SAKNR
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == SKA1.MANDT
Order number
  • Order Number
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.INTERNALORDER == AUFK.AUFNR
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == AUFK.MANDT
Material number
  • Product Number
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.PRODUCT == MARA.MATNR
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == MARA.MANDT
Vendor number
  • Account Number of Supplier
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.SUPPLIER == LFA1.LIFNR
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == LFA1.MANDT
Transaction currency = document currency
  • Transaction Currency
  • Client
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_EMRKDFNDSDOCUMENTITEMSTDVH.MANDT == TCURC.MANDT