topic Re: select statement failed in Application Development and Automation Discussions

select statement failed

Former Member — Thu, 01 Apr 2010 15:19:06 GMT

Hi,

i used a select statement but in my selection screen user is not entering any lifnr value, then i am getting sy-subrc = 4.

I want if user also not enter any lifnr value in selection screen , the value should fetch.

is this mandatory to enter the lifnr value in selection screen?

SELECT matnr

werks

slabs

FROM mkol

INTO TABLE gt_mkol

FOR ALL ENTRIES IN gt_marc

WHERE matnr = gt_marc-matnr

AND werks = gt_marc-werks.

AND lifnr = so_lifnr.

Re: select statement failed

Former Member — Thu, 01 Apr 2010 15:30:18 GMT

hi,

It not necessary to get the values from the user in the selection screen field..however if you want to run your query then you will have to use an OR condition in the where clause..

eg.

select x y x from <table name > into <table name>

for all enteries in <table name>

where <field 1> =/IN (in case of select options) <the field on the screen> OR <field 1> = some field value.

the better solution will be to give a default value for your screen field.

Re: select statement failed

Former Member — Thu, 01 Apr 2010 15:32:26 GMT

Moderator message - Please do not ask or answer basic questions - thread locked Rob