R_CustSettlmtDEX

Customer Settlement Basic Extraction | view: RWLFCUSTSMTDEX | Extraction: Not supported | Component: Settlement Management
Tables used: WBRK, WBRP, TMFK
Column Name Description
CustSettlmt FK Customer Settlement
CustSettlmtItem Document Item
Column Name Description
💲 Currency of Settlement Document (CustSettlmtCurrency):
CustSettlmtTotalGrossAmount Gross Settlement Amount in Document Currency
CustSettlmtTotalNetAmount Net Settlement Amount in Document Currency
CustSettlmtTotalTaxAmount Total Tax Amount in Document Currency
CustTotEligibleAmtForCshDisc Total Amount eligible for cash discount in document currency
NetPriceAmount Net Price in Document Currency
CustSettlmtItemGrossAmount Gross Amount of Item in Document Currency
CustSettlmtItemNetAmount Net Amount of Item in Document Currency
CustSettlmtItemTaxAmount Item Tax Amount in Document Currency
CustSettlmtSubtotal1Amount Subtotal 1 Amount
CustSettlmtSubtotal2Amount Subtotal 2 Amount
CustSettlmtSubtotal3Amount Subtotal 3 Amount
CustSettlmtSubtotal4Amount Subtotal 4 Amount
CustSettlmtSubtotal5Amount Subtotal 5 Amount
CustSettlmtSubtotal6Amount Subtotal 6 Amount
CustSettlmtRebateBasisAmount Rebate Basis Amount
CustSettlmtEffectiveItemAmount Effective Amount of Item
CustItmEligibleAmtForCshDisc Amount Eligible for Cash Discount in Document Currency
NonDeductibleInputTaxAmount Non Deductible Input Tax Amount
💲 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
📏 Unit of Measure of Settlement Management Doc Item Quantity (SettlmtQuantityUnit):
SettlmtQuantity Quantity of Settlement Management Document Item
📏 Weight Unit (ItemWeightUnit):
ItemNetWeight Net Weight
ItemGrossWeight Gross Weight
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume
📏 Quantity Unit of Purchase Points of a Product (ProductPurchasePointsQtyUnit):
ProductPurchasePointsQty Purchase Points Quantity of a Product
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
PricingDate Date for Pricing and Exchange Rate
ServicesRenderedDate Date of Services Rendered
Column Name Description
SettlmtDocCat Settlement Document Category Show values
LogisticsDataEntryCat Entry Category for Logistics Data Show values
SettlmtCat Settlement Category Show values
CustSettlmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
CustSettlmtIsReversed Customer 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
CustSettlmtItmStstclPrpty Statistical Property of Settlement Management Item Show values
CashDiscountIsDeductible Cash Discount is Deductible Show values
SettlmtSourceDocCat Document Category of Source Document Show values
PrcDetnIsIncmplt Price Determination is Incomplete Show values
SettlmtPrecdgDocCat Document Category of Preceding Document Show values
CustSettlmtItmCat Item Category Show values
SettlmtItemReltdRefDocCat Settlement Item Related Reference Document Category Show values
CustSettlmtItemStatus Item Status Show values
CustSettlmtItemReversed Item Was Canceled Show values
LowerLevelItemExists Subitems Exist Show values
ItemDistributionStatus Status Distribution of Item Show values
SettlmtRefDocCat Reference Document Category in Settlement Management Show values
ItemIntrastatRelevance Document Item Is Relevant for Intrastat Declarations Show values
SettlmtAddlRefDocCat Additional Reference Document Category 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
CustSettlmtPaytCrcyExchRate 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
NetPriceQuantity Price Unit of Settlement Management Document Item DEC5
SettlmtToBaseQuantityNmrtr Numerator Converting Qty in Settlement Document to Base Unit UMBSZ
SettlmtToBaseQuantityDnmntr Denominator Converting Qty in Settlement Doc. to Base Unit UMBSN
SettlmtToNetPriceQtyNmrtr Numerator for Converting Settl. UoM to Settl. Price UoM UMBSZ
SettlmtToNetPriceQtyDnmntr Denominator for Converting Settl. UoM to Settl. Price UoM UMBSZ
SettlmtRefDocReltdFiscalYear Fiscal Year GJAHR
SettlmtSourceDoc Document Number of the Source Document CHAR10
SettlmtSourceDocItem Item Number of the Source Document Item NUMC6
SettlmtSourceDocFiscalYear Fiscal Year of a Source Document in Settlement Management GJAHR
CustSettlmtItemText Short Text TEXT40
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
SettlmtPrecdgDoc Preceding Document of the Settlement Management Document CHAR10
SettlmtPrecdgDocItem Preceding Document Item in the Settlement Management Doc. NUMC6
SettlmtPrecdgDocFiscalYear Fiscal Year of a Preceding Document in Settlement Management GJAHR
SettlmtItemReltdRefDoc Settlement Item Related Reference Document WCONTRACT
SettlmtItemReltdCndnContr Related Condition Contract of a Settlement Management Item WCB_COCO_NUM
SettlementFiscalYear Fiscal Year of Settlement GJAHR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SettlmtRefDocType Type of Reference Document for Settlement Management WLF_REF_DOC_TYPE
SettlmtRefDoc Reference Document for Settlement Management WLF_REF_DOC_NUMBER
SettlmtRefDocFiscalYear Year of Reference Document for Settlement Management GJAHR
SettlmtRefDocLogicalSyst Logical System of Reference Document for Smt Mgmt LOGSYS
SettlmtRefDocItem Reference Document Item for Settlement Management Document WLF_REF_ITEM_NUMBER
SettlmtAddlRefDocType Type of Additional Reference Document for Settlmt Mgmt WLF_REF_DOC_TYPE
SettlmtAddlRefDoc Additional Reference Document for Settlement Management WLF_REF_DOC_NUMBER
SettlmtAddlRefDocFiscalYear Year of Additional Reference Document for Smt Mgmt GJAHR
SettlmtAddlRefDocLogicalSyst Logical System of Additional Reference Document for Smt Mgmt LOGSYS
SettlmtAddlRefDocItem Additional Reference Doc Item for Settlement Mgmt. Document WLF_REF_ITEM_NUMBER
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT
  • R_CUSTSETTLMTDEX.BASEUNIT == T006.MSEHI
Batch Number
  • Product Number
  • Batch Number
  • Client
  • R_CUSTSETTLMTDEX.PRODUCT == MCH1.MATNR
  • R_CUSTSETTLMTDEX.BATCH == MCH1.CHARG
  • R_CUSTSETTLMTDEX.MANDT == MCH1.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • R_CUSTSETTLMTDEX.BILLTOPARTY == KNA1.KUNNR
  • R_CUSTSETTLMTDEX.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • R_CUSTSETTLMTDEX.BUSINESSAREA == TGSB.GSBER
  • R_CUSTSETTLMTDEX.MANDT == TGSB.MANDT
Condition Contract Type
  • Client
  • Condition Contract Type
Company Code
  • Client
  • Company Code
  • R_CUSTSETTLMTDEX.MANDT == T001.MANDT
  • R_CUSTSETTLMTDEX.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • R_CUSTSETTLMTDEX.CONTROLLINGAREA == TKA01.KOKRS
  • R_CUSTSETTLMTDEX.MANDT == TKA01.MANDT
Credit Control Area
  • Client
  • Credit Control Area
  • R_CUSTSETTLMTDEX.MANDT == T014.MANDT
  • R_CUSTSETTLMTDEX.CREDITCONTROLAREA == T014.KKBER
Order for Account Assignment in Settlement Management
  • Client
  • Order for Account Assignment in Settlement Management
  • R_CUSTSETTLMTDEX.MANDT == AUFK.MANDT
  • R_CUSTSETTLMTDEX.CUSTOMERSETTLEMENTORDER == AUFK.AUFNR
Customer Settlement Recipient
  • Client
  • Customer Settlement Recipient
  • R_CUSTSETTLMTDEX.MANDT == KNA1.MANDT
  • R_CUSTSETTLMTDEX.CUSTOMERSETTLMTRECIPIENT == KNA1.KUNNR
Header Activity Reason for Document Creation
  • Client
  • Header Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • R_CUSTSETTLMTDEX.MANDT == TMLFG.MANDT
  • R_CUSTSETTLMTDEX.CUSTSETTLMTACTIVITYREASON == TMLFG.LFGRU
  • R_CUSTSETTLMTDEX.CUSTSETTLMTITMACTIVITYREASON == TMLFG.LFGRU
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_CUSTSETTLMTDEX.MANDT == TCURC.MANDT
  • R_CUSTSETTLMTDEX.CUSTSETTLMTCURRENCY == TCURC.WAERS
Incompleteness Reason of Settlement Management Document
  • Incompleteness Reason of Settlement Management Document
  • Client
  • R_CUSTSETTLMTDEX.CUSTSETTLMTINCMPLTNSRSN == TWLF_IR.INCOMPL_REASON
  • R_CUSTSETTLMTDEX.MANDT == TWLF_IR.MANDT
Activity Reason for Document Creation
  • Client
  • Header Activity Reason for Document Creation
  • Activity Reason for Document Creation
  • R_CUSTSETTLMTDEX.MANDT == TMLFG.MANDT
  • R_CUSTSETTLMTDEX.CUSTSETTLMTACTIVITYREASON == TMLFG.LFGRU
  • R_CUSTSETTLMTDEX.CUSTSETTLMTITMACTIVITYREASON == TMLFG.LFGRU
Payment Currency
  • Client
  • Payment Currency
  • R_CUSTSETTLMTDEX.MANDT == TCURC.MANDT
  • R_CUSTSETTLMTDEX.CUSTSETTLMTPAYMENTCURRENCY == TCURC.WAERS
Distribution Channel
  • Client
  • Distribution Channel
  • R_CUSTSETTLMTDEX.MANDT == TVTW.MANDT
  • R_CUSTSETTLMTDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • R_CUSTSETTLMTDEX.MANDT == TSPA.MANDT
  • R_CUSTSETTLMTDEX.DIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • R_CUSTSETTLMTDEX.MANDT == TCURV.MANDT
  • R_CUSTSETTLMTDEX.EXCHANGERATETYPE == TCURV.KURST
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • R_CUSTSETTLMTDEX.INCOTERMSCLASSIFICATION == TINC.INCO1
  • R_CUSTSETTLMTDEX.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • R_CUSTSETTLMTDEX.INCOTERMSVERSION == TINCV.INCOV
  • R_CUSTSETTLMTDEX.MANDT == TINCV.MANDT
Inventory Valuation Type
  • Client
  • Inventory Valuation Type
  • R_CUSTSETTLMTDEX.MANDT == T149D.MANDT
  • R_CUSTSETTLMTDEX.INVENTORYVALUATIONTYPE == T149D.BWTAR
Volume unit
  • Volume unit
  • Client
  • R_CUSTSETTLMTDEX.ITEMVOLUMEUNIT == T006.MSEHI
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT
Weight Unit
  • Client
  • Weight Unit
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT
  • R_CUSTSETTLMTDEX.ITEMWEIGHTUNIT == T006.MSEHI
Settlement Management Document Item Price Unit
  • Client
  • Settlement Management Document Item Price Unit
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT
  • R_CUSTSETTLMTDEX.NETPRICEQUANTITYUNIT == T006.MSEHI
Address of One-Time Customer
  • ?
  • Address of One-Time Customer
  • Client
  • Posting Date
  • R_CUSTSETTLMTDEX.[column in domain "AD_NATION"] == ADRC.NATION
  • R_CUSTSETTLMTDEX.ONETIMECUSTOMERADDRESSID == ADRC.ADDRNUMBER
  • R_CUSTSETTLMTDEX.MANDT == ADRC.CLIENT
  • R_CUSTSETTLMTDEX.POSTINGDATE == ADRC.DATE_FROM
Payer
  • Payer
  • Client
  • R_CUSTSETTLMTDEX.PAYERPARTY == KNA1.KUNNR
  • R_CUSTSETTLMTDEX.MANDT == KNA1.MANDT
Payment Method
  • ?
  • Client
  • Payment Method
  • R_CUSTSETTLMTDEX.[column in domain "LAND1"] == T042Z.LAND1
  • R_CUSTSETTLMTDEX.MANDT == T042Z.MANDT
  • R_CUSTSETTLMTDEX.PAYMENTMETHOD == T042Z.ZLSCH
Plant
  • Client
  • Plant
  • R_CUSTSETTLMTDEX.MANDT == T001W.MANDT
  • R_CUSTSETTLMTDEX.PLANT == T001W.WERKS
Pricing Procedure
  • Pricing Procedure
  • ?
  • ?
  • Client
  • R_CUSTSETTLMTDEX.PRICINGPROCEDURE == T683.KALSM
  • R_CUSTSETTLMTDEX.[column in domain "KAPPL"] == T683.KAPPL
  • R_CUSTSETTLMTDEX.[column in domain "KVEWE"] == T683.KVEWE
  • R_CUSTSETTLMTDEX.MANDT == T683.MANDT
Product Number
  • Product Number
  • Client
  • R_CUSTSETTLMTDEX.PRODUCT == MARA.MATNR
  • R_CUSTSETTLMTDEX.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • R_CUSTSETTLMTDEX.MANDT == T023.MANDT
  • R_CUSTSETTLMTDEX.PRODUCTGROUP == T023.MATKL
Product hierarchy
  • Product hierarchy
  • Client
  • R_CUSTSETTLMTDEX.PRODUCTHIERARCHY == T179.PRODH
  • R_CUSTSETTLMTDEX.MANDT == T179.MANDT
Quantity Unit of Purchase Points of a Product
  • Client
  • Quantity Unit of Purchase Points of a Product
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT
  • R_CUSTSETTLMTDEX.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI
Check Sales Group
  • Client
  • Sales group
  • R_CUSTSETTLMTDEX.MANDT == TVKGR.MANDT
  • R_CUSTSETTLMTDEX.SALESGROUP == TVKGR.VKGRP
Check Sales Office
  • Client
  • Sales office
  • R_CUSTSETTLMTDEX.MANDT == TVBUR.MANDT
  • R_CUSTSETTLMTDEX.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • R_CUSTSETTLMTDEX.MANDT == TVKO.MANDT
  • R_CUSTSETTLMTDEX.SALESORGANIZATION == TVKO.VKORG
Sales-Specific Product Group 1
  • Client
  • Sales-Specific Product Group 1
  • R_CUSTSETTLMTDEX.MANDT == TVM1.MANDT
  • R_CUSTSETTLMTDEX.SALESSPCFCPRODUCTGROUP1 == TVM1.MVGR1
Sales-Specific Product Group 2
  • Client
  • Sales-Specific Product Group 2
  • R_CUSTSETTLMTDEX.MANDT == TVM2.MANDT
  • R_CUSTSETTLMTDEX.SALESSPCFCPRODUCTGROUP2 == TVM2.MVGR2
Sales-Specific Product Group 3
  • Sales-Specific Product Group 3
  • Client
  • R_CUSTSETTLMTDEX.SALESSPCFCPRODUCTGROUP3 == TVM3.MVGR3
  • R_CUSTSETTLMTDEX.MANDT == TVM3.MANDT
Sales-Specific Product Group 4
  • Client
  • Sales-Specific Product Group 4
  • R_CUSTSETTLMTDEX.MANDT == TVM4.MANDT
  • R_CUSTSETTLMTDEX.SALESSPCFCPRODUCTGROUP4 == TVM4.MVGR4
Sales-Specific Product Group 5
  • Client
  • Sales-Specific Product Group 5
  • R_CUSTSETTLMTDEX.MANDT == TVM5.MANDT
  • R_CUSTSETTLMTDEX.SALESSPCFCPRODUCTGROUP5 == TVM5.MVGR5
Application Status for a Settlement Management Document
  • Client
  • Application Status for a Settlement Management Document
  • R_CUSTSETTLMTDEX.MANDT == TMPA2.MANDT
  • R_CUSTSETTLMTDEX.SETTLMTAPPLSTS == TMPA2.ESTATUS
Status Group for Settlement Management Documents
  • Client
  • Status Group for Settlement Management Documents
  • R_CUSTSETTLMTDEX.MANDT == TMPA4.MANDT
  • R_CUSTSETTLMTDEX.SETTLMTAPPLSTSGRP == TMPA4.STATGRP
Settlement Management Process Category
  • Client
  • Settlement Management Process Category
Tax Country/Region Company Code
  • Client
  • Tax Country/Region Company Code
  • R_CUSTSETTLMTDEX.MANDT == T005.MANDT
  • R_CUSTSETTLMTDEX.SETTLMTCOCODETAXCOUNTRY == T005.LAND1
Settlement Document Type
  • Client
  • Settlement Document Type
  • R_CUSTSETTLMTDEX.MANDT == TMFK.MANDT
  • R_CUSTSETTLMTDEX.SETTLMTDOCTYPE == TMFK.LFART
Settlement Process Type
  • Client
  • Settlement Process Type
  • R_CUSTSETTLMTDEX.MANDT == TMZR.MANDT
  • R_CUSTSETTLMTDEX.SETTLMTPROCESSTYPE == TMZR.WRART
Unit of Measure of Settlement Management Doc Item Quantity
  • Client
  • Unit of Measure of Settlement Management Doc Item Quantity
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT
  • R_CUSTSETTLMTDEX.SETTLMTQUANTITYUNIT == T006.MSEHI
Tax on Sales/Purchases Code
  • ?
  • Tax on Sales/Purchases Code
  • Client
  • R_CUSTSETTLMTDEX.[column in domain "KALSM_D"] == T007A.KALSM
  • R_CUSTSETTLMTDEX.TAXCODE == T007A.MWSKZ
  • R_CUSTSETTLMTDEX.MANDT == T007A.MANDT
Tax Reporting Country/Region
  • Client
  • Tax Reporting Country/Region
  • R_CUSTSETTLMTDEX.MANDT == T005.MANDT
  • R_CUSTSETTLMTDEX.TAXCOUNTRY == T005.LAND1
Tax Departure Country/Region
  • Client
  • Tax Departure Country/Region
  • R_CUSTSETTLMTDEX.MANDT == T005.MANDT
  • R_CUSTSETTLMTDEX.TAXDEPARTURECOUNTRY == T005.LAND1
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • R_CUSTSETTLMTDEX.MANDT == T005.MANDT
  • R_CUSTSETTLMTDEX.TAXDESTINATIONCOUNTRY == T005.LAND1
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • R_CUSTSETTLMTDEX.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • R_CUSTSETTLMTDEX.TAXJURISDICTION == TTXJ.TXJCD
  • R_CUSTSETTLMTDEX.MANDT == TTXJ.MANDT
Points Unit for Total Points
  • Points Unit for Total Points
  • Client
  • R_CUSTSETTLMTDEX.TOTALSETTLMTPOINTSQTYUNIT == T006.MSEHI
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT
Volume Unit for Total Volume
  • Client
  • Volume Unit for Total Volume
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT
  • R_CUSTSETTLMTDEX.TOTALSETTLMTVOLUMEUNIT == T006.MSEHI
Unit of Weight for Total Weight
  • Unit of Weight for Total Weight
  • Client
  • R_CUSTSETTLMTDEX.TOTALSETTLMTWEIGHTUNIT == T006.MSEHI
  • R_CUSTSETTLMTDEX.MANDT == T006.MANDT