topic Re: select statment in Application Development and Automation Discussions

select statment

Former Member — Wed, 22 Nov 2006 10:43:07 GMT

Hi,

I am writing a select statement to get the details from IHPA table based on PARNR value.

Here i have value 100 for parnr field and i am searching on this for the records. But its not displaying the record based on this selection. For other values like character value for this parnr filed i am able tyo get the records.

Can anyone let me know the problem for this...

Regards,

Ram

Re: select statment

Sandeep_Panghal — Wed, 22 Nov 2006 10:47:27 GMT

Hi,

Try converting the PARNR field to SAP format and then use the same in WHERE clause.

Re: select statment

Former Member — Wed, 22 Nov 2006 10:47:40 GMT

May be that value is not there in that table, try with other number or else may be your selection condition is not correct. Check with the where condition. If u post the code where you r giving where condition may be we can correct that.

Regards

Haritha.

Re: select statment

Former Member — Wed, 22 Nov 2006 10:49:52 GMT

Hi,

There is no problem in the select statement. Its giving the results for the character value of PARNR. but if we pass the numeric value then its not giving. But there are some records with PARNR value as numeric.

Regards,

Ram.

Re: select statment

Former Member — Wed, 22 Nov 2006 10:52:19 GMT

Just now i have tried it give the data in single quotes in the exact format as it is stored in database eg '000000002' like this, it will work.

Regards

Haritha.

Message was edited by:

Haritha Ramayanam Ramayanam

Re: select statment

Former Member — Wed, 22 Nov 2006 10:52:52 GMT

hi Ram,

pass PARNR value as '0000000100' then see the results of select.

Regards

vijay

Re: select statment

Former Member — Wed, 22 Nov 2006 10:53:55 GMT

even tried with this value also by converting PARNR using

conversion_exit_alpha_input FM.

Regards,

Ram

Re: select statment

Former Member — Wed, 22 Nov 2006 10:57:11 GMT

Hi Ram,

Yes u r right!!

this looks strange

When i go to that table and give an existing partner value and check the no of entries , it is not showing any entries even the entry exists