C_CustomerReturnRateQry

Customer Return Rate - Query | view: CSDCUSTRETRATEQ | Extraction: Not supported | Component: Sales Analytics
Tables used: SCAL_TT_DATE, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 Display Currency (DisplayCurrency):
ReferenceSlsDocItmNetAmtInDC Net Value of Reference Items in Display Currency
IncomingSalesOrdersNetAmtInDC Incoming Sales Orders Net Value In Display Currency
IncomingCustReturnsNetAmtInDC Net Amount of Customer Return Items in Display Currency
Column Name Description
📏 Base Unit of Reference Document Item (ReferenceSlsDocItmBaseUnit):
ReferenceSlsDocItmQuantity Quantity of Reference Items
📏 Base Unit of Measure (BaseUnit):
IncomingSalesOrdersQuantity Incoming Sales Orders Quantity
IncomingCustReturnsQuantity Customer Return Item Quantity
Column Name Description
CreationDate Date on which the record was created
Column Name Description
SDDocumentCategory SD Document Category Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
CustomerReturn Customer Return VBELN
CustomerReturnItem Customer Return Item POSNR
SalesDocumentType Sales Document Type AUART
CreationDateYearMonth Year/Month of Creation NUM6
CreationDateYearQuarter Year/Quarter of Creation NUM5
CreationDateYear Year of Creation NUM4
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SoldToParty Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
MaterialByCustomer Material Number Used by Customer IDNEX
Plant Plant (Own or External) WERKS
ProfitCenter Profit Center PRCTR
CostCenter Cost Center KOSTL
CustomerReturnAmountReturnRate Return Rate (Value-Based)
CustomerReturnQtyReturnRate Return Rate (Quantity-Based)
NumberOfIncomingCustRetItems Number of Items in Customer Returns INT4
Master Data Relations Join Conditions
Material Group 1
  • Material Group 1
  • Client
  • C_CUSTOMERRETURNRATEQRY.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • C_CUSTOMERRETURNRATEQRY.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • C_CUSTOMERRETURNRATEQRY.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • C_CUSTOMERRETURNRATEQRY.MANDT == TVM2.MANDT
Material Group 3
  • Client
  • Material Group 3
  • C_CUSTOMERRETURNRATEQRY.MANDT == TVM3.MANDT
  • C_CUSTOMERRETURNRATEQRY.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Material Group 4
  • Client
  • C_CUSTOMERRETURNRATEQRY.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • C_CUSTOMERRETURNRATEQRY.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • C_CUSTOMERRETURNRATEQRY.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • C_CUSTOMERRETURNRATEQRY.MANDT == TVM5.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Reference Document Item
  • C_CUSTOMERRETURNRATEQRY.MANDT == T006.MANDT
  • C_CUSTOMERRETURNRATEQRY.BASEUNIT == T006.MSEHI
  • C_CUSTOMERRETURNRATEQRY.REFERENCESLSDOCITMBASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_CUSTOMERRETURNRATEQRY.BILLINGCOMPANYCODE == T001.BUKRS
  • C_CUSTOMERRETURNRATEQRY.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • C_CUSTOMERRETURNRATEQRY.BUSINESSAREA == TGSB.GSBER
  • C_CUSTOMERRETURNRATEQRY.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_CUSTOMERRETURNRATEQRY.CONTROLLINGAREA == TKA01.KOKRS
  • C_CUSTOMERRETURNRATEQRY.MANDT == TKA01.MANDT
Customer Group
  • Customer Group
  • Client
  • C_CUSTOMERRETURNRATEQRY.CUSTOMERGROUP == T151.KDGRP
  • C_CUSTOMERRETURNRATEQRY.MANDT == T151.MANDT
Material: order item
  • Product Number
  • Client
  • C_CUSTOMERRETURNRATEQRY.PRODUCT == MARA.MATNR
  • C_CUSTOMERRETURNRATEQRY.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_CUSTOMERRETURNRATEQRY.PRODUCTGROUP == T023.MATKL
  • C_CUSTOMERRETURNRATEQRY.MANDT == T023.MANDT
Product hierarchy: order item
  • Product hierarchy
  • Client
  • C_CUSTOMERRETURNRATEQRY.PRODUCTHIERARCHYNODE == T179.PRODH
  • C_CUSTOMERRETURNRATEQRY.MANDT == T179.MANDT
Base Unit of Reference Document Item
  • Client
  • Base Unit of Measure
  • Base Unit of Reference Document Item
  • C_CUSTOMERRETURNRATEQRY.MANDT == T006.MANDT
  • C_CUSTOMERRETURNRATEQRY.BASEUNIT == T006.MSEHI
  • C_CUSTOMERRETURNRATEQRY.REFERENCESLSDOCITMBASEUNIT == T006.MSEHI
Return Reason
  • Return Reason
  • Client
Sales District
  • Sales District
  • Client
  • C_CUSTOMERRETURNRATEQRY.SALESDISTRICT == T171.BZIRK
  • C_CUSTOMERRETURNRATEQRY.MANDT == T171.MANDT