we are trying to create a view on 2 tables with the use of inner join. while reading the data from view it is showing data services execution failed

[Former Member]

we are trying to create a view on 2 tables with the use of inner join. while reading the data from view it is showing data services execution failed  . Please check in below screenshot ..??

[praveshnegi]

Hi,

Screenshot suggest column store error:

Seems to be mismatched data type in one of the fields.

ex: field1  type char (2)     is defined  

now, one of the data record is trying to push value > length 2  in field 1.

Check if you are overriding any of the columns or modifying their data types.

Regards,

Pravesh

[Former Member]

Hi Negi ,

Thanks for your response,

we have not done any changes on data types . we are using as it is from the tables.

and it is showing memory allocation failed ,search table error,column store ..

please share your suggestions..

[Former Member]

how big are these two tables ?check with your administrator if you have enough space in IS Pageable cache directory..

[Former Member]

Test it by restricting the number of columns in your view. Select 2 or three columns while defining your view to make sure this is not the column width error in SAP.

-Chaitanya

[Former Member]

Hi Chaitanya ,

Thanks for reply.

I used with lesser columns. But still there is a same issue .

[Former Member]

Kishore,

Your join is wrong which may be resulting in huge volume of records. Join should be on MATNR between MARA and MVKE and not 'MANDT'. Also, as an additional test, apply a filter condition to restrict to under 10 rows.

-Chaitanya