R_SettlmtDocListDEX

Settlement Doc List Basic Extraction | view: RWLFSMTDOCLSTDEX | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRL, TMFK
Column Name Description
SettlmtDocList FK Document Number of Settlement Document List
SettlmtDocListItem Item in List
Column Name Description
💲 Currency of Settlement Document (SettlmtDocListCurrency):
SettlmtDocListTotalGrossAmount Total Gross Amount of a Settlement Document List
SettlmtDocListTotalNetAmount Net Settlement Amount in Document Currency
SettlmtDocListTotalTaxAmount Total Tax Amount in Document Currency
EligibleAmountForCashDiscount Total Amount eligible for cash discount in document currency
SettlmtDocListItemNetAmount New Value of the Item in a List
SettlmtDocListItemTaxAmount 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
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
SettlmtDocListCat Settlement Management Document Category Show values
LogisticsDataEntryCat Entry Category for Logistics Data Show values
SettlmtDocListAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
SettlmtDocListIsReversed Settlement Document List Is Reversed Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
DocIntrastatRelevance Document is Relevant for Intrastat Declarations Show values
IntrastatDeclnGdsFlwCat Type of Goods Flow for Intrastat Declarations Show values
SettlmtBusProcCat Use Case Type Show values
SettlmtDocListItemCat Category of List Document Item Show values
SettlmtDocListItemIsReversed 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
PricingProcedure Pricing Procedure KALSM
CreatedByUser Name of User who Created the Document USNAM
ExchangeRate Conversion Rate (Not Converted)
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
PaymentMethod Payment Method ZLSCH
AdditionalValueDays Additional Value Days TAGE2
SettlmtCoCodeTaxCountry Tax Country/Region Company Code LAND1
VATRegistration VAT Registration Number STCEG
PaymentReference Payment Reference CHAR30
SettlmtDocListPaytCrcyExchRate Exchange Rate of Payment Currency (not converted)
OneTimeSettlmtPartAddrID Address of One-Time Settlement Partner AD_ADDRNUM
FiscalPeriod Fiscal Period POPER
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
RefSuplrBillgDoc Reference Supplier Billing Document Number WBELN
RefSettlmtDoc Ref Settlement Document WBELN
RefCustSettlmtList Reference Customer Settlement List WBELN
RefSuplrSettlmtList Reference Supplier Settlement List WBELN
RefSettlmtDocList Reference Settlement Document List WBELN
RefCustSettlmt Ref Customer Settlement WBELN
RefExpnSettlmt Reference Expense Settlement WBELN
RefSuplrSettlmt Reference Supplier Settlement WBELN
SettlmtExtBillgDoc External Billing Document in Settlement Management VBELN
SettlmtExtAcctgDocCompanyCode Company Code of External Accounting Doc in Settlmt Mgmt BUKRS
SettlmtExtAcctgDoc External Accounting Document in Settlement Management BELNR
SettlmtExtAcctgDocFiscalYear Year of External Accounting Doc in Settlement Management GJAHR
SettlmtExtAcctgDocItem External Accounting Document Item in Settlement Management BUZEI
Master Data Relations Join Conditions
Alternative Supplier
  • Alternative Supplier
  • Client
  • R_SETTLMTDOCLISTDEX.ALTERNATIVEINVOICINGPARTY == LFA1.LIFNR
  • R_SETTLMTDOCLISTDEX.MANDT == LFA1.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • R_SETTLMTDOCLISTDEX.BILLTOPARTY == KNA1.KUNNR
  • R_SETTLMTDOCLISTDEX.MANDT == KNA1.MANDT
Company Code
  • Company Code
  • Client
  • R_SETTLMTDOCLISTDEX.COMPANYCODE == T001.BUKRS
  • R_SETTLMTDOCLISTDEX.MANDT == T001.MANDT
Credit Control Area
  • Credit Control Area
  • Client
  • R_SETTLMTDOCLISTDEX.CREDITCONTROLAREA == T014.KKBER
  • R_SETTLMTDOCLISTDEX.MANDT == T014.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • R_SETTLMTDOCLISTDEX.MANDT == TVTW.MANDT
  • R_SETTLMTDOCLISTDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • R_SETTLMTDOCLISTDEX.DIVISION == TSPA.SPART
  • R_SETTLMTDOCLISTDEX.MANDT == TSPA.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • R_SETTLMTDOCLISTDEX.EXCHANGERATETYPE == TCURV.KURST
  • R_SETTLMTDOCLISTDEX.MANDT == TCURV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • R_SETTLMTDOCLISTDEX.INCOTERMSCLASSIFICATION == TINC.INCO1
  • R_SETTLMTDOCLISTDEX.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • R_SETTLMTDOCLISTDEX.INCOTERMSVERSION == TINCV.INCOV
  • R_SETTLMTDOCLISTDEX.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • R_SETTLMTDOCLISTDEX.INVOICINGPARTY == LFA1.LIFNR
  • R_SETTLMTDOCLISTDEX.MANDT == LFA1.MANDT
Payee
  • Payee
  • Client
  • R_SETTLMTDOCLISTDEX.PAYEEPARTY == LFA1.LIFNR
  • R_SETTLMTDOCLISTDEX.MANDT == LFA1.MANDT
Payer
  • Payer
  • Client
  • R_SETTLMTDOCLISTDEX.PAYERPARTY == KNA1.KUNNR
  • R_SETTLMTDOCLISTDEX.MANDT == KNA1.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • R_SETTLMTDOCLISTDEX.PURCHASINGGROUP == T024.EKGRP
  • R_SETTLMTDOCLISTDEX.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • R_SETTLMTDOCLISTDEX.MANDT == T024E.MANDT
  • R_SETTLMTDOCLISTDEX.PURCHASINGORGANIZATION == T024E.EKORG
Sales Organization
  • Client
  • Sales Organization
  • R_SETTLMTDOCLISTDEX.MANDT == TVKO.MANDT
  • R_SETTLMTDOCLISTDEX.SALESORGANIZATION == TVKO.VKORG
Application Status for a Settlement Management Document
  • Client
  • Application Status for a Settlement Management Document
  • R_SETTLMTDOCLISTDEX.MANDT == TMPA2.MANDT
  • R_SETTLMTDOCLISTDEX.SETTLMTAPPLSTS == TMPA2.ESTATUS
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • R_SETTLMTDOCLISTDEX.MANDT == TMPA4.MANDT
  • R_SETTLMTDOCLISTDEX.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
Settlement Management Process Category
  • Settlement Management Process Category
  • Client
Header Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • Client
  • R_SETTLMTDOCLISTDEX.SETTLMTDOCLISTACTIVITYREASON == TMLFG.LFGRU
  • R_SETTLMTDOCLISTDEX.MANDT == TMLFG.MANDT
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_SETTLMTDOCLISTDEX.MANDT == TCURC.MANDT
  • R_SETTLMTDOCLISTDEX.SETTLMTDOCLISTCURRENCY == TCURC.WAERS
Incompleteness Reason of Settlement Management Document
  • Incompleteness Reason of Settlement Management Document
  • Client
  • R_SETTLMTDOCLISTDEX.SETTLMTDOCLISTINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
  • R_SETTLMTDOCLISTDEX.MANDT == TWLF_IR.MANDT
Settlement Document List Type
  • Client
  • Settlement Document List Type
  • R_SETTLMTDOCLISTDEX.MANDT == TRRLCG.MANDT
  • R_SETTLMTDOCLISTDEX.SETTLMTDOCLISTTYPE == TRRLCG.RRLCG
Settlement Document Type
  • Client
  • Settlement Document Type
  • R_SETTLMTDOCLISTDEX.MANDT == TMFK.MANDT
  • R_SETTLMTDOCLISTDEX.SETTLMTDOCTYPE == TMFK.LFART
Settlement Process Type
  • Settlement Process Type
  • Client
  • R_SETTLMTDOCLISTDEX.SETTLMTPROCESSTYPE == TMZR.WRART
  • R_SETTLMTDOCLISTDEX.MANDT == TMZR.MANDT
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • R_SETTLMTDOCLISTDEX.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • R_SETTLMTDOCLISTDEX.MANDT == T015L.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • R_SETTLMTDOCLISTDEX.SUPPLYINGCOUNTRY == T005.LAND1
  • R_SETTLMTDOCLISTDEX.MANDT == T005.MANDT
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • R_SETTLMTDOCLISTDEX.TAXDEPARTURECOUNTRY == T005.LAND1
  • R_SETTLMTDOCLISTDEX.MANDT == T005.MANDT
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • R_SETTLMTDOCLISTDEX.TAXDESTINATIONCOUNTRY == T005.LAND1
  • R_SETTLMTDOCLISTDEX.MANDT == T005.MANDT