Skip to Content
Author's profile photo Harikumar NS
Harikumar NS
July 31, 2013 Less than a 1 minute read

Sales employee wise sales report

Query link for Sales Employee wise Sale

Select T1.ItemCode , T1.CardCode , T1.Cardname 

T1.Price,T1.ListNum , T1.FromDate  ,T1. ToDate ,T4. Quantity,

T4.SlpCode

from spp1 t1

inner join ocrd t2 on t1.cardcode=t2.cardcode

inner join oinv t3 on t3.cardcode=t1.cardcode

inner join inv1 t4 on t4.docentry=t3.docentry  and t1.itemcode=t4.itemcode

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo pradnya samant
      pradnya samant

      Hi Harikumar,

      You can get that by running Sales Analysis Report in Sales Reports from within SAP