P_CndnContrSettlmtAnlyts

Condition Contract Settlment Analytics | view: PCNCNCTSTLANLYTS | Extraction: Not supported | Component: Settlement Management
Tables used: VBAP, VBRK, VBRP, 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 Document Number
SettlmtDocItem FK 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
BusVolDocCat Document Type of Business Volume Source Document 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
SettledSuplrInvcUUID GUID: MM Supplier Invoice in S-Innovations MRM_SI_GUID
BusVolDocItmToBsQtyNmrtr Numerator Converting Qty in Settlement Document to Base Unit UMBSZ
BusVolDocItmToBsQtyDnmntr Denominator Converting Qty in Settlement Doc. to Base Unit UMBSN
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
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.BASEUNIT == T006.MSEHI
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T006.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.BILLTOPARTY == KNA1.KUNNR
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == KNA1.MANDT
Currency in a Business Volume Document
  • Currency in a Business Volume Document
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.BUSVOLDOCCURRENCY == TCURC.WAERS
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TCURC.MANDT
Plant in a Business Volume Document Item
  • Client
  • Plant in a Business Volume Document Item
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T001W.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.BUSVOLDOCITMPLANT == T001W.WERKS
Product in Business Volume Document Item
  • Product in Business Volume Document Item
  • Settlement Product
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • P_CNDNCONTRSETTLMTANLYTS.SETTLMTPRODUCT == MARA.MATNR
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == MARA.MANDT
Product Group in a Business Volume Document Item
  • Product Group in a Business Volume Document Item
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.BUSVOLDOCITMPRODUCTGROUP == T023.MATKL
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T023.MANDT
Quantity Unit of Measure in a Business Volume Document Item
  • Quantity Unit of Measure in a Business Volume Document Item
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.BUSVOLDOCITMQUANTITYUNIT == T006.MSEHI
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T006.MANDT
Condition Contract Category
  • Condition Contract Category
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TWCBCATEGORY.CLIENT
Customer in a Condition Contract
  • Client
  • Customer in a Condition Contract
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == KNA1.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRCUSTOMER == KNA1.KUNNR
Distribution Channel in a Condition Contract
  • Client
  • Distribution Channel in a Condition Contract
  • Distribution Channel
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TVTW.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRDISTRCHNL == TVTW.VTWEG
  • P_CNDNCONTRSETTLMTANLYTS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division in a Condition Contract
  • Client
  • Division in a Condition Contract
  • Division
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TSPA.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRDIVN == TSPA.SPART
  • P_CNDNCONTRSETTLMTANLYTS.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
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T024.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRPURGGROUP == T024.EKGRP
  • P_CNDNCONTRSETTLMTANLYTS.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization in a Condition Contract
  • Client
  • Purchasing Organization in a Condition Contract
  • Purchasing organization
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T024E.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRPURGORG == T024E.EKORG
  • P_CNDNCONTRSETTLMTANLYTS.PURCHASINGORGANIZATION == T024E.EKORG
Sales Organization in a Condition Contract
  • Client
  • Sales Organization
  • Sales Organization in a Condition Contract
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TVKO.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.SALESORGANIZATION == TVKO.VKORG
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRSLSORG == TVKO.VKORG
Supplier in a Condition Contract
  • Supplier in a Condition Contract
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRSUPPLIER == LFA1.LIFNR
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == LFA1.MANDT
Condition Contract Type
  • Condition Contract Type
  • Client
Distribution Channel
  • Client
  • Distribution Channel in a Condition Contract
  • Distribution Channel
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TVTW.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRDISTRCHNL == TVTW.VTWEG
  • P_CNDNCONTRSETTLMTANLYTS.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division in a Condition Contract
  • Division
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TSPA.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRDIVN == TSPA.SPART
  • P_CNDNCONTRSETTLMTANLYTS.DIVISION == TSPA.SPART
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.INVOICINGPARTY == LFA1.LIFNR
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == LFA1.MANDT
Purchasing Group
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRPURGGROUP == T024.EKGRP
  • P_CNDNCONTRSETTLMTANLYTS.PURCHASINGGROUP == T024.EKGRP
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing Organization in a Condition Contract
  • Purchasing organization
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRPURGORG == T024E.EKORG
  • P_CNDNCONTRSETTLMTANLYTS.PURCHASINGORGANIZATION == T024E.EKORG
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization
  • Sales Organization in a Condition Contract
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.SALESORGANIZATION == TVKO.VKORG
  • P_CNDNCONTRSETTLMTANLYTS.CNDNCONTRSLSORG == TVKO.VKORG
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TVKO.MANDT
Points Unit of Measure of a Settled Business Volume
  • Points Unit of Measure of a Settled Business Volume
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.SETTLEDBUSVOLPOINTSQTYUNIT == T006.MSEHI
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T006.MANDT
Unit of Measure of the Settled Business Volume Quantity
  • Unit of Measure of the Settled Business Volume Quantity
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.SETTLEDBUSVOLQTYUNIT == T006.MSEHI
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T006.MANDT
Volume Unit of Measure of a Settled Business Volume
  • Client
  • Volume Unit of Measure of a Settled Business Volume
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T006.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.SETTLEDBUSVOLVOLUMEUNIT == T006.MSEHI
Weight Unit of Measure of a Settled Business Volume
  • Weight Unit of Measure of a Settled Business Volume
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.SETTLEDBUSVOLWEIGHTUNIT == T006.MSEHI
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T006.MANDT
Company Code in a Settlement
  • Company Code in a Settlement
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.SETTLMTCOMPANYCODE == T001.BUKRS
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == T001.MANDT
Controlling Area in a Settlement
  • Controlling Area in a Settlement
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.SETTLMTCONTROLLINGAREA == TKA01.KOKRS
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TKA01.MANDT
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TCURC.MANDT
  • P_CNDNCONTRSETTLMTANLYTS.SETTLMTDOCCURRENCY == TCURC.WAERS
Settlement Document Type
  • Settlement Document Type
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.SETTLMTDOCTYPE == TMFK.LFART
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TMFK.MANDT
Settlement Process Type
  • Settlement Process Type
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.SETTLMTPROCESSTYPE == TMZR.WRART
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == TMZR.MANDT
Settlement Product
  • Product in Business Volume Document Item
  • Settlement Product
  • Client
  • P_CNDNCONTRSETTLMTANLYTS.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • P_CNDNCONTRSETTLMTANLYTS.SETTLMTPRODUCT == MARA.MATNR
  • P_CNDNCONTRSETTLMTANLYTS.MANDT == MARA.MANDT