https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979402#M1492427 <HTML><HEAD></HEAD><BODY><P>Hello all </P><P></P><P>thank you for the answers</P><P></P><P></P><P>Cetin</P></BODY></HTML> Wed, 16 Jun 2010 12:34:14 GMT Former Member 2010-06-16T12:34:14Z https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979399#M1492424 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>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.</P><P>When I try make a join over this fields, I get a type conflict .</P><P></P><P>How can I solve this problems in the view ?</P><P></P><P>Thank you in advance.</P></BODY></HTML> Tue, 08 Jun 2010 13:04:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979399#M1492424 Former Member 2010-06-08T13:04:48Z https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979400#M1492425 <HTML><HEAD></HEAD><BODY><P>You can't solve this issue with a database view as the types must be equal.</P><P></P><P></P><P></P><P>Regards,</P><P></P><P>John.</P></BODY></HTML> Tue, 08 Jun 2010 14:23:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979400#M1492425 Former Member 2010-06-08T14:23:07Z https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979401#M1492426 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Wed, 09 Jun 2010 01:06:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979401#M1492426 Former Member 2010-06-09T01:06:42Z https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979402#M1492427 <HTML><HEAD></HEAD><BODY><P>Hello all </P><P></P><P>thank you for the answers</P><P></P><P></P><P>Cetin</P></BODY></HTML> Wed, 16 Jun 2010 12:34:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/type-conflict-in-database-view/m-p/6979402#M1492427 Former Member 2010-06-16T12:34:14Z