ESH_B2_SETTLMTDOC

Enterprise Search for Settlmt Documents "Basicview 2" | view: ESH_B2_SD | 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
PostingDate Posting Date
DocumentDate Document Date in Settlement Management Document
Column Name Description
SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
Column Name Description Domain name
SettlmtProcessTypeDesc Settlement Process Type Description TEXT40
SettlmtDocTypeDesc Settlement Document Type Description TEXT40
PayeePartyBpUUID Business Partner GUID SYSUUID
PayeePartyName Name 2 of organization BU_NAME
InvoicingPartyBpUUID Business Partner GUID SYSUUID
InvoicingPartyName Name 2 of organization BU_NAME
BillToPartyBpUUID Business Partner GUID SYSUUID
BillToPartyName Name 2 of organization BU_NAME
PayerPartyBpUUID Business Partner GUID SYSUUID
PayerPartyName Name 2 of organization BU_NAME
SettlmtMgmtAcctgTransfStsName Description of Posting Status DDTEXT
SuplrSettlmtCompanyCodeName Name of Company Code or Company TEXT25
Master Data Relations Join Conditions
Bill-to Party
  • Client
  • Bill-to Party
  • ESH_B2_SETTLMTDOC.MANDT == KNA1.MANDT
  • ESH_B2_SETTLMTDOC.BILLTOPARTY == KNA1.KUNNR
Authorization Group
  • Client
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • ?
  • ESH_B2_SETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_B2_SETTLMTDOC.INVOICINGPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.BILLTOPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.PAYEEPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.PAYERPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_B2_SETTLMTDOC.MANDT == TVTW.MANDT
  • ESH_B2_SETTLMTDOC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • ESH_B2_SETTLMTDOC.MANDT == TSPA.MANDT
  • ESH_B2_SETTLMTDOC.DIVISION == TSPA.SPART
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • ESH_B2_SETTLMTDOC.MANDT == LFA1.MANDT
  • ESH_B2_SETTLMTDOC.INVOICINGPARTY == LFA1.LIFNR
Authorization Group
  • Client
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • ?
  • ESH_B2_SETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_B2_SETTLMTDOC.INVOICINGPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.BILLTOPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.PAYEEPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.PAYERPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Payee
  • Client
  • Payee
  • ESH_B2_SETTLMTDOC.MANDT == LFA1.MANDT
  • ESH_B2_SETTLMTDOC.PAYEEPARTY == LFA1.LIFNR
Authorization Group
  • Client
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • ?
  • ESH_B2_SETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_B2_SETTLMTDOC.INVOICINGPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.BILLTOPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.PAYEEPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.PAYERPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Payer
  • Client
  • Payer
  • ESH_B2_SETTLMTDOC.MANDT == KNA1.MANDT
  • ESH_B2_SETTLMTDOC.PAYERPARTY == KNA1.KUNNR
Authorization Group
  • Client
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • Authorization Group
  • ?
  • ESH_B2_SETTLMTDOC.MANDT == TB037.CLIENT
  • ESH_B2_SETTLMTDOC.INVOICINGPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.BILLTOPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.PAYEEPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.PAYERPARTYAUTHGROUP == TB037.AUGRP
  • ESH_B2_SETTLMTDOC.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_B2_SETTLMTDOC.PURCHASINGGROUP == T024.EKGRP
  • ESH_B2_SETTLMTDOC.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • ESH_B2_SETTLMTDOC.MANDT == T024E.MANDT
  • ESH_B2_SETTLMTDOC.PURCHASINGORGANIZATION == T024E.EKORG
Sales Organization
  • Client
  • Sales Organization
  • ESH_B2_SETTLMTDOC.MANDT == TVKO.MANDT
  • ESH_B2_SETTLMTDOC.SALESORGANIZATION == TVKO.VKORG
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • ESH_B2_SETTLMTDOC.MANDT == TCURC.MANDT
  • ESH_B2_SETTLMTDOC.SETTLMTDOCCURRENCY == TCURC.WAERS
Settlement Document Type
  • Settlement Document Type
  • Client
  • ESH_B2_SETTLMTDOC.SETTLMTDOCTYPE == TMFK.LFART
  • ESH_B2_SETTLMTDOC.MANDT == TMFK.MANDT
Settlement Process Type
  • Client
  • Settlement Process Type
  • ESH_B2_SETTLMTDOC.MANDT == TMZR.MANDT
  • ESH_B2_SETTLMTDOC.SETTLMTPROCESSTYPE == TMZR.WRART
Supplier Company Code
  • Client
  • Supplier Company Code
  • ESH_B2_SETTLMTDOC.MANDT == T001.MANDT
  • ESH_B2_SETTLMTDOC.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS