Skip to Content

Hi,

I seem to have filled the Query Window to the max.

I am writing longer and longer queries in notepad, and paste them to the Query Window.

My queries are long mainly because:

  (1) I use a kind of menu system so as to simplify the life of users. It means my queries in fact hold many queries inside.

        I use GOTO to branch to the appropriate query selected by the user. So, my staff have all related queries in one place.

  (2) I have still not developed sufficient proficiency in stored procedures, UDF, etc which can shorten codes.

From time to time, I do shorten my codes.

I got a bad surprise today.

My existing code is already very long – about 17 pages A4 (not too crowded) and has served me well.

Now I added about 10 more pages….

Query Window won’t accept anymore!

Could anyone tell me what is happening?

Is there a limit to how long you can run Queries in Query Window?

Of course I know I must shorten my codes, but I did not expect SAP to limit the size of queries

one can write.

Suppose an expert wrote a query (say 50 pages A4), which cannot be shortened anymore.

How would he proceed to run his query to generate reports from SAP?

Thanks

Leon Lai

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Ottó Nánássi

    Hello,

    Just an idea.

    Why don’t you create a view in SQL server? You can refer these view from SAP as a single querry…in sql server i dont think such limitation exists…

    Regards,

    Ottó

    (0) 

Leave a Reply