shsm_efditm

Search Help Sel. Method f. EFD Items | view: SHSTEFDITM | TRAN | Extraction: Not supported | Component: Funds Management
Tables used: KBLK, KBLP, FMIOI, KBLK, KBLP, FM01, PRPS, FINSC_FISC_DATE
Column Name Description
belnr FK Document Number for Earmarked Funds
blpos Line Item
Column Name Description
💲 Transaction Currency (waers):
wtges Total Reserved Amount in Transaction Currency
wtgesapp Item Amount to Be Released (Transaction Currency)
wtfree Open Amount in Transaction Currency
deltawtapp Amount Change to Be Approved (Transaction Currency)
wtabg Funds Reservation Amount Reduced
wtorig Original Amount in Transaction Currency
💲 Local currency key (hwaer):
hwges Total Reserved Amount in Local Currency
hwgesapp Item Amount to Be Released (Local Currency)
hwfree Open Amount in Local Currency
deltahwapp Amount Change to Be Approved (Local Currency)
hwabg Funds Reservation Amount Reduced
hworig Original Amount in Local Currency
Column Name Description
Column Name Description
crpudate Card Document: Date of Card Transaction (Purchase Date)
budat Posting Date in the Document
bldat Document Date in Document
kerdat Entered On
kaedat Date of Last Change
erdat Entered On
aedat Date of Last Change
fdatk Costs Due On
erldat Completed On
Column Name Description
crmatch Card Document: Reduction Earmarked Show values
bltyp Earmarked Funds Document Category Show values
mvstat Document Entry Status (Posted, Parked) Show values
refbltyp Reference Doc.Category: Funds Precommitment or Reservation Show values
refseterlk Used earmarked funds are set to "Completed". Show values
erlkz Completion Indicator for Earmarked Funds Document Item Show values
stats Funds Management Statistical Indicator Show values
loekz Deletion Indicator Show values
xsender Indicator: Sender Show values
xempfgr Indicator: Receiver Show values
blpkz Blocking Indicator (Item) Show values
consumekz Usage May Exceed Reserved Amount Without Limit Show values
tolov Indicator: Override Global (Percentage-Based) Tolerance Show values
wkapp Earmarked Funds Item Is Approved Show values
carryov Do Not Carry Forward Open Documents in the Fiscal Year Chge Show values
acchang Account Assignment Can Be Changed in Follow-On Document Show values
pmactive Indicator: Amount Change Only with Value Adjustment Document Show values
abgwaers Reduction in Local Currency Only Show values
Column Name Description Domain name
EarmarkedFundsDocumentItem Document Item for Earmarked Funds KBLPOS
EarmarkedFundsItem Document Item for Earmarked Funds KBLPOS
nprbudget Update in Non-Profile Budget CHAR1
ccnum Payment cards: Card number CCNUM_30F
ccname Payment cards: Name of cardholder CHAR40
blart Earmarked Fund Document Type FMRE_BLART
xblnr Reference Document Number XBLNR1
fmre_xblnr2 Reference 2 FMRE_XBLNR2
fmre_xblnr3 Reference 3 FMRE_XBLNR3
ktext Document Header Text TEXT50
kerfas Entered By USNAM
kaende Last Changed By USNAM
erfas Entered By USNAM
aende Last Changed By USNAM
ef_group_number Grouping Number for Earmarked Funds NUMC10
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
posid Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
nplnr Network Number for Account Assignment AUFNR
CommitmentItemFiscalYear null
CommitmentItem Commitment Item FM_FIPEX
fipex Commitment Item FM_FIPEX
FundedProgram Funded Program FM_MEASURE
measure Funded Program FM_MEASURE
BudgetPeriod Budget Period FM_BUDGET_PERIOD
budget_pd Budget Period FM_BUDGET_PERIOD
GrantID Grant GM_GRANT_NBR
grant_nbr Grant GM_GRANT_NBR
gsber Business Area GSBER
lnrza Account Number of the Alternative Payee LIFNR
ptext Item Text TEXT50
rfpos Reference line item AWPOS
refbelnr Reference Document Number: Reservation/Funds Precommitment KBLNR
refblpos Item in Reference Document KBLPOS
uebto Tolerance Limit for Overrun PRZ31
cwtfree Available Amount in Transaction Currency (Character) CHAR16
Master Data Relations Join Conditions
Order number
  • Order Number
  • Order Number
  • Client
  • SHSM_EFDITM.AUFNR == AUFK.AUFNR
  • SHSM_EFDITM.INTERNALORDER == AUFK.AUFNR
  • SHSM_EFDITM.MANDT == AUFK.MANDT
Company code
  • Company Code
  • Company Code
  • Client
  • SHSM_EFDITM.BUKRS == T001.BUKRS
  • SHSM_EFDITM.COMPANYCODE == T001.BUKRS
  • SHSM_EFDITM.MANDT == T001.MANDT
Payment cards: Card type
  • Payment cards: Card type
  • Client
  • SHSM_EFDITM.CCINS == TCRIN.CCINS
  • SHSM_EFDITM.MANDT == TCRIN.MANDT
Company code
  • Company Code
  • Company Code
  • Client
  • SHSM_EFDITM.BUKRS == T001.BUKRS
  • SHSM_EFDITM.COMPANYCODE == T001.BUKRS
  • SHSM_EFDITM.MANDT == T001.MANDT
Controlling area
  • Controlling Area
  • Controlling Area
  • Client
  • SHSM_EFDITM.KOKRS == TKA01.KOKRS
  • SHSM_EFDITM.CONTROLLINGAREA == TKA01.KOKRS
  • SHSM_EFDITM.MANDT == TKA01.MANDT
Cost Center
  • Costs Due On
  • Controlling Area
  • Controlling Area
  • Client
  • Cost Center
  • Cost Center
  • SHSM_EFDITM.FDATK == CSKS.DATBI
  • SHSM_EFDITM.KOKRS == CSKS.KOKRS
  • SHSM_EFDITM.CONTROLLINGAREA == CSKS.KOKRS
  • SHSM_EFDITM.MANDT == CSKS.MANDT
  • SHSM_EFDITM.COSTCENTER == CSKS.KOSTL
  • SHSM_EFDITM.KOSTL == CSKS.KOSTL
Financial Management Area
  • Financial Management Area
  • Financial Management Area
  • Client
  • SHSM_EFDITM.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • SHSM_EFDITM.FIKRS == FM01.FIKRS
  • SHSM_EFDITM.MANDT == FM01.MANDT
Financial Management Area
  • Financial Management Area
  • Financial Management Area
  • Client
  • SHSM_EFDITM.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • SHSM_EFDITM.FIKRS == FM01.FIKRS
  • SHSM_EFDITM.MANDT == FM01.MANDT
Funds Center
  • Funds Center
  • Funds Center
  • ?
  • Financial Management Area
  • Financial Management Area
  • Client
  • SHSM_EFDITM.FISTL == FMFCTR.FICTR
  • SHSM_EFDITM.FUNDSCENTER == FMFCTR.FICTR
  • SHSM_EFDITM.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • SHSM_EFDITM.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • SHSM_EFDITM.FIKRS == FMFCTR.FIKRS
  • SHSM_EFDITM.MANDT == FMFCTR.MANDT
Functional Area
  • Client
  • Functional Area
  • Functional Area
  • SHSM_EFDITM.MANDT == TFKB.MANDT
  • SHSM_EFDITM.FKBER == TFKB.FKBER
  • SHSM_EFDITM.FUNCTIONALAREA == TFKB.FKBER
Functional Area
  • Client
  • Functional Area
  • Functional Area
  • SHSM_EFDITM.MANDT == TFKB.MANDT
  • SHSM_EFDITM.FKBER == TFKB.FKBER
  • SHSM_EFDITM.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Financial Management Area
  • Client
  • Fund
  • Fund
Funds Center
  • Funds Center
  • Funds Center
  • ?
  • Financial Management Area
  • Financial Management Area
  • Client
  • SHSM_EFDITM.FISTL == FMFCTR.FICTR
  • SHSM_EFDITM.FUNDSCENTER == FMFCTR.FICTR
  • SHSM_EFDITM.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • SHSM_EFDITM.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • SHSM_EFDITM.FIKRS == FMFCTR.FIKRS
  • SHSM_EFDITM.MANDT == FMFCTR.MANDT
Fund
  • Financial Management Area
  • Financial Management Area
  • Client
  • Fund
  • Fund
G/L Account Number
  • G/L Account Number
  • G/L Account Number
  • Client
  • ?
  • SHSM_EFDITM.SAKNR == SKA1.SAKNR
  • SHSM_EFDITM.GLACCOUNT == SKA1.SAKNR
  • SHSM_EFDITM.MANDT == SKA1.MANDT
  • SHSM_EFDITM.[column in domain "KTOPL"] == SKA1.KTOPL
Order number
  • Order Number
  • Order Number
  • Client
  • SHSM_EFDITM.AUFNR == AUFK.AUFNR
  • SHSM_EFDITM.INTERNALORDER == AUFK.AUFNR
  • SHSM_EFDITM.MANDT == AUFK.MANDT
Controlling area
  • Controlling Area
  • Controlling Area
  • Client
  • SHSM_EFDITM.KOKRS == TKA01.KOKRS
  • SHSM_EFDITM.CONTROLLINGAREA == TKA01.KOKRS
  • SHSM_EFDITM.MANDT == TKA01.MANDT
Cost Center
  • Costs Due On
  • Controlling Area
  • Controlling Area
  • Client
  • Cost Center
  • Cost Center
  • SHSM_EFDITM.FDATK == CSKS.DATBI
  • SHSM_EFDITM.KOKRS == CSKS.KOKRS
  • SHSM_EFDITM.CONTROLLINGAREA == CSKS.KOKRS
  • SHSM_EFDITM.MANDT == CSKS.MANDT
  • SHSM_EFDITM.COSTCENTER == CSKS.KOSTL
  • SHSM_EFDITM.KOSTL == CSKS.KOSTL
Cost element
  • Client
  • ?
  • Cost Element
  • SHSM_EFDITM.MANDT == CSKA.MANDT
  • SHSM_EFDITM.[column in domain "KTOPL"] == CSKA.KTOPL
  • SHSM_EFDITM.KSTAR == CSKA.KSTAR
Customer Number
  • Customer Number
  • Client
  • SHSM_EFDITM.KUNNR == KNA1.KUNNR
  • SHSM_EFDITM.MANDT == KNA1.MANDT
Vendor number
  • Client
  • Account Number of Supplier
  • SHSM_EFDITM.MANDT == LFA1.MANDT
  • SHSM_EFDITM.LIFNR == LFA1.LIFNR
Material number
  • Client
  • Material Number
  • SHSM_EFDITM.MANDT == MARA.MANDT
  • SHSM_EFDITM.MATNR == MARA.MATNR
Earmarked Funds Item Block
  • Client
  • Earmarked Funds Item Block
G/L Account Number
  • G/L Account Number
  • G/L Account Number
  • Client
  • ?
  • SHSM_EFDITM.SAKNR == SKA1.SAKNR
  • SHSM_EFDITM.GLACCOUNT == SKA1.SAKNR
  • SHSM_EFDITM.MANDT == SKA1.MANDT
  • SHSM_EFDITM.[column in domain "KTOPL"] == SKA1.KTOPL
Transaction currency = document currency
  • Client
  • Transaction Currency
  • SHSM_EFDITM.MANDT == TCURC.MANDT
  • SHSM_EFDITM.WAERS == TCURC.WAERS