Skip to Content
author's profile photo Former Member
Former Member

SAPSQL_SELECT_WA_TOO_SMALL

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 19, 2004 at 08:22 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded