ESH_N_SETTLMTDOC

Search Object for Settlement Documents | view: ESH_L_SETTLMTDOC | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, BUT000, T001, TKA02, KNA1, CVI_CUST_LINK, TMFKT, TMZRT, LFA1, CVI_VEND_LINK, TMFK, TMZR
Column Name Description
SETTLMTDOC Settlement Document Number
Column Name Description
💲 Currency of Settlement Document (SETTLMTDOCCURRENCY):
CUSTOMERTOTALGROSSAMOUNT Total Gross Amount for Customer in Document Currency
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
BILLTOPARTYNAME Name 2 of organization BU_NAME
INVOICINGPARTYNAME Name 2 of organization BU_NAME
PAYEEPARTYNAME Name 2 of organization BU_NAME
PAYERPARTYNAME Name 2 of organization BU_NAME
SETTLMTDOCTYPEDESC Settlement Document Type Description TEXT40
SETTLMTMGMTACCTGTRANSFSTSNAME Description of Posting Status DDTEXT
SETTLMTPROCESSTYPEDESC Settlement Process Type Description TEXT40
SUPLRSETTLMTCOMPANYCODENAME Name of Company Code or Company TEXT25
Master Data Relations Join Conditions
Bill-to Party
  • Bill-to Party
  • Client
  • ESH_N_SETTLMTDOC.BILLTOPARTY == KNA1.KUNNR
  • ESH_N_SETTLMTDOC.MANDT == KNA1.MANDT
Authorization Group
  • ?
  • Client
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • ESH_N_SETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ESH_N_SETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_N_SETTLMTDOC.BILLTOPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.INVOICINGPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.PAYEEPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.PAYERPARTYAUTHGROUP == TB037.AUGRP
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_N_SETTLMTDOC.MANDT == TVTW.MANDT
  • ESH_N_SETTLMTDOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • ESH_N_SETTLMTDOC.MANDT == TSPA.MANDT
  • ESH_N_SETTLMTDOC.DIVISION == TSPA.SPART
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • ESH_N_SETTLMTDOC.MANDT == LFA1.MANDT
  • ESH_N_SETTLMTDOC.INVOICINGPARTY == LFA1.LIFNR
Authorization Group
  • ?
  • Client
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • ESH_N_SETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ESH_N_SETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_N_SETTLMTDOC.BILLTOPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.INVOICINGPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.PAYEEPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.PAYERPARTYAUTHGROUP == TB037.AUGRP
Payee
  • Payee
  • Client
  • ESH_N_SETTLMTDOC.PAYEEPARTY == LFA1.LIFNR
  • ESH_N_SETTLMTDOC.MANDT == LFA1.MANDT
Authorization Group
  • ?
  • Client
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • ESH_N_SETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ESH_N_SETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_N_SETTLMTDOC.BILLTOPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.INVOICINGPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.PAYEEPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.PAYERPARTYAUTHGROUP == TB037.AUGRP
Payer
  • Payer
  • Client
  • ESH_N_SETTLMTDOC.PAYERPARTY == KNA1.KUNNR
  • ESH_N_SETTLMTDOC.MANDT == KNA1.MANDT
Authorization Group
  • ?
  • Client
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • ESH_N_SETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ESH_N_SETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_N_SETTLMTDOC.BILLTOPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.INVOICINGPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.PAYEEPARTYAUTHGROUP == TB037.AUGRP
  • ESH_N_SETTLMTDOC.PAYERPARTYAUTHGROUP == TB037.AUGRP
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_N_SETTLMTDOC.MANDT == T024.MANDT
  • ESH_N_SETTLMTDOC.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • ESH_N_SETTLMTDOC.MANDT == T024E.MANDT
  • ESH_N_SETTLMTDOC.PURCHASINGORGANIZATION == T024E.EKORG
Sales Organization
  • Client
  • Sales Organization
  • ESH_N_SETTLMTDOC.MANDT == TVKO.MANDT
  • ESH_N_SETTLMTDOC.SALESORGANIZATION == TVKO.VKORG
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • ESH_N_SETTLMTDOC.MANDT == TCURC.MANDT
  • ESH_N_SETTLMTDOC.SETTLMTDOCCURRENCY == TCURC.WAERS
Settlement Document Type
  • Client
  • Settlement Document Type
  • ESH_N_SETTLMTDOC.MANDT == TMFK.MANDT
  • ESH_N_SETTLMTDOC.SETTLMTDOCTYPE == TMFK.LFART
Settlement Process Type
  • Client
  • Settlement Process Type
  • ESH_N_SETTLMTDOC.MANDT == TMZR.MANDT
  • ESH_N_SETTLMTDOC.SETTLMTPROCESSTYPE == TMZR.WRART
Supplier Company Code
  • Client
  • Supplier Company Code
  • ESH_N_SETTLMTDOC.MANDT == T001.MANDT
  • ESH_N_SETTLMTDOC.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS