Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAPSQL_SELECT_WA_TOO_SMALL

Former Member
0 Kudos
362

Hi,

when i am trying to activate the hierarchy i am getting

the above error

SAPSQL_SELECT_WA_TOO_SMALL

it says the into ( i.e waork areas ) clause area length is smaller than the table .... it recommonds to go to sap notes to modify , if i am having authority...

is any one knows what sap notes ??? and how we can access it ???

Please help

1 REPLY 1

Former Member
0 Kudos
59

Hi,

The dump message appears because you are trying to select a number of fields larger than the destination workarea. ie:

data: begin of wa,

matnr type matnr,

mtart type mtart,

end of wa.

...

select single matnr mtart matkl from mara

into wa where matnr = <some stuff>.

In the example you select 3 fields and try to save them in a work area with only two fields.

The sap notes is a knowledge database available for SAP customers. It's accesible from http://service.sap.com (id & password needed)

regards from barcelona,