C_DetStmntRoytyQry

Royalties Detailed Statement | view: CCOCOROYTYQ | 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
SettledSuplrInvc Settled Supplier Invoice
SettledSuplrInvcFiscalYear Fiscal Year of a Supplier Invoice
SettledSuplrInvcItem Item of a Settled Supplier Invoice
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
SettledBusVolAmount4InDC Amount 4 of a Settled Business Volume in Display Currency
💲 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
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
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
BillToParty Bill-to Party KUNNR
SettlmtCompanyCode Company Code in a Settlement BUKRS
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
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
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
  • Base Unit of Measure
  • Client
  • C_DETSTMNTROYTYQRY.BASEUNIT == T006.MSEHI
  • C_DETSTMNTROYTYQRY.MANDT == T006.MANDT
Currency in a Business Volume Document
  • Client
  • Currency in a Business Volume Document
  • C_DETSTMNTROYTYQRY.MANDT == TCURC.MANDT
  • C_DETSTMNTROYTYQRY.BUSVOLDOCCURRENCY == TCURC.WAERS
Plant in a Business Volume Document Item
  • Plant in a Business Volume Document Item
  • Client
  • C_DETSTMNTROYTYQRY.BUSVOLDOCITMPLANT == T001W.WERKS
  • C_DETSTMNTROYTYQRY.MANDT == T001W.MANDT
Product in Business Volume Document Item
  • Product in Business Volume Document Item
  • Client
  • C_DETSTMNTROYTYQRY.BUSVOLDOCITMPRODUCT == MARA.MATNR
  • C_DETSTMNTROYTYQRY.MANDT == MARA.MANDT
Product Group in a Business Volume Document Item
  • Product Group in a Business Volume Document Item
  • Client
  • C_DETSTMNTROYTYQRY.BUSVOLDOCITMPRODUCTGROUP == T023.MATKL
  • C_DETSTMNTROYTYQRY.MANDT == T023.MANDT
Quantity Unit of Measure in a Business Volume Document Item
  • Quantity Unit of Measure in a Business Volume Document Item
  • Client
  • C_DETSTMNTROYTYQRY.BUSVOLDOCITMQUANTITYUNIT == T006.MSEHI
  • C_DETSTMNTROYTYQRY.MANDT == T006.MANDT
Condition Contract Category
  • Condition Contract Category
  • Client
Condition Contract Process Variant
  • Client
  • Condition Contract Process Variant
Purchasing Group in a Condition Contract
  • Client
  • Purchasing Group in a Condition Contract
  • C_DETSTMNTROYTYQRY.MANDT == T024.MANDT
  • C_DETSTMNTROYTYQRY.CNDNCONTRPURGGROUP == T024.EKGRP
Purchasing Organization in a Condition Contract
  • Purchasing Organization in a Condition Contract
  • Client
  • C_DETSTMNTROYTYQRY.CNDNCONTRPURGORG == T024E.EKORG
  • C_DETSTMNTROYTYQRY.MANDT == T024E.MANDT
Supplier in a Condition Contract
  • Supplier in a Condition Contract
  • Client
  • C_DETSTMNTROYTYQRY.CNDNCONTRSUPPLIER == LFA1.LIFNR
  • C_DETSTMNTROYTYQRY.MANDT == LFA1.MANDT
Condition Contract Type
  • Client
  • Condition Contract Type
Points Unit of Measure of a Settled Business Volume
  • Points Unit of Measure of a Settled Business Volume
  • Client
  • C_DETSTMNTROYTYQRY.SETTLEDBUSVOLPOINTSQTYUNIT == T006.MSEHI
  • C_DETSTMNTROYTYQRY.MANDT == T006.MANDT
Unit of Measure of the Settled Business Volume Quantity
  • Unit of Measure of the Settled Business Volume Quantity
  • Client
  • C_DETSTMNTROYTYQRY.SETTLEDBUSVOLQTYUNIT == T006.MSEHI
  • C_DETSTMNTROYTYQRY.MANDT == T006.MANDT
Volume Unit of Measure of a Settled Business Volume
  • Client
  • Volume Unit of Measure of a Settled Business Volume
  • C_DETSTMNTROYTYQRY.MANDT == T006.MANDT
  • C_DETSTMNTROYTYQRY.SETTLEDBUSVOLVOLUMEUNIT == T006.MSEHI
Weight Unit of Measure of a Settled Business Volume
  • Weight Unit of Measure of a Settled Business Volume
  • Client
  • C_DETSTMNTROYTYQRY.SETTLEDBUSVOLWEIGHTUNIT == T006.MSEHI
  • C_DETSTMNTROYTYQRY.MANDT == T006.MANDT