topic Re: Problem in select query in Application Development and Automation Discussions

Problem in select query

Former Member — Wed, 07 Oct 2009 10:25:49 GMT

hi guru's,

i have a problem when taking data in ITAB thru select query, it is not picking data as in table...

Table MSEG data :

MBLNR.........MATNR.........BWART.........LGORT.........ERFMG.........AUFNR

500012.........AAAA.............321............RECP................123............100056

500017.........AAAA.............311............RECP................123

500014.........BBBB..............321............RECP.................115...........100058

500019.........BBBB..............311............RECP.................110

i wrote select query:

select mblnr matnr bwart lgort erfmg aufnr from mseg into itab where matnr = itab2-matnr

and lgort = itab2-lgort

and bwart = in ('321' , '311')

and zeile ne '2'.

then i m getting data in itab like :

ITAB data:

MBLNR.............. MATNR ............ BWART.............. LGORT.............. ERFMG AUFNR

500017 .............. AAAA................ 311................. RECP .............. 123

500019.............. BBBB................. 311................ RECP.............. 110

500012.............. AAAA................ 321................. RECP .............. 123.............. 100056

500014.............. BBBB................ 321 ................. RECP .............. 115 .............. 100058

can anyone please tell me that how can i get the data in ITAB in same format as in table? actually i have to do calculation of quantity on behalf of moment type.

Regards.

Re: Problem in select query

Former Member — Wed, 07 Oct 2009 10:33:16 GMT

you are getting the right data, just sort by mblnr.

Re: Problem in select query

Former Member — Wed, 07 Oct 2009 10:44:39 GMT

Just sort the internal table based on matnr and mblnr


sort itab by matnr mblnr.

Re: Problem in select query

Former Member — Wed, 07 Oct 2009 10:47:40 GMT

Sort the internal table as follows.

SORT ITAB BY MATNR MBLNR.

Re: Problem in select query

Former Member — Wed, 07 Oct 2009 10:51:16 GMT

Press F1 on SORT.

Re: Problem in select query

Former Member — Wed, 07 Oct 2009 10:52:19 GMT

hii

you are getting right data

just sort it by matnr and mblnr.

Sort itab bby matnr mblnr.

Edited by: runal kesarwani on Oct 7, 2009 12:52 PM

Re: Problem in select query

Former Member — Wed, 07 Oct 2009 13:28:35 GMT

@@ABAP@ - when you assign full points to an obviously incorrect answer, it raises red flags to the moderators.

Rob

Re: Problem in select query

Former Member — Mon, 12 Oct 2009 10:02:16 GMT

Hi Rob

Would luv to know wat was so obviously wrong with the answer to that query?

Regards

Sameer

Re: Problem in select query

Former Member — Mon, 12 Oct 2009 16:36:25 GMT

MATNR should be the first item in the sort.

Rob