SAP Open SQL message size

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Post Reply
DrSidewalk
Posts: 180
Joined: Thu May 03, 2012 9:35 am

SAP Open SQL message size

Post by DrSidewalk » Mon Jul 14, 2014 7:44 am

Many years back I remember getting our Basis team to extend the size of the SAP SQL statement size. I can't remember whether this was a SAP change or an SAP/Oracle change. I also remember change the number of entries that can appear in the 'FOR ALL ENTRIES IN' clause as well. Again I can't remember how that is done either and our SAP Basis team (off-shore) have been unable to find this.

At present anything over 5 entries in the 'FOR ALL ENTRIES IN' clause are pushed into another SQL statement and UNION'ed together. So if we have 100 materials in itab identified in the FOR ALL ENTRIES IN itab then we'll get 20 SQL statements Union'ed together. WHich is not nice.

Can anyone be of help?. I think we have something like 500 characters at the maximum SQL size in characters, and I believe we can go up as far as 2Kb (2048 chars).

Dr Sidewalk

DrSidewalk
Posts: 180
Joined: Thu May 03, 2012 9:35 am

Re: SAP Open SQL message size

Post by DrSidewalk » Tue Jul 15, 2014 4:28 am

Anyone?.

Gothmog
Posts: 1955
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: SAP Open SQL message size

Post by Gothmog » Tue Jul 15, 2014 6:58 am

Maybe the following OSS notes can help you:
48230 - Parameterization of SELECT ... FOR ALL ENTRIES statement
634263 - Selects with FOR ALL ENTRIES
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67

Snowy
Posts: 28796
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: SAP Open SQL message size

Post by Snowy » Tue Jul 15, 2014 3:23 pm

what is your SAP product and version?
and this is with Oracle version?

DrSidewalk
Posts: 180
Joined: Thu May 03, 2012 9:35 am

Re: SAP Open SQL message size

Post by DrSidewalk » Wed Jul 16, 2014 10:22 am

Have mentoned that our Database is Oracle, in my posting. I don't think the version/Release of SAP would make that much difference, but we are SAP_BASIS/SAP_ABAP Release 702.

I think the postings by Gothmog will be of some help.
Although I keep seeing postings in various places to say that in the later versions the SQL statement can be increased to 1Mb from the 4Kb it used to be. But they never say how this can be achieved, just that it can be achieved.

Post Reply