topic Re: problem in selection query? in Application Development and Automation Discussions

problem in selection query?

Former Member — Mon, 20 Jun 2011 05:48:59 GMT

Sir,

i didn't get the value when i select some values from ztable using where condition.Query is as follows

SELECT * FROM ztable INTO TABLE

it_data where matkl = p_matkl.

matkl is one of the field in ztable and p_matkl is one of parameter passing in selection time.

Plz Help.

Re: problem in selection query?

Former Member — Mon, 20 Jun 2011 05:57:19 GMT

Hi ,

Goto se11 and check if the value you are passing in the input , is present in the ztable or not .

If it is present , then check whether the parameter and ztable column MATKL has the same data element / data type .

Regards ,

Hemant

Re: problem in selection query?

pawan_rai — Mon, 20 Jun 2011 05:59:28 GMT

Hi,

Did you debug and check whether the values are coming into your internal table or not?

Regards,

Pawan.

Re: problem in selection query?

Former Member — Mon, 20 Jun 2011 06:02:04 GMT

Hi ,

Incase you have data in ZTABLE ,then also you are not getting the data after SELECT statment ,please check length of the matkl you are passing as paramenter .ie ex : if the matkl in the table is 005000 but you are passing as 5000 then the select statment will give subrc as 4.

Regards

Re: problem in selection query?

Former Member — Mon, 20 Jun 2011 06:08:41 GMT

Hi,

Check if the table it_data is of same type that of ztable... if the structure is not same try giving .

INTO CORRESPONDING FIELDS OF IT_DATA

but for this atleast field names should be same .. other wise the statement is correct .. check if the parameter you are passing for data selection that corresponding data is there in the table in se16.

Edited by: prashanti korlepara on Jun 20, 2011 8:09 AM

Re: problem in selection query?

Former Member — Mon, 20 Jun 2011 06:49:18 GMT

if i got subrc =4 exc then what can i do?

Re: problem in selection query?

Former Member — Mon, 20 Jun 2011 06:50:53 GMT

if i got subrc =4 exc then what can i do?

Re: problem in selection query?

Former Member — Mon, 20 Jun 2011 07:20:37 GMT

Hi,

check if the field p_matkl is a parameter or select options.

If it is a parameter and no value inputted at the time of selection no value will get selected but if it is select option and no value entered at the selection screen then all the values fron the ztable will get selected.

Regards

Bikas