ESH_N_SUPLRSETTLMTLIST

Anchor view -SUPLRSETTLMTLIST | view: ESH_L_SPLRSMTLST | TRAN | Extraction: Not supported | Component: Settlement Management

Tables used: WBRK, WBRK, T001, TKA02, TVTW, TVTWT, TSPA, TSPAT, T024, T024E, TVKO, TVKOT, TMFKT, TMZRT, LFA1, LFB1, TMFK, TMZR

🔑 Keys (1)
💰 Amounts (2)
∑ Quantities
📅 Dates (2)
☰ Categorical (2)
Other (18)
🔗 Relations (11)

Column Name	Description
SUPLRSETTLMTLIST	Supplier Settlement List

Column Name	Description
💲 Currency of Settlement Document (SUPLRSETTLMTLISTCURRENCY):
SUPPLIERTOTALGROSSAMOUNT	Gross Settlement Amount in Document Currency
SUPPLIERTOTALNETAMOUNT	Net Settlement Amount in Document Currency

Column Name	Description

Column Name	Description
DOCUMENTDATE	Document Date in Settlement Management Document
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
ALTINVPARTYCOMPANYAUTHGRP	Authorization Group	BRGRU
PAYEEPARTYCOMPANYAUTHGRP	Authorization Group	BRGRU
INVOICINGPARTYCOMPANYAUTHGRP	Authorization Group	BRGRU
ALTINVOICINGPARTYAUTHGRP	Authorization Group	BRGRU
PAYEEPARTYAUTHGRP	Authorization Group	BRGRU
INVOICINGPARTYAUTHGRP	Authorization Group	BRGRU
DISTRIBUTIONCHANNELNAME	Distribution Channel Description	TEXT20
DIVISIONNAME	Division Description	TEXT20
ALTINVOICINGPARTYNAME	Name 1	NAME
PAYEEPARTYNAME	Name 1	NAME
INVOICINGPARTYNAME	Name 1	NAME
PURCHASINGGROUPNAME	Purchasing Group Name	TEXT18
PURCHASINGORGANIZATIONNAME	Purchasing Organization Name	TEXT20
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
Distribution Channel Client Distribution Channel	`ESH_N_SUPLRSETTLMTLIST.MANDT == TVTW.MANDT` `ESH_N_SUPLRSETTLMTLIST.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division Division Client	`ESH_N_SUPLRSETTLMTLIST.DIVISION == TSPA.SPART` `ESH_N_SUPLRSETTLMTLIST.MANDT == TSPA.MANDT`
Different Invoicing Party Different Invoicing Party Client	`ESH_N_SUPLRSETTLMTLIST.INVOICINGPARTY == LFA1.LIFNR` `ESH_N_SUPLRSETTLMTLIST.MANDT == LFA1.MANDT`
Payee Payee Client	`ESH_N_SUPLRSETTLMTLIST.PAYEEPARTY == LFA1.LIFNR` `ESH_N_SUPLRSETTLMTLIST.MANDT == LFA1.MANDT`
Purchasing Group Client Purchasing Group	`ESH_N_SUPLRSETTLMTLIST.MANDT == T024.MANDT` `ESH_N_SUPLRSETTLMTLIST.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Purchasing organization Client	`ESH_N_SUPLRSETTLMTLIST.PURCHASINGORGANIZATION == T024E.EKORG` `ESH_N_SUPLRSETTLMTLIST.MANDT == T024E.MANDT`
Sales Organization Client Sales Organization	`ESH_N_SUPLRSETTLMTLIST.MANDT == TVKO.MANDT` `ESH_N_SUPLRSETTLMTLIST.SALESORGANIZATION == TVKO.VKORG`
Settlement Document Type Settlement Document Type Client	`ESH_N_SUPLRSETTLMTLIST.SETTLMTDOCTYPE == TMFK.LFART` `ESH_N_SUPLRSETTLMTLIST.MANDT == TMFK.MANDT`
Settlement Process Type Client Settlement Process Type	`ESH_N_SUPLRSETTLMTLIST.MANDT == TMZR.MANDT` `ESH_N_SUPLRSETTLMTLIST.SETTLMTPROCESSTYPE == TMZR.WRART`
Company Code Client Company Code	`ESH_N_SUPLRSETTLMTLIST.MANDT == T001.MANDT` `ESH_N_SUPLRSETTLMTLIST.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS`
Currency of Settlement Document Currency of Settlement Document Client	`ESH_N_SUPLRSETTLMTLIST.SUPLRSETTLMTLISTCURRENCY == TCURC.WAERS` `ESH_N_SUPLRSETTLMTLIST.MANDT == TCURC.MANDT`