Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Derived table sql syntax size limit

Hello,

I have a query with a very long sql syntax to put in a derived table.

It seems to me that there is a limitation on the numbers of characters or line for the sql syntax.

For example, my query has 3 000 lines but i can only past 1000 lines in the derived table.

Does anyone know what is the limitation and if it is possible to change it ?

Best regards

Didier

replied

Hi Didier,

If you are using XI 3.0 and above you cand now define derived tables on derived tables by using @Derived(Derivedètable_name) expression in your derived table.

This solution might solve your issue.

Regards,

Didier

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question