Strange behavoir using MDO in SAP MII

[holger_schaetzle2]

Hello,

I'm using SAP MII 15.2 SP3 Patch3.

I tried to change the order by column in an existing MDO Join Query and got the following error:

... type check error: the column AUFNR.1 in the ORDER BY list is not contained in the SELECT list

The strange thing: I haven't added the column AUFNR.1 to the ORDER BY, I added the column PLAN_START and the column is contained in the SELECT list.

So I did some further investigations. I did a schema check to the MDO (http://<server>:<port>//XMII/Illuminator?Service=MDO&Mode=CheckSchemas) and the affected MDO has a warning no table schema found

Unfortunately I'm not able to get rid of this warning. Even deleting and re import the MDO Schema didn't solve the problem.

I'm using user defined table names for the MDOs. I have this behavior on three systems (DEV ,Q and PROD)

Exporting the project, importing it on a different system (15.3 SP0 Patch 0), without using user defined table names, solves the problem. There I have no warning doing a schema check and also no strange behavior changing the order in the mentioned join query.

So has anybody an idea, how to solve the problem?

Thanks for any hint

Best Regards

Holger