I_CustomerReturnRateAnalytics

Customer Return Rate Analytics | view: ISDCUSTRETRATEA | Extraction: Not supported | Component: Sales Analytics
Tables used: 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
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of Sales Order Item in Transaction Currency
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):
RequestedQuantityInBaseUnit Requested Order Quantity in Base Unit
IncomingSalesOrdersQuantity Incoming Sales Orders Quantity
IncomingCustReturnsQuantity Customer Return Item Quantity
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesDocumentDate Document Date (Date Received/Sent)
ReferenceSDDocumentDate Date of preceding document
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesDocumentItemType Item Type Show values
IsReturnsItem Returns Item Show values
ItemIsBillingRelevant Relevant for Billing Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
RetsMgmtProcessingBlock Approval Block Show values
Column Name Description Domain name
CustomerReturn Customer Return VBELN
CustomerReturnItem Customer Return Item POSNR
SalesDocumentType Sales Document Type AUART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
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
PayerParty Payer KUNNR
BillToParty Bill-to Party 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
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ProfitCenter Profit Center PRCTR
CostCenter Cost Center KOSTL
NumberOfIncomingCustRetItems Number of Items in Customer Returns INT4
Master Data Relations Join Conditions
Material Group 1
  • Material Group 1
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TVM2.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TVM3.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TVM4.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TVM5.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Base Unit of Reference Document Item
  • Base Unit of Measure
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.REFERENCESLSDOCITMBASEUNIT == T006.MSEHI
  • I_CUSTOMERRETURNRATEANALYTICS.BASEUNIT == T006.MSEHI
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == T006.MANDT
Batch Number
  • Plant (Own or External)
  • Client
  • Batch Number
  • Product Number
  • I_CUSTOMERRETURNRATEANALYTICS.PLANT == MCHA.WERKS
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == MCHA.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.BATCH == MCHA.CHARG
  • I_CUSTOMERRETURNRATEANALYTICS.PRODUCT == MCHA.MATNR
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.BILLINGCOMPANYCODE == T001.BUKRS
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.BUSINESSAREA == TGSB.GSBER
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TGSB.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TKA01.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.CONTROLLINGAREA == TKA01.KOKRS
Customer Group
  • Customer Group
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.CUSTOMERGROUP == T151.KDGRP
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == T151.MANDT
Division
  • Client
  • Division
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TSPA.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.DIVISION == TSPA.SPART
Reason for material substitution
  • Client
  • Reason for material substitution
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TVSU.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
Material Entered
  • Client
  • Material Entered
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == MARA.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Material: order item
  • Client
  • Product Number
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == MARA.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.PRODUCT == MARA.MATNR
Product Catalog
  • Client
  • Product catalog number
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == WWMI.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.PRODUCTCATALOG == WWMI.WMINR
Product Group
  • Client
  • Product Group
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == T023.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.PRODUCTGROUP == T023.MATKL
Product hierarchy: order item
  • Product hierarchy
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.PRODUCTHIERARCHYNODE == T179.PRODH
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == T179.MANDT
Base Unit of Reference Document Item
  • Base Unit of Reference Document Item
  • Base Unit of Measure
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.REFERENCESLSDOCITMBASEUNIT == T006.MSEHI
  • I_CUSTOMERRETURNRATEANALYTICS.BASEUNIT == T006.MSEHI
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == T006.MANDT
Currency Used in Reference Document Item
  • Client
  • SD Document Currency
  • Currency Used in Reference Document Item
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TCURC.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CUSTOMERRETURNRATEANALYTICS.REFERENCESLSDOCITMTRANSCRCY == TCURC.WAERS
Return Reason
  • Client
  • Return Reason
Sales District
  • Client
  • Sales District
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == T171.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Client
  • Sales document item category
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TVPT.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TVAG.MANDT
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • I_CUSTOMERRETURNRATEANALYTICS.STORAGELOCATION == T001L.LGORT
  • I_CUSTOMERRETURNRATEANALYTICS.PLANT == T001L.WERKS
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == T001L.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • Currency Used in Reference Document Item
  • I_CUSTOMERRETURNRATEANALYTICS.MANDT == TCURC.MANDT
  • I_CUSTOMERRETURNRATEANALYTICS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CUSTOMERRETURNRATEANALYTICS.REFERENCESLSDOCITMTRANSCRCY == TCURC.WAERS