ESH_S_EFD_COAA

Search view -EFD_COAA | view: ESH_U_EFD_COAA | TRAN | Extraction: Not supported | Component: Funds Management
Tables used: KBLKKBLPFMIOIT001TKA02TKA01TKBBATFM01T000FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Transaction Currency (TRANSACTIONCURRENCY):
EMRKDFNDSAMOUNTINTRANSCRCY Total Reserved Amount in Transaction Currency
Column Name Description
Column Name Description
Column Name Description
EARMARKEDFUNDSDOCUMENTCATEGORY Document Category of an Earmarked Funds Document Show values
Column Name Description Domain name
BUDGETPERIOD Budget Period FM_BUDGET_PERIOD
COMPANYCODENAME Name of Company Code or Company TEXT25
CONTROLLINGAREANAME Controlling Area Name TEXT25
DOCUMENTITEMTEXT Item Text TEXT50
EARMARKEDFUNDSDOCCATEGORYTEXT Short Text for Fixed Values
EARMARKEDFUNDSDOCTYPETEXT Text of the Document Type of an Earmarked Funds Document
EARMARKEDFUNDSDOCUMENTITEM Document Item for Earmarked Funds
EARMARKEDFUNDSDOCUMENTTYPE Earmarked Fund Document Type
GRANTID Grant GM_GRANT_NBR
PROJECTNETWORK Network Number for Account Assignment AUFNR
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • ESH_S_EFD_COAA.COMPANYCODE == T001.BUKRS
  • ESH_S_EFD_COAA.MANDT == T001.MANDT
Controlling area
  • Client
  • Controlling Area
  • ESH_S_EFD_COAA.MANDT == TKA01.MANDT
  • ESH_S_EFD_COAA.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • Client
  • ?
  • Controlling Area
  • ESH_S_EFD_COAA.COSTCENTER == CSKS.KOSTL
  • ESH_S_EFD_COAA.MANDT == CSKS.MANDT
  • ESH_S_EFD_COAA.[column in domain "DATBI"] == CSKS.DATBI
  • ESH_S_EFD_COAA.CONTROLLINGAREA == CSKS.KOKRS
Cost element
  • ?
  • Client
  • Cost Element
  • ESH_S_EFD_COAA.[column in domain "KTOPL"] == CSKA.KTOPL
  • ESH_S_EFD_COAA.MANDT == CSKA.MANDT
  • ESH_S_EFD_COAA.COSTELEMENT == CSKA.KSTAR
Functional Area
  • Functional Area
  • Client
  • ESH_S_EFD_COAA.FUNCTIONALAREA == TFKB.FKBER
  • ESH_S_EFD_COAA.MANDT == TFKB.MANDT
Fund
  • Client
  • ?
  • Fund
  • ESH_S_EFD_COAA.MANDT == FMFINCODE.MANDT
  • ESH_S_EFD_COAA.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • ESH_S_EFD_COAA.FUND == FMFINCODE.FINCODE
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • ESH_S_EFD_COAA.[column in domain "KTOPL"] == SKA1.KTOPL
  • ESH_S_EFD_COAA.MANDT == SKA1.MANDT
  • ESH_S_EFD_COAA.GLACCOUNT == SKA1.SAKNR
Order number
  • Client
  • Order Number
  • ESH_S_EFD_COAA.MANDT == AUFK.MANDT
  • ESH_S_EFD_COAA.INTERNALORDER == AUFK.AUFNR
Transaction currency = document currency
  • Client
  • Transaction Currency
  • ESH_S_EFD_COAA.MANDT == TCURC.MANDT
  • ESH_S_EFD_COAA.TRANSACTIONCURRENCY == TCURC.WAERS