Type conflict in Database View

[Former Member]

Hello all,

I want to create a database view. The Database view contains two basic tables ( they are standard tables from SAP [Tables: USR21, CSKS]). Both standard talbles contains a field for costcenter named "kostl" , but with different datatypes and length.

When I try make a join over this fields, I get a type conflict .

How can I solve this problems in the view ?

Thank you in advance.

[Former Member]

Hello all,

I want to create a database view. The Database view contains two basic tables ( they are standard tables from SAP [Tables: USR21, CSKS]). Both standard talbles contains a field for costcenter named "kostl" , but with different datatypes and length.

When I try make a join over this fields, I get a type conflict .

How can I solve this problems in the view ?

Thank you in advance.

[Former Member]

You can't solve this issue with a database view as the types must be equal.

Regards,

John.

[Former Member]

join condition fields must be of the same data type.. just think of a join statement that you write in an abap program.. can you match two tables joiing fields with different types?

[Former Member]

Hello all

thank you for the answers

Cetin