R_SuplrSettlmt

Supplier Settlement | view: RWLFSUPLRSMT | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK
Column Name Description
SuplrSettlmt Supplier Settlement
Column Name Description
💲 Currency of Settlement Document (SuplrSettlmtCurrency):
SuplrSettlmtTotalGrossAmount Gross Settlement Amount in Document Currency
SuplrSettlmtTotalNetAmount Net Settlement Amount in Document Currency
SuplrSettlmtTotalTaxAmount Total Tax Amount in Document Currency
SuplrTotEligibleAmtForCshDisc Total Amount eligible for cash discount in document currency
💲 Currency of Credit Control Area (CreditControlAreaCurrency):
ReleasedCreditAmount Released credit amount
Column Name Description
📏 Unit of Measure for Total Quantity (TotalSettlmtQuantityUnit):
TotalSettlmtQuantity Total Quantity of the Business Volume in a Settlement Run
📏 Unit of Weight for Total Weight (TotalSettlmtWeightUnit):
TotalSettlmtNetWeight Total Net Weight of the Business Volume in a Settlement Run
TotalSettlmtGrossWeight Total Gross Weight of the Bus Volume in a Settlement Run
📏 Volume Unit for Total Volume (TotalSettlmtVolumeUnit):
TotalSettlmtVolume Total Volume of the Business Volume in a Settlement Run
📏 Points Unit for Total Points (TotalSettlmtPointsQtyUnit):
TotalSettlmtPointsQty Total Points of the Business Volume in a Settlement Run
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
ActualSettlmtDate Actual Settlement Date
SettlmtDate Rebates: Settlement Date
SettlmtPeriodStartDate Start Date of Settlement Period
SettlmtPeriodEndDate End Date of Settlement Period
Column Name Description
SettlmtDocCat Settlement Document Category Show values
LogisticsDataEntryCat Entry Category for Logistics Data Show values
SettlmtCat Settlement Category Show values
SuplrSettlmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
SuplrSettlmtIsReversed Supplier Settlement Is Reversed Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
SettlmtReltdRefDocCat Contract Category of Related Contract Show values
SettlmtDateCat Rebates: Settlement Date Type 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
CndnContrProcessCategory Process Category of a Condition Contract Show values
Column Name Description Domain name
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
PricingDocument Number of the Document Condition KNUMV
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
AdditionalValueDays Additional Value Days TAGE2
VATRegistration VAT Registration Number STCEG
PaymentReference Payment Reference CHAR30
SuplrSettlmtPaytCrcyExchRate Exchange Rate of Payment Currency (not converted)
SettlmtReltdRefDoc Related Contract in the Settlement Management Doc. WCONTRACT
SettlmtReltdCndnContr Related Condition Contract in Settlement Management WCB_COCO_NUM
FiscalPeriod Fiscal Period POPER
SettlmtDateSequentialID Settlement Date - Sequential ID WB2_SETTLEMENT_DATE_SEQ_ID
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
Alternative Supplier
  • Alternative Supplier
  • Client
  • R_SUPLRSETTLMT.ALTERNATIVEINVOICINGPARTY == LFA1.LIFNR
  • R_SUPLRSETTLMT.MANDT == LFA1.MANDT
Condition Contract Type
  • Condition Contract Type
  • Client
Company Code
  • Company Code
  • Client
  • R_SUPLRSETTLMT.COMPANYCODE == T001.BUKRS
  • R_SUPLRSETTLMT.MANDT == T001.MANDT
Credit Control Area
  • Credit Control Area
  • Client
  • R_SUPLRSETTLMT.CREDITCONTROLAREA == T014.KKBER
  • R_SUPLRSETTLMT.MANDT == T014.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • R_SUPLRSETTLMT.EXCHANGERATETYPE == TCURV.KURST
  • R_SUPLRSETTLMT.MANDT == TCURV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • R_SUPLRSETTLMT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • R_SUPLRSETTLMT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • R_SUPLRSETTLMT.INCOTERMSVERSION == TINCV.INCOV
  • R_SUPLRSETTLMT.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • R_SUPLRSETTLMT.INVOICINGPARTY == LFA1.LIFNR
  • R_SUPLRSETTLMT.MANDT == LFA1.MANDT
Address of One-Time Supplier
  • ?
  • Posting Date
  • Address of One-Time Supplier
  • Client
  • R_SUPLRSETTLMT.[column in domain "AD_NATION"] == ADRC.NATION
  • R_SUPLRSETTLMT.POSTINGDATE == ADRC.DATE_FROM
  • R_SUPLRSETTLMT.ONETIMESUPPLIERADDRESSID == ADRC.ADDRNUMBER
  • R_SUPLRSETTLMT.MANDT == ADRC.CLIENT
Payee
  • Payee
  • Client
  • R_SUPLRSETTLMT.PAYEEPARTY == LFA1.LIFNR
  • R_SUPLRSETTLMT.MANDT == LFA1.MANDT
Payment Method
  • ?
  • Client
  • Payment Method
  • R_SUPLRSETTLMT.[column in domain "LAND1"] == T042Z.LAND1
  • R_SUPLRSETTLMT.MANDT == T042Z.MANDT
  • R_SUPLRSETTLMT.PAYMENTMETHOD == T042Z.ZLSCH
Pricing Procedure
  • ?
  • Pricing Procedure
  • ?
  • Client
  • R_SUPLRSETTLMT.[column in domain "KVEWE"] == T683.KVEWE
  • R_SUPLRSETTLMT.PRICINGPROCEDURE == T683.KALSM
  • R_SUPLRSETTLMT.[column in domain "KAPPL"] == T683.KAPPL
  • R_SUPLRSETTLMT.MANDT == T683.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • R_SUPLRSETTLMT.PURCHASINGGROUP == T024.EKGRP
  • R_SUPLRSETTLMT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • R_SUPLRSETTLMT.PURCHASINGORGANIZATION == T024E.EKORG
  • R_SUPLRSETTLMT.MANDT == T024E.MANDT
Application Status for a Settlement Management Document
  • Application Status for a Settlement Management Document
  • Client
  • R_SUPLRSETTLMT.SETTLMTAPPLSTS == TMPA2.ESTATUS
  • R_SUPLRSETTLMT.MANDT == TMPA2.MANDT
Status Group for Settlement Management Documents
  • Status Group for Settlement Management Documents
  • Client
  • R_SUPLRSETTLMT.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
  • R_SUPLRSETTLMT.MANDT == TMPA4.MANDT
Settlement Management Process Category
  • Client
  • Settlement Management Process Category
Tax Country/Region Company Code
  • Tax Country/Region Company Code
  • Client
  • R_SUPLRSETTLMT.SETTLMTCOCODETAXCOUNTRY == T005.LAND1
  • R_SUPLRSETTLMT.MANDT == T005.MANDT
Settlement Document Type
  • Settlement Document Type
  • Client
  • R_SUPLRSETTLMT.SETTLMTDOCTYPE == TMFK.LFART
  • R_SUPLRSETTLMT.MANDT == TMFK.MANDT
Settlement Process Type
  • Client
  • Settlement Process Type
  • R_SUPLRSETTLMT.MANDT == TMZR.MANDT
  • R_SUPLRSETTLMT.SETTLMTPROCESSTYPE == TMZR.WRART
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • R_SUPLRSETTLMT.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • R_SUPLRSETTLMT.MANDT == T015L.MANDT
Header Activity Reason for Document Creation
  • Header Activity Reason for Document Creation
  • Client
  • R_SUPLRSETTLMT.SUPLRSETTLMTACTIVITYREASON == TMLFG.LFGRU
  • R_SUPLRSETTLMT.MANDT == TMLFG.MANDT
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_SUPLRSETTLMT.MANDT == TCURC.MANDT
  • R_SUPLRSETTLMT.SUPLRSETTLMTCURRENCY == TCURC.WAERS
Incompleteness Reason of Settlement Management Document
  • Incompleteness Reason of Settlement Management Document
  • Client
  • R_SUPLRSETTLMT.SUPLRSETTLMTINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
  • R_SUPLRSETTLMT.MANDT == TWLF_IR.MANDT
Payment Currency
  • Payment Currency
  • Client
  • R_SUPLRSETTLMT.SUPLRSETTLMTPAYMENTCURRENCY == TCURC.WAERS
  • R_SUPLRSETTLMT.MANDT == TCURC.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • R_SUPLRSETTLMT.SUPPLYINGCOUNTRY == T005.LAND1
  • R_SUPLRSETTLMT.MANDT == T005.MANDT
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • R_SUPLRSETTLMT.TAXDEPARTURECOUNTRY == T005.LAND1
  • R_SUPLRSETTLMT.MANDT == T005.MANDT
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • R_SUPLRSETTLMT.TAXDESTINATIONCOUNTRY == T005.LAND1
  • R_SUPLRSETTLMT.MANDT == T005.MANDT
Points Unit for Total Points
  • Points Unit for Total Points
  • Client
  • R_SUPLRSETTLMT.TOTALSETTLMTPOINTSQTYUNIT == T006.MSEHI
  • R_SUPLRSETTLMT.MANDT == T006.MANDT
Volume Unit for Total Volume
  • Volume Unit for Total Volume
  • Client
  • R_SUPLRSETTLMT.TOTALSETTLMTVOLUMEUNIT == T006.MSEHI
  • R_SUPLRSETTLMT.MANDT == T006.MANDT
Unit of Weight for Total Weight
  • Unit of Weight for Total Weight
  • Client
  • R_SUPLRSETTLMT.TOTALSETTLMTWEIGHTUNIT == T006.MSEHI
  • R_SUPLRSETTLMT.MANDT == T006.MANDT