P_SalesOrderItem

Sales Order Item for Sales Manager Overview Page | view: PSDSLSODRITM | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBAKVBAPVBKDVEDAVBEPTVKO
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
IncomingSalesOrdersNetAmount Incoming Sales Orders Net Value in Transaction Currency
💲 Display Currency (DisplayCurrency):
IncomingSalesOrdersNetAmtInDC Incoming Sales Orders 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
SalesOrderType Sales Document Type AUART
SoldToParty Sold-to Party KUNNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
SD Document Currency
  • Client
  • SD Document Currency
  • P_SALESORDERITEM.MANDT == TCURC.MANDT
  • P_SALESORDERITEM.TRANSACTIONCURRENCY == TCURC.WAERS