ESH_N_EXPNSETTLMT

Anchor view -EXPNSETTLMT | view: ESH_L_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
SETTLMTCAT Settlement Category Show values
SETTLMTDOCCAT Settlement Document Category Show values
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 KUNNR
PAYERPARTY Customer Number KUNNR
DISTRIBUTIONCHANNELNAME Distribution Channel Description TEXT20
DIVISIONNAME Division Description TEXT20
BILLTOPARTYNAME Name 1 NAME
PAYERPARTYNAME Name 1 NAME
SALESORGANIZATIONNAME Sales Organization Description TEXT20
SETTLMTCATNAME Short Text for Fixed Values DDTEXT
SETTLMTDOCCATNAME Short Text for Fixed Values DDTEXT
SETTLMTDOCTYPEDESC Settlement Document Type Description TEXT40
SETTLMTMGMTACCTGTRANSFSTSNAME Short Text for Fixed Values DDTEXT
SETTLMTPROCESSTYPEDESC Settlement Process Type Description TEXT40
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • ESH_N_EXPNSETTLMT.CUSTSETTLMTCOMPANYCODE == T001.BUKRS
  • ESH_N_EXPNSETTLMT.MANDT == T001.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_N_EXPNSETTLMT.MANDT == TVTW.MANDT
  • ESH_N_EXPNSETTLMT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • ESH_N_EXPNSETTLMT.MANDT == TSPA.MANDT
  • ESH_N_EXPNSETTLMT.DIVISION == TSPA.SPART
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • ESH_N_EXPNSETTLMT.MANDT == TCURC.MANDT
  • ESH_N_EXPNSETTLMT.EXPNSETTLMTCURRENCY == TCURC.WAERS
Sales Organization
  • Sales Organization
  • Client
  • ESH_N_EXPNSETTLMT.SALESORGANIZATION == TVKO.VKORG
  • ESH_N_EXPNSETTLMT.MANDT == TVKO.MANDT
Settlement Document Type
  • Settlement Document Type
  • Client
  • ESH_N_EXPNSETTLMT.SETTLMTDOCTYPE == TMFK.LFART
  • ESH_N_EXPNSETTLMT.MANDT == TMFK.MANDT
Settlement Process Type
  • Client
  • Settlement Process Type
  • ESH_N_EXPNSETTLMT.MANDT == TMZR.MANDT
  • ESH_N_EXPNSETTLMT.SETTLMTPROCESSTYPE == TMZR.WRART