C_DetStmntPurgRbteQry

Purchasing Rebate Detailed Statement | view: CCOCOPURGRBTEQ | Extraction: Not supported | Component: Settlement Management
Column Name Description
ConditionContract FK Condition Contract
SettlmtDoc FK Settlement Document Number
SettlmtDocItem FK Settlement Document Item
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
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
Column Name Description
SettlmtDate Rebates: Settlement Date
PostingDate Posting Date
Column Name Description
CndnContrSettlmtType Condition Contract Settlement Type Show values
PostingPartnerCat Posting Partner Show values
SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
Column Name Description Domain name
InvoicingParty Different Invoicing Party LIFNR
SettlmtCompanyCode Company Code in a Settlement BUKRS
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
SettlmtDocType Settlement Document Type WFART
SettlmtProcessType Settlement Process Type WRART
SettlmtProduct Settlement Product MATNR
SettlmtDocItemText Short Text for Settlement Document Item TEXT40
SettlmtProfitCenter Profit Center in a Settlement PRCTR
BusVolDocItmText Short Text for Business Volume Document Item TEXT40
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
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_DETSTMNTPURGRBTEQRY.BASEUNIT == T006.MSEHI
  • C_DETSTMNTPURGRBTEQRY.MANDT == T006.MANDT
Currency in a Business Volume Document
  • Client
  • Currency in a Business Volume Document
  • C_DETSTMNTPURGRBTEQRY.MANDT == TCURC.MANDT
  • C_DETSTMNTPURGRBTEQRY.BUSVOLDOCCURRENCY == TCURC.WAERS
Plant in a Business Volume Document Item
  • Plant in a Business Volume Document Item
  • Client
  • C_DETSTMNTPURGRBTEQRY.BUSVOLDOCITMPLANT == T001W.WERKS
  • C_DETSTMNTPURGRBTEQRY.MANDT == T001W.MANDT
Product in Business Volume Document Item
  • Product in Business Volume Document Item
  • Client
  • C_DETSTMNTPURGRBTEQRY.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • C_DETSTMNTPURGRBTEQRY.MANDT == MARA.MANDT
Product Group in a Business Volume Document Item
  • Product Group in a Business Volume Document Item
  • Client
  • C_DETSTMNTPURGRBTEQRY.BUSVOLDOCITMPRODUCTGROUP == T023.MATKL
  • C_DETSTMNTPURGRBTEQRY.MANDT == T023.MANDT
Quantity Unit of Measure in a Business Volume Document Item
  • Client
  • Quantity Unit of Measure in a Business Volume Document Item
  • C_DETSTMNTPURGRBTEQRY.MANDT == T006.MANDT
  • C_DETSTMNTPURGRBTEQRY.BUSVOLDOCITMQUANTITYUNIT == T006.MSEHI
Condition Contract Category
  • Condition Contract Category
  • Client
  • C_DETSTMNTPURGRBTEQRY.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY
  • C_DETSTMNTPURGRBTEQRY.MANDT == TWCBCATEGORY.CLIENT
Distribution Channel in a Condition Contract
  • Distribution Channel in a Condition Contract
  • Client
  • C_DETSTMNTPURGRBTEQRY.CNDNCONTRDISTRCHNL == TVTW.VTWEG
  • C_DETSTMNTPURGRBTEQRY.MANDT == TVTW.MANDT
Division in a Condition Contract
  • Division in a Condition Contract
  • Client
  • C_DETSTMNTPURGRBTEQRY.CNDNCONTRDIVN == TSPA.SPART
  • C_DETSTMNTPURGRBTEQRY.MANDT == TSPA.MANDT
Condition Contract Process Variant
  • Client
  • Condition Contract Process Variant
Sales Organization in a Condition Contract
  • Sales Organization in a Condition Contract
  • Client
  • C_DETSTMNTPURGRBTEQRY.CNDNCONTRSLSORG == TVKO.VKORG
  • C_DETSTMNTPURGRBTEQRY.MANDT == TVKO.MANDT
Supplier in a Condition Contract
  • Client
  • Supplier in a Condition Contract
  • C_DETSTMNTPURGRBTEQRY.MANDT == LFA1.MANDT
  • C_DETSTMNTPURGRBTEQRY.CNDNCONTRSUPPLIER == LFA1.LIFNR
Condition Contract Type
  • Client
  • Condition Contract Type
Points Unit of Measure of a Settled Business Volume
  • Client
  • Points Unit of Measure of a Settled Business Volume
  • C_DETSTMNTPURGRBTEQRY.MANDT == T006.MANDT
  • C_DETSTMNTPURGRBTEQRY.SETTLEDBUSVOLPOINTSQTYUNIT == T006.MSEHI
Unit of Measure of the Settled Business Volume Quantity
  • Unit of Measure of the Settled Business Volume Quantity
  • Client
  • C_DETSTMNTPURGRBTEQRY.SETTLEDBUSVOLQTYUNIT == T006.MSEHI
  • C_DETSTMNTPURGRBTEQRY.MANDT == T006.MANDT
Volume Unit of Measure of a Settled Business Volume
  • Volume Unit of Measure of a Settled Business Volume
  • Client
  • C_DETSTMNTPURGRBTEQRY.SETTLEDBUSVOLVOLUMEUNIT == T006.MSEHI
  • C_DETSTMNTPURGRBTEQRY.MANDT == T006.MANDT
Weight Unit of Measure of a Settled Business Volume
  • Weight Unit of Measure of a Settled Business Volume
  • Client
  • C_DETSTMNTPURGRBTEQRY.SETTLEDBUSVOLWEIGHTUNIT == T006.MSEHI
  • C_DETSTMNTPURGRBTEQRY.MANDT == T006.MANDT