topic Problem due to different Field types in Application Development and Automation Discussions

Problem due to different Field types

Former Member — Thu, 22 May 2008 08:48:49 GMT

Hi all,

I have to join AFRU table with a Z table based on two fields

1) RUECK

2) RMZHL

The problem with joining these two fields is in AFRU table both these field's type is Numeric but in Z table both are Character.

Due to that the data is not picked even if both fields have the same value.

In AFRU table both fields have values 000000 and then the no.How I can write the select query so that they can match and give a proper output?

Regards,

Sunny

Former Member — Thu, 22 May 2008 08:51:36 GMT

Hi,

The join will not work unless you change the data type in the ztable.

Other way is to do independent selects without using the join.

Shruthi

Former Member — Thu, 22 May 2008 08:55:11 GMT

Hi,

You can fetch the data without using join statements as follows:

Select f1 f1 from table1 into itab1

where.........

if itab1 is not initial.

select f1 f2 from table 2 into itab2

for all entries in itab1

where f1 = itab1-f1

and f2 = itab1-f2.

endif.

prasanth_kasturi — Thu, 22 May 2008 08:55:35 GMT

hi,

first create a database view by directly writing the join conditions in se11

(donot use foreign key relation ships button),

then use this database view in your program

use your select query normally.

it will fetch records having the same value of fields in join conditions

hope i am clear

reward if helpful

prasanth

Former Member — Thu, 22 May 2008 08:59:32 GMT

the two table fields should have same domain

other wise u can't fetch.

better to change ztable fields as like that standard table

hope it helps..