problem in selection query?

[Former Member]

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.

[Former Member]

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

[Former Member]

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

CB

[Former Member]

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

[Former Member]

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

[Former Member]

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

[pawan_rai]

Hi,

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

Regards,

Pawan.

[Former Member]

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