R_SetldSettlmtDocItmAnlyts

Settled Settlement Document Item Analytics | view: RSETDSMTDCITANL | Extraction: Not supported | Component: Settlement Management
Tables used: WCOCOH, WBRK, WBRP, WB2_D_BVDETAIL, TWCBCONTRTYPE
Column Name Description
ConditionContract FK Condition Contract
SettlmtDoc FK Document Number
SettlmtDocItem FK Document Item
SettledSettlmtDoc Settlement Document Settled as a Business Volume Document
SettledSettlmtDocItem Item of a Settled Settlement 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 Amount of the Item in Document Currency
Column Name Description
📏 Unit of measure (SettledBusVolQtyUnit):
SettledBusVolQty Quantity
📏 Weight Unit (SettledBusVolWeightUnit):
SettledBusVolGrossWeight Gross weight
SettledBusVolNetWeight Net weight
📏 Volume unit (SettledBusVolVolumeUnit):
SettledBusVolVolume Volume
📏 Points Unit (SettledBusVolPointsQtyUnit):
SettledBusVolPointsQty Number of Points
📏 Unit of Measure of Settlement Management Doc Item Quantity (BusVolDocItmQuantityUnit):
BusVolDocItmQuantity Quantity of Settlement Management Document Item
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 Exchange Rate 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
Column Name Description Domain name
SettlmtDocItemText Short Text TEXT40
SettlmtCostCenter Cost Center KOSTL
SettlmtProfitCenter Profit Center PRCTR
BusVolDocItmText Short Text for Business Volume Document Item TEXT40
BusVolDocItmToBsQtyNmrtr Numerator Converting Qty in Settlement Document to Base Unit UMBSZ
BusVolDocItmToBsQtyDnmntr Denominator Converting Qty in Settlement Doc. to Base Unit UMBSN
Master Data Relations Join Conditions
Alternative Supplier
  • Client
  • Alternative Supplier
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == LFA1.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.ALTERNATIVEINVOICINGPARTY == LFA1.LIFNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T006.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.BASEUNIT == T006.MSEHI
Bill-to Party
  • Client
  • Bill-to Party
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == KNA1.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.BILLTOPARTY == KNA1.KUNNR
Currency Key
  • Client
  • Currency Key
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TCURC.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.BUSVOLDOCCURRENCY == TCURC.WAERS
Plant
  • Client
  • Plant
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T001W.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.BUSVOLDOCITMPLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • Settlement Product
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == MARA.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLMTPRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Group
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T023.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.BUSVOLDOCITMPRODUCTGROUP == T023.MATKL
Unit of Measure of Settlement Management Doc Item Quantity
  • Client
  • Unit of Measure of Settlement Management Doc Item Quantity
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T006.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.BUSVOLDOCITMQUANTITYUNIT == T006.MSEHI
Condition Contract Category
  • Condition Contract Category
  • Client
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TWCBCATEGORY.CLIENT
Customer as Partner of a Condition Contract
  • Client
  • Customer as Partner of a Condition Contract
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == KNA1.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRCUSTOMER == KNA1.KUNNR
Distribution Channel in a Condition Contract
  • Client
  • Distribution Channel
  • Distribution Channel in a Condition Contract
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TVTW.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRDISTRCHNL == TVTW.VTWEG
Division in a Condition Contract
  • Client
  • Division in a Condition Contract
  • Division
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TSPA.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRDIVN == TSPA.SPART
  • R_SETLDSETTLMTDOCITMANLYTS.DIVISION == TSPA.SPART
Condition Contract Process Variant
  • Client
  • Condition Contract Process Variant
Purchasing Group in a Condition Contract
  • Client
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T024.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRPURGGROUP == T024.EKGRP
  • R_SETLDSETTLMTDOCITMANLYTS.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization in a Condition Contract
  • Client
  • Purchasing organization
  • Purchasing Organization in a Condition Contract
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T024E.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.PURCHASINGORGANIZATION == T024E.EKORG
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRPURGORG == T024E.EKORG
Sales Organization in a Condition Contract
  • Client
  • Sales Organization
  • Sales Organization in a Condition Contract
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TVKO.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SALESORGANIZATION == TVKO.VKORG
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRSLSORG == TVKO.VKORG
Supplier as Partner of a Condition Contract
  • Client
  • Supplier as Partner of a Condition Contract
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == LFA1.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRSUPPLIER == LFA1.LIFNR
Condition Contract Type
  • Client
  • Condition Contract Type
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel in a Condition Contract
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TVTW.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRDISTRCHNL == TVTW.VTWEG
Division
  • Client
  • Division in a Condition Contract
  • Division
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TSPA.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRDIVN == TSPA.SPART
  • R_SETLDSETTLMTDOCITMANLYTS.DIVISION == TSPA.SPART
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • R_SETLDSETTLMTDOCITMANLYTS.INVOICINGPARTY == LFA1.LIFNR
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == LFA1.MANDT
Payee
  • Client
  • Payee
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == LFA1.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.PAYEEPARTY == LFA1.LIFNR
Payer
  • Client
  • Payer
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == KNA1.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.PAYERPARTY == KNA1.KUNNR
Purchasing Group
  • Client
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T024.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRPURGGROUP == T024.EKGRP
  • R_SETLDSETTLMTDOCITMANLYTS.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • Purchasing Organization in a Condition Contract
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T024E.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.PURCHASINGORGANIZATION == T024E.EKORG
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRPURGORG == T024E.EKORG
Sales Organization
  • Client
  • Sales Organization
  • Sales Organization in a Condition Contract
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TVKO.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SALESORGANIZATION == TVKO.VKORG
  • R_SETLDSETTLMTDOCITMANLYTS.CNDNCONTRSLSORG == TVKO.VKORG
Points Unit
  • Client
  • Points Unit
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T006.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLEDBUSVOLPOINTSQTYUNIT == T006.MSEHI
Unit of measure
  • Client
  • Unit of measure
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T006.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLEDBUSVOLQTYUNIT == T006.MSEHI
Volume unit
  • Client
  • Volume unit
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T006.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLEDBUSVOLVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T006.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLEDBUSVOLWEIGHTUNIT == T006.MSEHI
Supplier Company Code
  • Client
  • Supplier Company Code
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == T001.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLMTCOMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TKA01.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLMTCONTROLLINGAREA == TKA01.KOKRS
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TCURC.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLMTDOCCURRENCY == TCURC.WAERS
Settlement Document Type
  • Client
  • Settlement Document Type
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TMFK.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLMTDOCTYPE == TMFK.LFART
Settlement Process Type
  • Client
  • Settlement Process Type
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == TMZR.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLMTPROCESSTYPE == TMZR.WRART
Settlement Product
  • Client
  • Product Number
  • Settlement Product
  • R_SETLDSETTLMTDOCITMANLYTS.MANDT == MARA.MANDT
  • R_SETLDSETTLMTDOCITMANLYTS.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • R_SETLDSETTLMTDOCITMANLYTS.SETTLMTPRODUCT == MARA.MATNR