P_CustRetItemByMonth

Customer Return Item By Month | view: PSDRETITMBYMNTH | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBAKVBAPVBKDVEDAVBEPKNA1TVKO
Column Name Description
CustomerReturn FK Customer Return
CustomerReturnItem Customer Return Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
IncomingCustReturnsNetAmount Net Amount of Customer Return Items
💲 Display Currency (DisplayCurrency):
IncomingCustReturnsNetAmtInDC Net Amount of Customer Return Items in Display Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
Column Name Description
Column Name Description Domain name
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
SoldToPartyName Name of Sold-to Party TEXT80
Master Data Relations Join Conditions
Order type in order header
  • Customer Return Type
  • Client
  • P_CUSTRETITEMBYMONTH.CUSTOMERRETURNTYPE == TVAK.AUART
  • P_CUSTRETITEMBYMONTH.MANDT == TVAK.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • P_CUSTRETITEMBYMONTH.MANDT == TCURC.MANDT
  • P_CUSTRETITEMBYMONTH.TRANSACTIONCURRENCY == TCURC.WAERS