topic Re: data Type conflict in join while creating view in Application Development and Automation Discussions

data Type conflict in join while creating view

Former Member — Fri, 21 Nov 2008 12:11:38 GMT

Hi All,

I am creating view on 2 tables. But the fields that i am using to join 2 tables have different data elements and different data type.

I am getting error "Type conflict in join (Two fields with different data types or lengths)"while activation .

I cant make dataelements same since tables are standard.

Can you please help.

Thanks

Savio

Former Member — Fri, 21 Nov 2008 12:13:10 GMT

You must use the fields of the same length.

Former Member — Fri, 21 Nov 2008 12:14:04 GMT

Hi Savio,

Just check the key fields of both the tables and corresponding data elements.

Put join condition on their common key fields.

Thanks

Former Member — Fri, 21 Nov 2008 12:18:36 GMT

Hi,

The field i am using to link this tables have different data elements and type.

I canot make changes in table fields since they are sap standard.

thanks

Savio

ThomasZloch — Fri, 21 Nov 2008 12:20:58 GMT

Then you simply cannot join these two fields.

Thomas