topic Data retrieval problem - Urgent!!! in Application Development and Automation Discussions

Data retrieval problem - Urgent!!!

Former Member — Wed, 18 Jun 2008 09:40:56 GMT

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.??

Re: Data retrieval problem - Urgent!!!

Former Member — Wed, 18 Jun 2008 09:47:26 GMT

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

Re: Data retrieval problem - Urgent!!!

Former Member — Wed, 18 Jun 2008 09:50:26 GMT

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.

Re: Data retrieval problem - Urgent!!!

Former Member — Wed, 18 Jun 2008 10:12:59 GMT

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.

Re: Data retrieval problem - Urgent!!!

Former Member — Wed, 18 Jun 2008 10:38:13 GMT

Thanks Shlesha ,

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