SAPSQL_SELECT_WA_TOO_SMALL

Former Member — Fri, 16 Apr 2004 05:24:02 GMT

Hi,

when i am trying to activate the hierarchy i am getting

the above error

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

Re: SAPSQL_SELECT_WA_TOO_SMALL

Former Member — Mon, 19 Apr 2004 08:22:33 GMT

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,

topic Re: SAPSQL_SELECT_WA_TOO_SMALL in Application Development and Automation Discussions

SAPSQL_SELECT_WA_TOO_SMALL

Re: SAPSQL_SELECT_WA_TOO_SMALL