Skip to Content

Is there a limit to the capacity of Query Window to accept code?

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

2 Comments
You must be Logged on to comment or reply to a post.
  • 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ó