customer sales analysis report

[Former Member]

Hi gurus,

My client requests to have their sales analysis report for sales org xxxx to have the headings invoice date xx/xx/xx, invoice number 9xxxxxxxx and amount NGNxxxxxxxx, ie to generate the report based on this three headings.

How can i achieve this and what is the tcode or procedure i can follow?

Thanks

Maureen.

[Former Member]

ok

[former_member1091983]

Hi,

Try with this links to create a Query

/people/shafiq.rehman3/blog/2008/06/16/sap-adhoc-query-sq01-sq02-sq03

http://www.olemiss.edu/projects/sap/SQ01_10_03.pdf

and as suggested above join the tables VBRK and VBRP..

Reg

JJ

Edited by: Jagsap on Jun 24, 2009 7:07 AM

[Former Member]

Hi

Goto t code SQVI quick viewer and using the table join create a query using the tables VBRK and VBRP

regards

[former_member1091983]

Hi,

Try with SAP query in t-code SQ01 to create a report with the help of an ABAPer

Reg

JJ

Edited by: Jagsap on Jun 23, 2009 2:40 PM

[Former Member]

Thanks JJ,

I don't have an abaper wt me, can anyone give me an idea on how to develop this using the tcode sq01?

thanks

Maureen