Data retrieval problem - Urgent!!!

[Former Member]

Hi all,

Have a very queer problem.I have a program which queries data from a Z table. The problem is that it does not work for some entries of the ztable. The user enters 4 details in the sel-screen and all these 4 are used for the query.

Some entries when queried through the program gives me sy-subrc 4 even though all input values are correct ( please donot reply suggesting me to check my inputs).

I separately queried using the same values in se16 and the record is fetched.but it doesnot happen in through the program.

Any idea guys..if you have faced such problems before.??

[Former Member]

Hi Rahul ,

Since you dont want us to ask you to check the input again , then please try checking if there is some conversion exit for the data used , and also check what is the value used in the select statement and is it same as tha used when you access throug SE16. Perform an ST05 on the se16 transaction and check if both the values are same.

Regards

Arun

[Former Member]

Hi,

Test your code by passing each parameter to the select query(where clause).

And if all fields works fine, then try by giving bunch to the where clause.

[Former Member]

hi rahul....

please check your code gain and just check if there is some zero padding or some other conversion exit required..many times this is the major problem while fecthing the data.

please check whther the data is coming with some zero padding or some other conversion.

[Former Member]

Thanks Shlesha ,

zero padding was the problem...thanks for all others who helped