I_CndnContrSettlmtAnlytsCube

Analytics – Settled Business Volume in Cndn Contr Settlmt | view: ICOCOSMTCUBE | TRAN | Extraction: Not supported | Component: Settlement Management
Tables used: VBAP, VBRK, VBRP, SCAL_TT_DATE, MATDOC, EKKO, EKPO, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, WBRK, WBRK, WBRP, WCOCOH, WBRK, WBRP, WBRK, WBRP, RBDRSEG, RSEG, WB2_D_BVDETAIL, WB2_D_BVDETAIL, WB2_D_BVDETAIL, WB2_D_BVDETAIL, WB2_D_BVDETAIL, WB2_D_BVDETAIL, WB2_D_BVDETAIL, WB2_D_BVDETAIL, RBKP, WB2_D_BVDETAIL, WB2_D_BVDETAIL, TWCBCONTRTYPE
Column Name Description
ConditionContract FK Condition Contract
SettlmtDoc FK Settlement Document Number
SettlmtDocItem FK Settlement Document Item
SettledSuplrBillgDoc Supplier Billing Document Settled as a Business Volume Doc.
SettledSuplrBillgDocItem Item of a Supplier Billing Doc Settled as Business Vol Doc
SettledSettlmtDoc Settlement Document Settled as a Business Volume Document
SettledSettlmtDocItem Item of a Settled Settlement Document
SettledCustSettlmt Customer Settlement Settled as Business Volume Document
SettledCustSettlmtItem Item of a Settled Customer Settlement
SettledExpnSettlmt Expense Settlement Settled as Business Volume Document
SettledExpnSettlmtItem Item of a Settled Expense Settlement
SettledSuplrSettlmt Supplier Settlement Settled as a Business Volume Document
SettledSuplrSettlmtItem Item of a Settled Supplier Document
SettledBillgDoc Billing Document Settled as Business Volume Document
SettledBillgDocItem Item of a Settled Billing Document
SettledMaterialDocument Material Document Settled as Business Volume Document
SettledMaterialDocumentYear Year of a Settled Material Document
SettledMaterialDocumentItem Item of a Settled Material Document
SettledSuplrInvc Settled Supplier Invoice
SettledSuplrInvcFiscalYear Fiscal Year of a Supplier Invoice
SettledSuplrInvcItem Item of a Settled Supplier Invoice
SettledPurchaseOrder Purchase Order Settled as a Business Volume Document
SettledPurchaseOrderItem Item of a Settled Purchase Order
SettledSalesOrder Sales Order Settled as a Business Volume Document
SettledSalesOrderItem Sales Order Item Settled as a Business Volume Document
Column Name Description
💲 Currency in a Business Volume Document (BusVolDocCurrency):
SettledBusVolAmount1 Amount 1 of a Settled Business Volume
SettledBusVolAmount2 Amount 2 of a Settled Business Volume
SettledBusVolAmount3 Amount 3 of a Settled Business Volume
SettledBusVolAmount4 Amount 4 of a Settled Business Volume
BusVolDocItmNetAmount Net Amount in a Business Volume Document Item
💲 Display Currency (DisplayCurrency):
SettledBusVolAmount1InDC Amount 1 of a Settled Business Volume in Display Currency
SettledBusVolAmount2InDC Amount 2 of a Settled Business Volume in Display Currency
SettledBusVolAmount3InDC Amount 3 of a Settled Business Volume in Display Currency
SettledBusVolAmount4InDC Amount 4 of a Settled Business Volume in Display Currency
BusVolDocItmNetAmountInDC Net Amount in a Business Volume Doc Item in Display Currency
Column Name Description
📏 Unit of Measure of the Settled Business Volume Quantity (SettledBusVolQtyUnit):
SettledBusVolQty Quantity of the Settled Business Volume
📏 Weight Unit of Measure of a Settled Business Volume (SettledBusVolWeightUnit):
SettledBusVolGrossWeight Gross Weight of a Settled Business Volume
SettledBusVolNetWeight Net Weight of a Settled Business Volume
📏 Volume Unit of Measure of a Settled Business Volume (SettledBusVolVolumeUnit):
SettledBusVolVolume Volume of a Settled Business Volume
📏 Points Unit of Measure of a Settled Business Volume (SettledBusVolPointsQtyUnit):
SettledBusVolPointsQty Points Quantity of a Settled Business Volume
📏 Quantity Unit of Measure in a Business Volume Document Item (BusVolDocItmQuantityUnit):
BusVolDocItmQuantity Quantity in a Business Volume Document Item
📏 Base Unit of Measure (BaseUnit):
BusVolDocItmQtyInBsUnt Quantity in a Business Volume Document Item in Base Unit
CalcdBusVolDocItmQtyInBsUnt Calculated Bus Vol Doc Item Quantity in Base Unit
Column Name Description
BusVolSelDteForSettlmt Date for the Selection of the Business Volume to Be Settled
DocumentDate Document Date in Settlement Management Document
PostingDate Posting Date
SettlmtDate Rebates: Settlement Date
SettlmtCreationDate Creation Date of a Settlement
BusVolDocExchangeRateDate Date for Currency Conversion in a Business Volume Document
Column Name Description
CndnContrSettlmtType Condition Contract Settlement Type Show values
SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
PostingPartnerCat Posting Partner Show values
BusVolDocCat Document Type of Business Volume Source Document Show values
CndnContrProcessCategory Process Category of a Condition Contract Show values
Column Name Description Domain name
BusVolSelDteYrMnthForSettlmt Year and Month of the Date NUM6
BusVolSelDteYrQtrForSettlmt Year and Quarter of the Date NUM5
BusVolSelDteYrWkForSettlmt Year and Week of the Date NUM6
BusVolSelDteYrForSettlmt Year of the Date for the Business Volume to Be Settled NUM4
SettlmtDocItemText Short Text for Settlement Document Item TEXT40
SettlmtCostCenter Cost Center in a Settlement KOSTL
SettlmtProfitCenter Profit Center in a Settlement PRCTR
BusVolDocItmText Short Text for Business Volume Document Item TEXT40
BusVolDocItmToBsQtyDnmntr Denominator Converting Qty in Settlement Doc. to Base Unit UMBSN
BusVolDocItmToBsQtyNmrtr Numerator Converting Qty in Settlement Document to Base Unit UMBSZ
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T006.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.BASEUNIT == T006.MSEHI
Bill-to Party
  • Bill-to Party
  • Client
  • I_CNDNCONTRSETTLMTANLYTSCUBE.BILLTOPARTY == KNA1.KUNNR
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == KNA1.MANDT
Currency in a Business Volume Document
  • Client
  • Currency in a Business Volume Document
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TCURC.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.BUSVOLDOCCURRENCY == TCURC.WAERS
Plant in a Business Volume Document Item
  • Client
  • Plant in a Business Volume Document Item
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T001W.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.BUSVOLDOCITMPLANT == T001W.WERKS
Product in Business Volume Document Item
  • Client
  • Product in Business Volume Document Item
  • Settlement Product
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == MARA.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLMTPRODUCT == MARA.MATNR
Product Group in a Business Volume Document Item
  • Client
  • Product Group in a Business Volume Document Item
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T023.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.BUSVOLDOCITMPRODUCTGROUP == T023.MATKL
Quantity Unit of Measure in a Business Volume Document Item
  • Client
  • Quantity Unit of Measure in a Business Volume Document Item
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T006.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.BUSVOLDOCITMQUANTITYUNIT == T006.MSEHI
Condition Contract Category
  • Client
  • Condition Contract Category
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TWCBCATEGORY.CLIENT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY
Customer in a Condition Contract
  • Client
  • Customer in a Condition Contract
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == KNA1.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRCUSTOMER == KNA1.KUNNR
Distribution Channel in a Condition Contract
  • Client
  • Distribution Channel
  • Distribution Channel in a Condition Contract
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TVTW.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRDISTRCHNL == TVTW.VTWEG
Division in a Condition Contract
  • Client
  • Division in a Condition Contract
  • Division
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TSPA.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRDIVN == TSPA.SPART
  • I_CNDNCONTRSETTLMTANLYTSCUBE.DIVISION == TSPA.SPART
Condition Contract Process Variant
  • Client
  • Condition Contract Process Variant
Purchasing Group in a Condition Contract
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • Client
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRPURGGROUP == T024.EKGRP
  • I_CNDNCONTRSETTLMTANLYTSCUBE.PURCHASINGGROUP == T024.EKGRP
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T024.MANDT
Purchasing Organization in a Condition Contract
  • Client
  • Purchasing organization
  • Purchasing Organization in a Condition Contract
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T024E.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRPURGORG == T024E.EKORG
Sales Organization in a Condition Contract
  • Client
  • Sales Organization in a Condition Contract
  • Sales Organization
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TVKO.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRSLSORG == TVKO.VKORG
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SALESORGANIZATION == TVKO.VKORG
Supplier in a Condition Contract
  • Supplier in a Condition Contract
  • Client
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRSUPPLIER == LFA1.LIFNR
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == LFA1.MANDT
Condition Contract Type
  • Client
  • Condition Contract Type
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TWCBCONTRTYPE.CLIENT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRTYPE == TWCBCONTRTYPE.CONTRACT_TYPE
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel in a Condition Contract
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TVTW.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRDISTRCHNL == TVTW.VTWEG
Division
  • Client
  • Division in a Condition Contract
  • Division
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TSPA.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRDIVN == TSPA.SPART
  • I_CNDNCONTRSETTLMTANLYTSCUBE.DIVISION == TSPA.SPART
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == LFA1.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.INVOICINGPARTY == LFA1.LIFNR
Purchasing Group
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • Client
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRPURGGROUP == T024.EKGRP
  • I_CNDNCONTRSETTLMTANLYTSCUBE.PURCHASINGGROUP == T024.EKGRP
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • Purchasing Organization in a Condition Contract
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T024E.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRPURGORG == T024E.EKORG
Sales Organization
  • Client
  • Sales Organization in a Condition Contract
  • Sales Organization
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TVKO.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.CNDNCONTRSLSORG == TVKO.VKORG
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SALESORGANIZATION == TVKO.VKORG
Points Unit of Measure of a Settled Business Volume
  • Client
  • Points Unit of Measure of a Settled Business Volume
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T006.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLEDBUSVOLPOINTSQTYUNIT == T006.MSEHI
Unit of Measure of the Settled Business Volume Quantity
  • Client
  • Unit of Measure of the Settled Business Volume Quantity
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T006.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLEDBUSVOLQTYUNIT == T006.MSEHI
Volume Unit of Measure of a Settled Business Volume
  • Client
  • Volume Unit of Measure of a Settled Business Volume
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T006.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLEDBUSVOLVOLUMEUNIT == T006.MSEHI
Weight Unit of Measure of a Settled Business Volume
  • Client
  • Weight Unit of Measure of a Settled Business Volume
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T006.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLEDBUSVOLWEIGHTUNIT == T006.MSEHI
Company Code in a Settlement
  • Client
  • Company Code in a Settlement
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == T001.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLMTCOMPANYCODE == T001.BUKRS
Controlling Area in a Settlement
  • Controlling Area in a Settlement
  • Client
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLMTCONTROLLINGAREA == TKA01.KOKRS
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TKA01.MANDT
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TCURC.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLMTDOCCURRENCY == TCURC.WAERS
Settlement Document Type
  • Settlement Document Type
  • Client
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLMTDOCTYPE == TMFK.LFART
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TMFK.MANDT
Settlement Process Type
  • Client
  • Settlement Process Type
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == TMZR.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLMTPROCESSTYPE == TMZR.WRART
Settlement Product
  • Client
  • Product in Business Volume Document Item
  • Settlement Product
  • I_CNDNCONTRSETTLMTANLYTSCUBE.MANDT == MARA.MANDT
  • I_CNDNCONTRSETTLMTANLYTSCUBE.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • I_CNDNCONTRSETTLMTANLYTSCUBE.SETTLMTPRODUCT == MARA.MATNR