R_CustSettlmtListDEX

Customer Settlmt List Basic Extraction | view: RWLFCUSTSTLSTDEX | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRL, TMFK
Column Name Description
CustSettlmtList FK Settlement Document: Customer Settlement List
CustSettlmtListItem Item in List
Column Name Description
💲 Currency of Settlement Document (CustSettlmtListCurrency):
CustSettlmtListTotGrossAmount Gross Settlement Amount in Document Currency
CustSettlmtListTotalNetAmount Net Settlement Amount in Document Currency
CustSettlmtListTotalTaxAmount Total Tax Amount in Document Currency
CustTotEligibleAmtForCshDisc Total Amount eligible for cash discount in document currency
CustSettlmtListItemNetAmount New Value of the Item in a List
CustSettlmtListItemTaxAmount Tax Amount in Document Currency
NonDeductibleInputTaxAmount Non-deductible input tax
SettlmtRemunerationNetAmt Value of the Settlement Document List Conditions
SettlmtRemunerationTaxAmt Tax of Settlement Document List Conditions
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Document Date in Settlement Management Document
CreationDate Date of Document Creation
CreationTime Time of Document Creation
LastChangeDate Date of Last Document Change
ExchangeRateDate Exchange Rate Date
FixedValueDate Fixed Value Date
SettlmtDate Rebates: Settlement Date
Column Name Description
SettlmtDocCat Settlement Document Category Show values
LogisticsDataEntryCat Entry Category for Logistics Data Show values
CustSettlmtListAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
CustSettlmtListIsReversed Customer Settlement List Is Reversed Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
IntrastatDeclnGdsFlwCat Type of Goods Flow for Intrastat Declarations Show values
DocIntrastatRelevance Document is Relevant for Intrastat Declarations Show values
SettlmtBusProcCat Use Case Type Show values
CustSettlmtListItemIsReversed List Item is Reversed Show values
PrcDetnIsIncmplt Indicator that Pricing Determination for Item is Incomplete Show values
Column Name Description Domain name
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
CreatedByUser Name of User who Created the Document USNAM
ExchangeRate Conversion Rate (Not Converted)
PaymentTerms Terms of Payment Key for Customer ZTERM
CashDiscount1Days Customer Cash Discount First Payment in Days ZBDXT
CashDiscount2Days Customer Cash Discount Second Payment in Days ZBDXT
NetPaymentDays Customer Cash Discount Days ZBDXT
CashDiscount1Percent Customer Cash Discount for First Payment in % PRZ23
CashDiscount2Percent Custromer Cash Discount for Second Payment in % PRZ23
AdditionalValueDays Additional Value Days TAGE2
VATRegistration VAT Registration Number STCEG
PaymentReference Payment Reference CHAR30
CustSetlLstPaytCrcyExchRate Exchange Rate of Payment Currency (not converted)
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SEPAMandate Unique Reference to Mandate for each Payee ID035
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Bill-to Party
  • Bill-to Party
  • Client
  • R_CUSTSETTLMTLISTDEX.BILLTOPARTY == KNA1.KUNNR
  • R_CUSTSETTLMTLISTDEX.MANDT == KNA1.MANDT
Company Code
  • Company Code
  • Client
  • R_CUSTSETTLMTLISTDEX.COMPANYCODE == T001.BUKRS
  • R_CUSTSETTLMTLISTDEX.MANDT == T001.MANDT
Credit Control Area
  • Credit Control Area
  • Client
  • R_CUSTSETTLMTLISTDEX.CREDITCONTROLAREA == T014.KKBER
  • R_CUSTSETTLMTLISTDEX.MANDT == T014.MANDT
Header Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • Client
  • R_CUSTSETTLMTLISTDEX.CUSTSETTLMTLISTACTIVITYREASON == TMLFG.LFGRU
  • R_CUSTSETTLMTLISTDEX.MANDT == TMLFG.MANDT
Currency of Settlement Document
  • Currency of Settlement Document
  • Client
  • R_CUSTSETTLMTLISTDEX.CUSTSETTLMTLISTCURRENCY == TCURC.WAERS
  • R_CUSTSETTLMTLISTDEX.MANDT == TCURC.MANDT
Incompleteness Reason of Settlement Management Document
  • Incompleteness Reason of Settlement Management Document
  • Client
  • R_CUSTSETTLMTLISTDEX.CUSTSETTLMTLISTINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
  • R_CUSTSETTLMTLISTDEX.MANDT == TWLF_IR.MANDT
Payment Currency
  • Client
  • Payment Currency
  • R_CUSTSETTLMTLISTDEX.MANDT == TCURC.MANDT
  • R_CUSTSETTLMTLISTDEX.CUSTSETTLMTLISTPAYTCURRENCY == TCURC.WAERS
Distribution Channel
  • Distribution Channel
  • Client
  • R_CUSTSETTLMTLISTDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • R_CUSTSETTLMTLISTDEX.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • R_CUSTSETTLMTLISTDEX.DIVISION == TSPA.SPART
  • R_CUSTSETTLMTLISTDEX.MANDT == TSPA.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • R_CUSTSETTLMTLISTDEX.EXCHANGERATETYPE == TCURV.KURST
  • R_CUSTSETTLMTLISTDEX.MANDT == TCURV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • R_CUSTSETTLMTLISTDEX.INCOTERMSCLASSIFICATION == TINC.INCO1
  • R_CUSTSETTLMTLISTDEX.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • R_CUSTSETTLMTLISTDEX.INCOTERMSVERSION == TINCV.INCOV
  • R_CUSTSETTLMTLISTDEX.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • R_CUSTSETTLMTLISTDEX.INVOICINGPARTY == LFA1.LIFNR
  • R_CUSTSETTLMTLISTDEX.MANDT == LFA1.MANDT
Address of One-Time Customer
  • ?
  • Address of One-Time Customer
  • Client
  • Posting Date
  • R_CUSTSETTLMTLISTDEX.[column in domain "AD_NATION"] == ADRC.NATION
  • R_CUSTSETTLMTLISTDEX.ONETIMECUSTOMERADDRESSID == ADRC.ADDRNUMBER
  • R_CUSTSETTLMTLISTDEX.MANDT == ADRC.CLIENT
  • R_CUSTSETTLMTLISTDEX.POSTINGDATE == ADRC.DATE_FROM
Payee
  • Payee
  • Client
  • R_CUSTSETTLMTLISTDEX.PAYEEPARTY == LFA1.LIFNR
  • R_CUSTSETTLMTLISTDEX.MANDT == LFA1.MANDT
Payer
  • Payer
  • Client
  • R_CUSTSETTLMTLISTDEX.PAYERPARTY == KNA1.KUNNR
  • R_CUSTSETTLMTLISTDEX.MANDT == KNA1.MANDT
Customer Payment Method
  • ?
  • Customer Payment Method
  • Client
  • R_CUSTSETTLMTLISTDEX.[column in domain "LAND1"] == T042Z.LAND1
  • R_CUSTSETTLMTLISTDEX.PAYMENTMETHOD == T042Z.ZLSCH
  • R_CUSTSETTLMTLISTDEX.MANDT == T042Z.MANDT
Pricing Procedure
  • Pricing Procedure
  • ?
  • ?
  • Client
  • R_CUSTSETTLMTLISTDEX.PRICINGPROCEDURE == T683.KALSM
  • R_CUSTSETTLMTLISTDEX.[column in domain "KAPPL"] == T683.KAPPL
  • R_CUSTSETTLMTLISTDEX.[column in domain "KVEWE"] == T683.KVEWE
  • R_CUSTSETTLMTLISTDEX.MANDT == T683.MANDT
Sales Organization
  • Sales Organization
  • Client
  • R_CUSTSETTLMTLISTDEX.SALESORGANIZATION == TVKO.VKORG
  • R_CUSTSETTLMTLISTDEX.MANDT == TVKO.MANDT
Application Status for a Settlement Management Document
  • Application Status for a Settlement Management Document
  • Client
  • R_CUSTSETTLMTLISTDEX.SETTLMTAPPLSTS == TMPA2.ESTATUS
  • R_CUSTSETTLMTLISTDEX.MANDT == TMPA2.MANDT
Status Group for Settlement Management Documents
  • Status Group for Settlement Management Documents
  • Client
  • R_CUSTSETTLMTLISTDEX.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
  • R_CUSTSETTLMTLISTDEX.MANDT == TMPA4.MANDT
Settlement Management Process Category
  • Client
  • Settlement Management Process Category
Tax Country/Region Company Code
  • Tax Country/Region Company Code
  • Client
  • R_CUSTSETTLMTLISTDEX.SETTLMTCOCODETAXCOUNTRY == T005.LAND1
  • R_CUSTSETTLMTLISTDEX.MANDT == T005.MANDT
Settlement Document Type
  • Settlement Document Type
  • Client
  • R_CUSTSETTLMTLISTDEX.SETTLMTDOCTYPE == TMFK.LFART
  • R_CUSTSETTLMTLISTDEX.MANDT == TMFK.MANDT
Settlement Process Type
  • Settlement Process Type
  • Client
  • R_CUSTSETTLMTLISTDEX.SETTLMTPROCESSTYPE == TMZR.WRART
  • R_CUSTSETTLMTLISTDEX.MANDT == TMZR.MANDT
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • R_CUSTSETTLMTLISTDEX.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • R_CUSTSETTLMTLISTDEX.MANDT == T015L.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • R_CUSTSETTLMTLISTDEX.SUPPLYINGCOUNTRY == T005.LAND1
  • R_CUSTSETTLMTLISTDEX.MANDT == T005.MANDT
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • R_CUSTSETTLMTLISTDEX.TAXDEPARTURECOUNTRY == T005.LAND1
  • R_CUSTSETTLMTLISTDEX.MANDT == T005.MANDT
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • R_CUSTSETTLMTLISTDEX.TAXDESTINATIONCOUNTRY == T005.LAND1
  • R_CUSTSETTLMTLISTDEX.MANDT == T005.MANDT