ESH_N_CUSTSETTLMTLIST

Anchor view -CUSTSETTLMTLIST | view: ESH_L_CSTSTMTLST | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: WBRKWBRKT001TKA02KNA1KNB1KNB5TVTWTVTWTTSPATSPATTVKOTVKOTTMFKTTMZRTTMFKTMZR
Column Name Description
CUSTSETTLMTLIST Settlement Document: Customer Settlement List
Column Name Description
💲 Currency of Settlement Document (CUSTSETTLMTLISTCURRENCY):
CUSTOMERTOTALGROSSAMOUNT Gross Settlement Amount in Document Currency (Customer-Side)
CUSTOMERTOTALNETAMOUNT Net Settlement Amount in Document Currency (Customer-Side)
Column Name Description
Column Name Description
POSTINGDATE Posting Date
Column Name Description
SETTLMTDOCCAT Settlement Document Category Show values
SETTLMTMGMTACCTGTRANSFSTS Posting Status for Transfer to Financial Accounting Show values
Column Name Description Domain name
BILLTOPARTYAUTHGRP Authorization Group BRGRU
PAYERPARTYAUTHGRP Authorization Group BRGRU
BILLTOPARTYCOMPANYAUTHGRP Authorization Group BRGRU
PAYERPARTYCOMPANYAUTHGRP Authorization Group BRGRU
COMPANYCODENAME Name of Company Code or Company TEXT25
DISTRIBUTIONCHANNELNAME Distribution Channel Description TEXT20
DIVISIONNAME Division Description TEXT20
BILLTOPARTYNAME Name 1 NAME
PAYERPARTYNAME Name 1 NAME
SALESORGANIZATIONNAME Sales Organization Description TEXT20
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
Bill-to Party
  • Bill-to Party
  • Client
  • ESH_N_CUSTSETTLMTLIST.BILLTOPARTY == KNA1.KUNNR
  • ESH_N_CUSTSETTLMTLIST.MANDT == KNA1.MANDT
Company Code
  • Company Code
  • Client
  • ESH_N_CUSTSETTLMTLIST.CUSTSETTLMTCOMPANYCODE == T001.BUKRS
  • ESH_N_CUSTSETTLMTLIST.MANDT == T001.MANDT
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • ESH_N_CUSTSETTLMTLIST.MANDT == TCURC.MANDT
  • ESH_N_CUSTSETTLMTLIST.CUSTSETTLMTLISTCURRENCY == TCURC.WAERS
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_N_CUSTSETTLMTLIST.MANDT == TVTW.MANDT
  • ESH_N_CUSTSETTLMTLIST.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • ESH_N_CUSTSETTLMTLIST.DIVISION == TSPA.SPART
  • ESH_N_CUSTSETTLMTLIST.MANDT == TSPA.MANDT
Payer
  • Payer
  • Client
  • ESH_N_CUSTSETTLMTLIST.PAYERPARTY == KNA1.KUNNR
  • ESH_N_CUSTSETTLMTLIST.MANDT == KNA1.MANDT
Sales Organization
  • Sales Organization
  • Client
  • ESH_N_CUSTSETTLMTLIST.SALESORGANIZATION == TVKO.VKORG
  • ESH_N_CUSTSETTLMTLIST.MANDT == TVKO.MANDT
Settlement Document Type
  • Settlement Document Type
  • Client
  • ESH_N_CUSTSETTLMTLIST.SETTLMTDOCTYPE == TMFK.LFART
  • ESH_N_CUSTSETTLMTLIST.MANDT == TMFK.MANDT
Settlement Process Type
  • Settlement Process Type
  • Client
  • ESH_N_CUSTSETTLMTLIST.SETTLMTPROCESSTYPE == TMZR.WRART
  • ESH_N_CUSTSETTLMTLIST.MANDT == TMZR.MANDT