R_SettledSlsOrdItemBasic

Settled Sales Order Item Basic | view: RSETDSODCITBC | Extraction: Not supported | Component: Settlement Management
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, WCOCOH, WBRK, WBRP, WB2_D_BVDETAIL, TWCBCONTRTYPE
Column Name Description
ConditionContract FK Condition Contract
SettlmtDoc FK Document Number
SettlmtDocItem FK Document Item
SettledSalesOrder Sales Order Settled as a Business Volume Document
SettledSalesOrderItem Sales Order Item Settled as a Business Volume Document
Column Name Description
💲 Currency Key (BusVolDocCurrency):
SettledBusVolAmount1 Business Volume 1
SettledBusVolAmount2 Business Volume 2
SettledBusVolAmount3 Business Volume 3
SettledBusVolAmount4 Business Volume 4
BusVolDocItmNetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of measure (SettledBusVolQtyUnit):
SettledBusVolQty Quantity
📏 Weight Unit (SettledBusVolWeightUnit):
SettledBusVolNetWeight Net weight
SettledBusVolGrossWeight Gross weight
📏 Volume unit (SettledBusVolVolumeUnit):
SettledBusVolVolume Volume
📏 Points Unit (SettledBusVolPointsQtyUnit):
SettledBusVolPointsQty Number of Points
📏 Sales unit (BusVolDocItmQuantityUnit):
BusVolDocItmQuantity Cumulative order quantity in sales units
Column Name Description
BusVolSelDteForSettlmt Date for Settlement
DocumentDate Document Date in Settlement Management Document
PostingDate Posting Date
SettlmtDate Rebates: Settlement Date
SettlmtCreationDate Date of Document Creation
BusVolDocExchangeRateDate Translation date
Column Name Description
BusVolDocCat Document Type of Business Volume Source Document Show values
CndnContrSettlmtType Condition Contract Settlement Type Show values
SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
PostingPartnerCat Posting Partner Show values
CndnContrProcessCategory Process Category of a Condition Contract Show values
SDDocumentCategory SD Document Category Show values
IsReturnsItem Returns Item Show values
Column Name Description Domain name
SettlmtDocItemText Short Text TEXT40
SettlmtCostCenter Cost Center KOSTL
SettlmtProfitCenter Profit Center PRCTR
BusVolDocItmText Short text for sales order item TEXT40
BusVolDocItmPlant Plant (Own or External) WERKS
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
Master Data Relations Join Conditions
Alternative Supplier
  • Alternative Supplier
  • Client
  • R_SETTLEDSLSORDITEMBASIC.ALTERNATIVEINVOICINGPARTY == LFA1.LIFNR
  • R_SETTLEDSLSORDITEMBASIC.MANDT == LFA1.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • R_SETTLEDSLSORDITEMBASIC.BASEUNIT == T006.MSEHI
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T006.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • R_SETTLEDSLSORDITEMBASIC.BILLTOPARTY == KNA1.KUNNR
  • R_SETTLEDSLSORDITEMBASIC.MANDT == KNA1.MANDT
Currency Key
  • Client
  • Currency Key
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TCURC.MANDT
  • R_SETTLEDSLSORDITEMBASIC.BUSVOLDOCCURRENCY == TCURC.WAERS
Material: order item
  • Settlement Product
  • Product Number
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLMTPRODUCT == MARA.MATNR
  • R_SETTLEDSLSORDITEMBASIC.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • R_SETTLEDSLSORDITEMBASIC.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • R_SETTLEDSLSORDITEMBASIC.BUSVOLDOCITMPRODUCTGROUP == T023.MATKL
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T023.MANDT
Sales unit
  • Sales unit
  • Client
  • R_SETTLEDSLSORDITEMBASIC.BUSVOLDOCITMQUANTITYUNIT == T006.MSEHI
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T006.MANDT
Condition Contract Category
  • Condition Contract Category
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TWCBCATEGORY.CLIENT
Customer as Partner of a Condition Contract
  • Customer as Partner of a Condition Contract
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRCUSTOMER == KNA1.KUNNR
  • R_SETTLEDSLSORDITEMBASIC.MANDT == KNA1.MANDT
Distribution Channel in a Condition Contract
  • Distribution Channel in a Condition Contract
  • Distribution Channel
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRDISTRCHNL == TVTW.VTWEG
  • R_SETTLEDSLSORDITEMBASIC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TVTW.MANDT
Division in a Condition Contract
  • Division in a Condition Contract
  • Division
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRDIVN == TSPA.SPART
  • R_SETTLEDSLSORDITEMBASIC.DIVISION == TSPA.SPART
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TSPA.MANDT
Condition Contract Process Variant
  • Condition Contract Process Variant
  • Client
Purchasing Group in a Condition Contract
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRPURGGROUP == T024.EKGRP
  • R_SETTLEDSLSORDITEMBASIC.PURCHASINGGROUP == T024.EKGRP
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T024.MANDT
Purchasing Organization in a Condition Contract
  • Purchasing Organization in a Condition Contract
  • Purchasing organization
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRPURGORG == T024E.EKORG
  • R_SETTLEDSLSORDITEMBASIC.PURCHASINGORGANIZATION == T024E.EKORG
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T024E.MANDT
Sales Organization in a Condition Contract
  • Sales Organization in a Condition Contract
  • Sales Organization
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRSLSORG == TVKO.VKORG
  • R_SETTLEDSLSORDITEMBASIC.SALESORGANIZATION == TVKO.VKORG
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TVKO.MANDT
Supplier as Partner of a Condition Contract
  • Client
  • Supplier as Partner of a Condition Contract
  • R_SETTLEDSLSORDITEMBASIC.MANDT == LFA1.MANDT
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRSUPPLIER == LFA1.LIFNR
Condition Contract Type
  • Condition Contract Type
  • Client
Distribution Channel
  • Distribution Channel in a Condition Contract
  • Distribution Channel
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRDISTRCHNL == TVTW.VTWEG
  • R_SETTLEDSLSORDITEMBASIC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TVTW.MANDT
Division
  • Division in a Condition Contract
  • Division
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRDIVN == TSPA.SPART
  • R_SETTLEDSLSORDITEMBASIC.DIVISION == TSPA.SPART
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TSPA.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • R_SETTLEDSLSORDITEMBASIC.INVOICINGPARTY == LFA1.LIFNR
  • R_SETTLEDSLSORDITEMBASIC.MANDT == LFA1.MANDT
Payee
  • Payee
  • Client
  • R_SETTLEDSLSORDITEMBASIC.PAYEEPARTY == LFA1.LIFNR
  • R_SETTLEDSLSORDITEMBASIC.MANDT == LFA1.MANDT
Payer
  • Payer
  • Client
  • R_SETTLEDSLSORDITEMBASIC.PAYERPARTY == KNA1.KUNNR
  • R_SETTLEDSLSORDITEMBASIC.MANDT == KNA1.MANDT
Purchasing Group
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRPURGGROUP == T024.EKGRP
  • R_SETTLEDSLSORDITEMBASIC.PURCHASINGGROUP == T024.EKGRP
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T024.MANDT
Purchasing organization
  • Purchasing Organization in a Condition Contract
  • Purchasing organization
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRPURGORG == T024E.EKORG
  • R_SETTLEDSLSORDITEMBASIC.PURCHASINGORGANIZATION == T024E.EKORG
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization in a Condition Contract
  • Sales Organization
  • Client
  • R_SETTLEDSLSORDITEMBASIC.CNDNCONTRSLSORG == TVKO.VKORG
  • R_SETTLEDSLSORDITEMBASIC.SALESORGANIZATION == TVKO.VKORG
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TVKO.MANDT
Points Unit
  • Points Unit
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLEDBUSVOLPOINTSQTYUNIT == T006.MSEHI
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T006.MANDT
Unit of measure
  • Unit of measure
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLEDBUSVOLQTYUNIT == T006.MSEHI
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T006.MANDT
Volume unit
  • Volume unit
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLEDBUSVOLVOLUMEUNIT == T006.MSEHI
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLEDBUSVOLWEIGHTUNIT == T006.MSEHI
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T006.MANDT
Supplier Company Code
  • Supplier Company Code
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLMTCOMPANYCODE == T001.BUKRS
  • R_SETTLEDSLSORDITEMBASIC.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLMTCONTROLLINGAREA == TKA01.KOKRS
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TKA01.MANDT
Currency of Settlement Document
  • Currency of Settlement Document
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLMTDOCCURRENCY == TCURC.WAERS
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TCURC.MANDT
Settlement Document Type
  • Settlement Document Type
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLMTDOCTYPE == TMFK.LFART
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TMFK.MANDT
Settlement Process Type
  • Settlement Process Type
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLMTPROCESSTYPE == TMZR.WRART
  • R_SETTLEDSLSORDITEMBASIC.MANDT == TMZR.MANDT
Settlement Product
  • Settlement Product
  • Product Number
  • Client
  • R_SETTLEDSLSORDITEMBASIC.SETTLMTPRODUCT == MARA.MATNR
  • R_SETTLEDSLSORDITEMBASIC.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • R_SETTLEDSLSORDITEMBASIC.MANDT == MARA.MANDT