SQ01 problem

Former Member — Wed, 22 Oct 2008 06:48:40 GMT

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.

Re: SQ01 problem

Former Member — Wed, 22 Oct 2008 08:24:41 GMT

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.

topic SQ01 problem in Application Development and Automation Discussions

SQ01 problem

Re: SQ01 problem