query

[Former Member]

there is a material called 111

the client wants to see who all have purchased this material what is the amount that the client has got by selling this material???

there is a customer abc

the client wants to see what all the customer has purchased from the company

what are his outstandings

what all he has paid to us?

Is this possible??

the abapers does not know how to write a program...is there a tcode for the above said query??

[Lakshmipathi · Accepted solution]

- To see sales details, run VF05 or VF05N. You can also see these details in FBL5N

- run FBL1N so that you can see Vendor wise Accounts Receivable details.

thanks

G. Lakshmipathi

[vamshikrishnajm]

Hi,

You can find out what the customer has purchased by going to the customer history. go to va02 and click on the customer sales summary . You will be able to see the sales summary and you can click on the list of sales order. You will get the full details.

Regarding material- on who has purchased this material I am not very sure. experts pls help.

thanks

Vamshi

[Former Member]

Hi,

It is also achieveable thro an Abap Querry:

The Tcodes pertaining the same are :

SQ01 , SQ02 , SQ03

Which are Query creation , Info set creation and User groups

By linking the required tables thru Join Conditions the require info can be viewed.

U can find the details

<www.auditware.co.uk/downloads/SAPQuery_step_thru.pdf>

Regards..