C_CustSettlmtListOutputForm

Customer Settlement List Output Form | view: CWLFCUSTSTLSTOF | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRK
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)
CustomerTotalTaxAmount Total Tax Amount in Document Currency
CustTotEligibleAmtForCshDisc Total Amount eligible for cash discount in document currency
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
CustomerFixedValueDate Fixed Value Date
SettlmtDate Rebates: Settlement Date
Column Name Description
SettlmtDocCat Settlement Document Category Show values
LogisticsDataEntryCat Entry Category for Logistics Data Show values
SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
CustSettlmtListIsCanceled Settlement Management Document 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
Column Name Description Domain name
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
CustomerPricingProcedure Pricing Procedure KALSM
CreatedByUser Name of User who Created the Document USNAM
ExchangeRate Conversion Rate (Not Converted)
CustomerPaymentTerms Terms of Payment Key for Customer ZTERM
CustomerCashDiscount1Days Customer Cash Discount First Payment in Days ZBDXT
CustomerCashDiscount2Days Customer Cash Discount Second Payment in Days ZBDXT
CustomerNetPaymentDays Customer Cash Discount Days ZBDXT
CustomerCashDiscount1Percent Customer Cash Discount for First Payment in % PRZ23
CustomerCashDiscount2Percent Custromer Cash Discount for Second Payment in % PRZ23
CustomerAdditionalValueDays Additional Value Days TAGE2
CustSettlmtCoCodeTaxCountry Tax Country/Region Company Code Customer LAND1
CustomerVATRegistration VAT Registration Number STCEG
PaymentReference Payment Reference CHAR30
CustomerPaytCurrencyExchRate Exchange Rate of Payment Currency (not converted)
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
Master Data Relations Join Conditions
Bill-to Party
  • Bill-to Party
  • Client
  • C_CUSTSETTLMTLISTOUTPUTFORM.BILLTOPARTY == KNA1.KUNNR
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == KNA1.MANDT
Credit Control Area
  • Credit Control Area
  • Client
  • C_CUSTSETTLMTLISTOUTPUTFORM.CREDITCONTROLAREA == T014.KKBER
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == T014.MANDT
Payment Currency
  • Client
  • Payment Currency
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TCURC.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.CUSTOMERPAYMENTCURRENCY == TCURC.WAERS
Customer Payment Method
  • ?
  • Client
  • Customer Payment Method
  • C_CUSTSETTLMTLISTOUTPUTFORM.[column in domain "LAND1"] == T042Z.LAND1
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == T042Z.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.CUSTOMERPAYMENTMETHOD == T042Z.ZLSCH
Company Code
  • Client
  • Company Code
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == T001.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.CUSTSETTLMTCOMPANYCODE == T001.BUKRS
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TCURC.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.CUSTSETTLMTLISTCURRENCY == TCURC.WAERS
Incompleteness Reason of Settlement Management Document
  • Client
  • Incompleteness Reason of Settlement Management Document
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TWLF_IR.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.CUSTSETTLMTLISTINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
Distribution Channel
  • Client
  • Distribution Channel
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TVTW.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TSPA.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.DIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TCURV.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.EXCHANGERATETYPE == TCURV.KURST
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TINC.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TINCV.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.INCOTERMSVERSION == TINCV.INCOV
Address of One-Time Customer
  • Client
  • Posting Date
  • ?
  • Address of One-Time Customer
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == ADRC.CLIENT
  • C_CUSTSETTLMTLISTOUTPUTFORM.POSTINGDATE == ADRC.DATE_FROM
  • C_CUSTSETTLMTLISTOUTPUTFORM.[column in domain "AD_NATION"] == ADRC.NATION
  • C_CUSTSETTLMTLISTOUTPUTFORM.ONETIMECUSTOMERADDRESSID == ADRC.ADDRNUMBER
Payer
  • Client
  • Payer
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == KNA1.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.PAYERPARTY == KNA1.KUNNR
Sales Organization
  • Client
  • Sales Organization
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TVKO.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.SALESORGANIZATION == TVKO.VKORG
Application Status for a Settlement Management Document
  • Client
  • Application Status for a Settlement Management Document
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TMPA2.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.SETTLMTAPPLSTS == TMPA2.ESTATUS
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TMPA4.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
Settlement Management Process Category
  • Client
  • Settlement Management Process Category
Header Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • Client
  • C_CUSTSETTLMTLISTOUTPUTFORM.SETTLMTDOCACTIVITYREASON == TMLFG.LFGRU
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TMLFG.MANDT
Settlement Document Type
  • Settlement Document Type
  • Client
  • C_CUSTSETTLMTLISTOUTPUTFORM.SETTLMTDOCTYPE == TMFK.LFART
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TMFK.MANDT
Settlement Process Type
  • Client
  • Settlement Process Type
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == TMZR.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.SETTLMTPROCESSTYPE == TMZR.WRART
State Central Bank Indicator
  • Client
  • State Central Bank Indicator
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == T015L.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == T005.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.SUPPLYINGCOUNTRY == T005.LAND1
Tax Departure Country/Region
  • Client
  • Tax Departure Country/Region
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == T005.MANDT
  • C_CUSTSETTLMTLISTOUTPUTFORM.TAXDEPARTURECOUNTRY == T005.LAND1
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • C_CUSTSETTLMTLISTOUTPUTFORM.TAXDESTINATIONCOUNTRY == T005.LAND1
  • C_CUSTSETTLMTLISTOUTPUTFORM.MANDT == T005.MANDT