Missing Element ID when transporting query elements

When transporting a BEX query, a transport fails with an error but not self-explanatory.

Fortunately there is an SAP Note that helps in this issue, 1593665 – Missing Element Id when transporting query elements.

Running report CHECK_MISSING_ELEMENTS, copy the element ID from the transport log and enter the version M

It will then tell you if there is a missing element for the specif query noted in the transport. You can also check it without query parameter to see all missing elements in the target system.

If you then get a result, check this element in the source system in table RSZCOMPDIR and / or RSZGLOBV as it is very likely to be a global report variable. This happens frequently when you share the same path in the landscape for production support and projects as some objects belonging to the project may be in development but not yet migrated to production. All this to diagnose the root cause as the problem gets solved if you collect the BEX query in the transport connection with all objects.