P_VarConfignSalesByNetValBase

Base View for VC Related Sales Analytics | view: PVARCONFSLSNTVB | Extraction: Not supported | Component: Variant Configuration
Tables used: VBAKVBAPVBKDVEDA
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
💲 null (DisplayCurrency):
NetAmountInDisplayCurrency Net Value 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
CreationYearMonth null
SoldToParty Sold-to Party KUNNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
SalesOffice Sales office VKBUR
SalesDocumentType Sales Document Type AUART
OrganizationDivision Division SPART
ProductConfiguration Configuration CUOBJ
Master Data Relations Join Conditions
Material: order item
  • Client
  • Product Number
  • P_VARCONFIGNSALESBYNETVALBASE.MANDT == MARA.MANDT
  • P_VARCONFIGNSALESBYNETVALBASE.PRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Group
  • P_VARCONFIGNSALESBYNETVALBASE.MANDT == T023.MANDT
  • P_VARCONFIGNSALESBYNETVALBASE.PRODUCTGROUP == T023.MATKL
SD Document Currency
  • Client
  • SD Document Currency
  • P_VARCONFIGNSALESBYNETVALBASE.MANDT == TCURC.MANDT
  • P_VARCONFIGNSALESBYNETVALBASE.TRANSACTIONCURRENCY == TCURC.WAERS