select statment

[Former Member]

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

[Sandeep_Panghal]

Hi,

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

[Former Member]

Hi

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.

[Former Member]

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.

[Former Member]

hi Ram,

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

Regards

vijay

[Former Member]

even tried with this value also by converting PARNR using

conversion_exit_alpha_input FM.

Regards,

Ram

[Former Member]

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

[Former Member]

Hi

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