data Type conflict in join while creating view

[Former Member]

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]

You must use the fields of the same length.

[Former Member]

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]

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]

Then you simply cannot join these two fields.

Thomas