I_CustomerReturnRateCube

Customer Return Rate - Cube | view: ISDCUSTRETRATEC | TRAN | 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
💲 Currency Used in Reference Document Item (ReferenceSlsDocItmTransCrcy):
ReferenceSlsDocItmNetAmount Net Value of Reference Items in Transaction Currency
💲 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
💲 SD Document Currency (TransactionCurrency):
IncomingSalesOrdersNetAmount Incoming Sales Orders Net Value in Transaction Currency
IncomingCustReturnsNetAmount Net Amount of Customer Return Items
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
NumberOfIncomingCustRetItems Number of Items in Customer Returns INT4
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_CUSTOMERRETURNRATECUBE.MANDT == TVM1.MANDT
  • I_CUSTOMERRETURNRATECUBE.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_CUSTOMERRETURNRATECUBE.MANDT == TVM2.MANDT
  • I_CUSTOMERRETURNRATECUBE.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • I_CUSTOMERRETURNRATECUBE.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • I_CUSTOMERRETURNRATECUBE.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • I_CUSTOMERRETURNRATECUBE.MANDT == TVM4.MANDT
  • I_CUSTOMERRETURNRATECUBE.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_CUSTOMERRETURNRATECUBE.MANDT == TVM5.MANDT
  • I_CUSTOMERRETURNRATECUBE.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Reference Document Item
  • I_CUSTOMERRETURNRATECUBE.MANDT == T006.MANDT
  • I_CUSTOMERRETURNRATECUBE.BASEUNIT == T006.MSEHI
  • I_CUSTOMERRETURNRATECUBE.REFERENCESLSDOCITMBASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_CUSTOMERRETURNRATECUBE.MANDT == T001.MANDT
  • I_CUSTOMERRETURNRATECUBE.BILLINGCOMPANYCODE == T001.BUKRS
Business Area
  • Business Area
  • Client
  • I_CUSTOMERRETURNRATECUBE.BUSINESSAREA == TGSB.GSBER
  • I_CUSTOMERRETURNRATECUBE.MANDT == TGSB.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_CUSTOMERRETURNRATECUBE.MANDT == TKA01.MANDT
  • I_CUSTOMERRETURNRATECUBE.CONTROLLINGAREA == TKA01.KOKRS
Customer Group
  • Customer Group
  • Client
  • I_CUSTOMERRETURNRATECUBE.CUSTOMERGROUP == T151.KDGRP
  • I_CUSTOMERRETURNRATECUBE.MANDT == T151.MANDT
Division
  • Client
  • Division
  • I_CUSTOMERRETURNRATECUBE.MANDT == TSPA.MANDT
  • I_CUSTOMERRETURNRATECUBE.DIVISION == TSPA.SPART
Material: order item
  • Client
  • Product Number
  • I_CUSTOMERRETURNRATECUBE.MANDT == MARA.MANDT
  • I_CUSTOMERRETURNRATECUBE.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Group
  • I_CUSTOMERRETURNRATECUBE.MANDT == T023.MANDT
  • I_CUSTOMERRETURNRATECUBE.PRODUCTGROUP == T023.MATKL
Product hierarchy: order item
  • Client
  • Product hierarchy
  • I_CUSTOMERRETURNRATECUBE.MANDT == T179.MANDT
  • I_CUSTOMERRETURNRATECUBE.PRODUCTHIERARCHYNODE == T179.PRODH
Base Unit of Reference Document Item
  • Client
  • Base Unit of Measure
  • Base Unit of Reference Document Item
  • I_CUSTOMERRETURNRATECUBE.MANDT == T006.MANDT
  • I_CUSTOMERRETURNRATECUBE.BASEUNIT == T006.MSEHI
  • I_CUSTOMERRETURNRATECUBE.REFERENCESLSDOCITMBASEUNIT == T006.MSEHI
Currency Used in Reference Document Item
  • Client
  • Currency Used in Reference Document Item
  • SD Document Currency
  • I_CUSTOMERRETURNRATECUBE.MANDT == TCURC.MANDT
  • I_CUSTOMERRETURNRATECUBE.REFERENCESLSDOCITMTRANSCRCY == TCURC.WAERS
  • I_CUSTOMERRETURNRATECUBE.TRANSACTIONCURRENCY == TCURC.WAERS
Return Reason
  • Client
  • Return Reason
Sales District
  • Client
  • Sales District
  • I_CUSTOMERRETURNRATECUBE.MANDT == T171.MANDT
  • I_CUSTOMERRETURNRATECUBE.SALESDISTRICT == T171.BZIRK
SD Document Currency
  • Client
  • Currency Used in Reference Document Item
  • SD Document Currency
  • I_CUSTOMERRETURNRATECUBE.MANDT == TCURC.MANDT
  • I_CUSTOMERRETURNRATECUBE.REFERENCESLSDOCITMTRANSCRCY == TCURC.WAERS
  • I_CUSTOMERRETURNRATECUBE.TRANSACTIONCURRENCY == TCURC.WAERS