topic Re: Select Query Problem in Application Development and Automation Discussions

Select Query Problem

Former Member — Tue, 29 Jun 2010 11:24:13 GMT

Hi ALL,

SELECT mast~matnr

INTO gw_mat-matnr

FROM mast

INNER JOIN stko

ON mast_{stlnr = stko}stlnr

AND mast_{stlal = stko}stlal

UP TO 1 ROWS

WHERE mast~matnr = gw_mat-matnr

AND mast~werks = gw_mat-werks

AND ( mast_{stlan = 'Y' or mast}stlan = '1')

AND stko~stlty = 'M'

AND stko~loekz = space.

Now this query is fetching only one row . In table MAST 2 rows are there for the field mast-stlan (i.e) for 'Y' AND '1'. So more than one rows has to be filled in gw_mat-matnr that is my requirement without using inernal table. Because gw_mat-matnr is used in many places and also this is a standard program. please suggest me to proceed.

Regards

R.vijay

Re: Select Query Problem

Former Member — Tue, 29 Jun 2010 11:39:47 GMT

In the select query, when you use UP TO 1 ROWS, only one row will be fetched. Thats the reason. Also gw_mat looks like a work area and not a internal table. I dont understand how you can expect two records to be fetched into a work area or a structure.

Re: Select Query Problem

Former Member — Tue, 29 Jun 2010 12:38:56 GMT

Dear

you have used UP TO 1 ROWS...which means it will selet only one row as you mentioned 1..

Please remove that stmt and check...

Re: Select Query Problem

ThomasZloch — Tue, 29 Jun 2010 14:41:55 GMT

As you can see from the replies, this is very basic, please try solving things yourself before asking, the learning curve will be much steeper.

For problems with SAP standard code visit the SAP Support Portal.

Thread locked.

Thomas