ESH_S_EXPNSETTLMT

Search view -EXPNSETTLMT | view: ESH_U_EXPNSETLMT | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: WBRKWBRKT001TKA02KNA1KNB1KNB5TVTWTVTWTTSPATSPATTVKOTVKOTTMFKTTMZRTTMFKTMZR
Column Name Description
EXPNSETTLMT Document Number of Expense Settlement
Column Name Description
💲 Currency of Settlement Document (EXPNSETTLMTCURRENCY):
CUSTOMERTOTALGROSSAMOUNT Gross Settlement Amount in Document Currency (Customer-Side)
CUSTOMERTOTALNETAMOUNT Net Settlement Amount in Document Currency (Customer-Side)
Column Name Description
Column Name Description
DOCUMENTDATE Document Date in Settlement Management Document
POSTINGDATE Posting Date
Column Name Description
SETTLMTMGMTACCTGTRANSFSTS Posting Status for Transfer to Financial Accounting Show values
Column Name Description Domain name
BILLTOPARTYAUTH Authorization Group BRGRU
BILLTOPARTYCOMPANYAUTH Authorization Group BRGRU
PAYERPARTYAUTH Authorization Group BRGRU
PAYERPARTYCOMPANYAUTH Authorization Group BRGRU
COMPANYCODENAME Name of Company Code or Company TEXT25
BILLTOPARTY Customer Number
PAYERPARTY Customer Number
DISTRIBUTIONCHANNELNAME Distribution Channel Description
DIVISIONNAME Division Description TEXT20
BILLTOPARTYNAME Name 1
PAYERPARTYNAME Name 1
SALESORGANIZATIONNAME Sales Organization Description
SETTLMTCAT Settlement Category
SETTLMTCATNAME Short Text for Fixed Values
SETTLMTDOCCAT Settlement Document Category
SETTLMTDOCCATNAME Short Text for Fixed Values
SETTLMTDOCTYPEDESC Settlement Document Type Description
SETTLMTMGMTACCTGTRANSFSTSNAME Short Text for Fixed Values
SETTLMTPROCESSTYPEDESC Settlement Process Type Description
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • ESH_S_EXPNSETTLMT.MANDT == T001.MANDT
  • ESH_S_EXPNSETTLMT.CUSTSETTLMTCOMPANYCODE == T001.BUKRS
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_S_EXPNSETTLMT.MANDT == TVTW.MANDT
  • ESH_S_EXPNSETTLMT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • ESH_S_EXPNSETTLMT.MANDT == TSPA.MANDT
  • ESH_S_EXPNSETTLMT.DIVISION == TSPA.SPART
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • ESH_S_EXPNSETTLMT.MANDT == TCURC.MANDT
  • ESH_S_EXPNSETTLMT.EXPNSETTLMTCURRENCY == TCURC.WAERS
Sales Organization
  • Client
  • Sales Organization
  • ESH_S_EXPNSETTLMT.MANDT == TVKO.MANDT
  • ESH_S_EXPNSETTLMT.SALESORGANIZATION == TVKO.VKORG
Settlement Document Type
  • Client
  • Settlement Document Type
  • ESH_S_EXPNSETTLMT.MANDT == TMFK.MANDT
  • ESH_S_EXPNSETTLMT.SETTLMTDOCTYPE == TMFK.LFART
Settlement Process Type
  • Client
  • Settlement Process Type
  • ESH_S_EXPNSETTLMT.MANDT == TMZR.MANDT
  • ESH_S_EXPNSETTLMT.SETTLMTPROCESSTYPE == TMZR.WRART