C_CustomerReturnItemQry

Customer Return Item - Query | view: CSDCUSTRETITMQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBEP, TVKO
Column Name Description
CustomerReturn FK Customer Return
CustomerReturnItem Customer Return Item
Column Name Description
💲 Display Currency (DisplayCurrency):
IncomingCustReturnsNetAmtInDC Net Amount of Customer Return Items in Display Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
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
CustomerPurchaseOrderDate Customer Reference Date
ExchangeRateDate Translation date
Column Name Description
CustomerReturnItemType Item Type Show values
RetsMgmtProcessingBlock Approval Block Show values
ItemIsBillingRelevant Relevant for Billing Show values
StatisticalValueControl Statistical Values Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SDProcessStatus Overall Processing Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
BillingBlockStatus Billing Block Status (Item) Show values
Column Name Description Domain name
CustomerReturnType Customer Return Type AUART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateYear Year of Creation NUM4
CreationDateYearQuarter Year/Quarter of Creation NUM5
CreationDateYearMonth Year/Month of Creation NUM6
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesGroup Sales group VKGRP
SalesOffice Sales office VKBUR
SoldToParty Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
PayerParty Payer KUNNR
BillToParty Bill-to Party KUNNR
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
CustomerReturnItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
Plant Plant (Own or External) WERKS
CustomerPaymentTerms Terms of payment key ZTERM
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
NumberOfIncomingCustRetItems Number of Items in Customer Returns INT4
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_CUSTOMERRETURNITEMQRY.BASEUNIT == T006.MSEHI
  • C_CUSTOMERRETURNITEMQRY.MANDT == T006.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_CUSTOMERRETURNITEMQRY.BILLINGCOMPANYCODE == T001.BUKRS
  • C_CUSTOMERRETURNITEMQRY.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • C_CUSTOMERRETURNITEMQRY.BUSINESSAREA == TGSB.GSBER
  • C_CUSTOMERRETURNITEMQRY.MANDT == TGSB.MANDT
Customer Group
  • Customer Group
  • Client
  • C_CUSTOMERRETURNITEMQRY.CUSTOMERGROUP == T151.KDGRP
  • C_CUSTOMERRETURNITEMQRY.MANDT == T151.MANDT
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • C_CUSTOMERRETURNITEMQRY.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • C_CUSTOMERRETURNITEMQRY.MANDT == T176.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_CUSTOMERRETURNITEMQRY.CUSTOMERRETURNITEMCATEGORY == TVPT.PSTYV
  • C_CUSTOMERRETURNITEMQRY.MANDT == TVPT.MANDT
Division
  • Division
  • Client
  • C_CUSTOMERRETURNITEMQRY.DIVISION == TSPA.SPART
  • C_CUSTOMERRETURNITEMQRY.MANDT == TSPA.MANDT
Billing Block Reason for Item
  • Billing Block Reason for Item
  • Client
  • C_CUSTOMERRETURNITEMQRY.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_CUSTOMERRETURNITEMQRY.MANDT == TVFS.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • C_CUSTOMERRETURNITEMQRY.MATERIAL == MARA.MATNR
  • C_CUSTOMERRETURNITEMQRY.PRODUCT == MARA.MATNR
  • C_CUSTOMERRETURNITEMQRY.MANDT == MARA.MANDT
Material Group
  • Product Group
  • Material Group
  • Client
  • C_CUSTOMERRETURNITEMQRY.PRODUCTGROUP == T023.MATKL
  • C_CUSTOMERRETURNITEMQRY.MATERIALGROUP == T023.MATKL
  • C_CUSTOMERRETURNITEMQRY.MANDT == T023.MANDT
Payment Method
  • Payment Method
  • ?
  • Client
  • C_CUSTOMERRETURNITEMQRY.PAYMENTMETHOD == T042Z.ZLSCH
  • C_CUSTOMERRETURNITEMQRY.[column in domain "LAND1"] == T042Z.LAND1
  • C_CUSTOMERRETURNITEMQRY.MANDT == T042Z.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • C_CUSTOMERRETURNITEMQRY.MATERIAL == MARA.MATNR
  • C_CUSTOMERRETURNITEMQRY.PRODUCT == MARA.MATNR
  • C_CUSTOMERRETURNITEMQRY.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Material Group
  • Client
  • C_CUSTOMERRETURNITEMQRY.PRODUCTGROUP == T023.MATKL
  • C_CUSTOMERRETURNITEMQRY.MATERIALGROUP == T023.MATKL
  • C_CUSTOMERRETURNITEMQRY.MANDT == T023.MANDT
Return Reason
  • Return Reason
  • Client
Returns Refund Code
  • Returns Refund Code
  • Client
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_CUSTOMERRETURNITEMQRY.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_CUSTOMERRETURNITEMQRY.MANDT == TVAG.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_CUSTOMERRETURNITEMQRY.SHIPPINGPOINT == TVST.VSTEL
  • C_CUSTOMERRETURNITEMQRY.MANDT == TVST.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • C_CUSTOMERRETURNITEMQRY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_CUSTOMERRETURNITEMQRY.MANDT == TCURC.MANDT