C_EmrkdFndsDocumentItemVH

Emrkd Fnds Itm Value Help for Manage App | view: CEFDITMVH | TRAN | Extraction: Not supported | Component: Earmarked Funds and Funds Transfers
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
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 Character field length 24 CHAR24
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
  • Client
  • Company Code
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == T001.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == TKA01.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Costs Due On
  • Controlling Area
  • Cost Center
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == CSKS.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.DUEDATE == CSKS.DATBI
  • C_EMRKDFNDSDOCUMENTITEMVH.CONTROLLINGAREA == CSKS.KOKRS
  • C_EMRKDFNDSDOCUMENTITEMVH.COSTCENTER == CSKS.KOSTL
Cost element
  • Cost Element
  • Client
  • ?
  • C_EMRKDFNDSDOCUMENTITEMVH.COSTELEMENT == CSKA.KSTAR
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == CSKA.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.[column in domain "KTOPL"] == CSKA.KTOPL
Customer Number
  • Customer Number
  • Client
  • C_EMRKDFNDSDOCUMENTITEMVH.CUSTOMER == KNA1.KUNNR
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == KNA1.MANDT
Financial Management Area
  • Client
  • Financial Management Area
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == FM01.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Functional Area
  • Functional Area
  • Client
  • C_EMRKDFNDSDOCUMENTITEMVH.FUNCTIONALAREA == TFKB.FKBER
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == TFKB.MANDT
Fund
  • Client
  • Financial Management Area
  • Fund
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == FMFINCODE.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_EMRKDFNDSDOCUMENTITEMVH.FUND == FMFINCODE.FINCODE
Funds Center
  • ?
  • Client
  • Financial Management Area
  • Funds Center
  • C_EMRKDFNDSDOCUMENTITEMVH.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == FMFCTR.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • C_EMRKDFNDSDOCUMENTITEMVH.FUNDSCENTER == FMFCTR.FICTR
G/L Account Number
  • Client
  • ?
  • G/L Account Number
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == SKA1.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_EMRKDFNDSDOCUMENTITEMVH.GLACCOUNT == SKA1.SAKNR
Order number
  • Client
  • Order Number
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == AUFK.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.INTERNALORDER == AUFK.AUFNR
Material number
  • Client
  • Product Number
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == MARA.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.PRODUCT == MARA.MATNR
Vendor number
  • Client
  • Account Number of Supplier
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == LFA1.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.SUPPLIER == LFA1.LIFNR
Transaction currency = document currency
  • Client
  • Transaction Currency
  • C_EMRKDFNDSDOCUMENTITEMVH.MANDT == TCURC.MANDT
  • C_EMRKDFNDSDOCUMENTITEMVH.TRANSACTIONCURRENCY == TCURC.WAERS