SQ01 problem

[Former Member]

HI,

i have to create a simple query using tables VBAK and VBAP...but this query should contain top 100 most materials sold between date1 and date2.

How can i do this? I mean where i put the query which group materials and make a count ?

Thank you.

[Former Member]

hi,

You need to create a 'Ranked list' in SQ01 for displaying top 100 records of materials on price basis. For this, click on 'Ranked list button'. Give 100 as input in 'No of places' tab . Give the sequence number as 1,2,3 etc. in 'No' tab for the fields which you want to display . Choose the radio button 'Crit' , as criteria , for the field base on which you selecting top 100 records, for example in you case it is sold price of materials. Check the checkbox 'ASC' for displaying records in ascending order . You need to give the appropriate unit in 'UNIT' tab. Thus it creates your ranked list. Now you can choose the output sequence by pressing CTRL + F4. Rest other conditions like fields only in particular dates , that you can do it in infoset for that query.