ESH_S_ACCOUNTING_DOC

Search view for search model ACCOUNTING_DOC_H | view: ESH_U_ACCOUNTING | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BKPFBSEGT001T880KNB1LFB1USR21ADRPKNA1LFA1T003T
Column Name Description
Column Name Description
💲 Currency Key (waers):
wrbtr Amount in document currency
Column Name Description
Column Name Description
bldat Document Date in Document
budat Posting Date in the Document
cpudt Day On Which Accounting Document Was Entered
upddt Date of the Last Document Update
Column Name Description
bstat Document Status Show values
Column Name Description Domain name
belnr Document Number of an Accounting Document
gjahr Fiscal Year GJAHR
monat Fiscal period
usnam User Name
xblnr Reference Document Number
bktxt Document Header Text
awtyp Reference procedure AWTYP
awkey Reference Key AWKEY
butxt Name of Company Code or Company
ltext Document Type Description
name_text Full Name of Person
name1 Company name
sgtxt Item Text TEXT50
CustomerName Name 1
SupplierName Name 1
xref1 Business Partner Reference Key
xref2 Business Partner Reference Key
xref3 Reference key for line item
zuonr Assignment number ZUONR
kostl Cost Center KOSTL
prctr Profit Center PRCTR
vbel2 Sales Document VBELN
Master Data Relations Join Conditions
Order Number
  • Client
  • Order Number
  • ESH_S_ACCOUNTING_DOC.MANDT == AUFK.MANDT
  • ESH_S_ACCOUNTING_DOC.AUFNR == AUFK.AUFNR
Document Type
  • Client
  • Document Type
  • ESH_S_ACCOUNTING_DOC.MANDT == T003.MANDT
  • ESH_S_ACCOUNTING_DOC.BLART == T003.BLART
Company Code
  • Client
  • Company Code
  • ESH_S_ACCOUNTING_DOC.MANDT == T001.MANDT
  • ESH_S_ACCOUNTING_DOC.BUKRS == T001.BUKRS
General Ledger Account
  • Client
  • Company Code
  • General Ledger Account
  • ESH_S_ACCOUNTING_DOC.MANDT == SKB1.MANDT
  • ESH_S_ACCOUNTING_DOC.BUKRS == SKB1.BUKRS
  • ESH_S_ACCOUNTING_DOC.HKONT == SKB1.SAKNR
Controlling Area
  • Client
  • Controlling Area
  • ESH_S_ACCOUNTING_DOC.MANDT == TKA01.MANDT
  • ESH_S_ACCOUNTING_DOC.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • ESH_S_ACCOUNTING_DOC.MANDT == T004.MANDT
  • ESH_S_ACCOUNTING_DOC.KTOPL == T004.KTOPL
Customer Number
  • Client
  • Customer Number
  • ESH_S_ACCOUNTING_DOC.MANDT == KNA1.MANDT
  • ESH_S_ACCOUNTING_DOC.KUNNR == KNA1.KUNNR
Ledger Group
  • Ledger Group
  • Client
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • ESH_S_ACCOUNTING_DOC.MANDT == LFA1.MANDT
  • ESH_S_ACCOUNTING_DOC.LIFNR == LFA1.LIFNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • ESH_S_ACCOUNTING_DOC.MANDT == T880.MANDT
  • ESH_S_ACCOUNTING_DOC.VBUND == T880.RCOMP
Currency Key
  • Client
  • Currency Key
  • ESH_S_ACCOUNTING_DOC.MANDT == TCURC.MANDT
  • ESH_S_ACCOUNTING_DOC.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger in General Ledger Accounting
  • Client
  • Company Code
  • Ledger in General Ledger Accounting