Skip to Content
0
Former Member
Apr 25, 2014 at 12:37 PM

dump SAPSQL_WA_TOO_SMALL: Modify dbtab from itab

192 Views

Hi,

my requirements are to get data dynamically from text-file from local computer and write the data also dynamically into a db-table. I always get the dump: SAPSQL_WA_TOO_SMALL- The workarea is too small...

Here is my code:

DATA: gt_get_data_from_file TYPE TABLE OF string,
g_path TYPE string,

g_tabname TYPE string,
g_input_path TYPE string,

gt_table_names TYPE TABLE OF string.


INSERT: 'COVLOG' INTO gt_table_names INDEX 1,

'COVREF' INTO gt_table_names INDEX 2,
'COVRES' INTO gt_table_names INDEX 3.


LOOP AT gt_table_names INTO g_tabname.

MOVE 'Z:\COVERAGE ANALYZER\SCOV_OUTPUT_' TO g_path.
CONCATENATE g_path g_tabname '.TXT' INTO g_input_path.


CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = g_input_path
read_by_line = 'X'
TABLES
data_tab = gt_get_data_from_file.


IF sy-subrc = 0.
IF NOT gt_get_data_from_file IS INITIAL.

MODIFY (g_tabname) FROM TABLE gt_get_data_from_file. " <== HERE IS THE PLACE, WHERE EXCEPTION IS THROWN

ENDIF.

ENDIF.


ENDLOOP.

Any suggestions to get it run? 😊

Thanks a lot!

Best regards,

Alexander