topic Syntax error in insert statment in Application Development and Automation Discussions

Syntax error in insert statment

Former Member — Sat, 15 Jul 2006 13:41:50 GMT

I need to insert values an Internal table into a ZTABLE.

INSERT ZTABLE FROM TABLE FINAL.

Error message:

The work area "FINAL" is not long enough.

I have declared the structure of the internal table FINAL same as the ZTABLE. Still I am getting the error message

Former Member — Sat, 15 Jul 2006 13:53:48 GMT

I think in the ztable you have a field for mandt and that field you havent included in final internal table.

declare as follows:

data: begin of final occurs 0.

include structure zfinal.

data: end of final.

Regards,

Ravi

Former Member — Sat, 15 Jul 2006 13:54:35 GMT

Hi Viven,

Try this

DATA: lit_ztable TYPE TABLE OF ztable,

INSERT ztable FROM TABLE lit_ztable ACCEPTING DUPLICATE KEYS.

Rgds,

Prakash

Rward useful answer

Manohar2u — Sat, 15 Jul 2006 14:06:09 GMT

This error is because FINAL is not defined as an internal table.

Declare it as

data : final like ztable occurs 0 with header line.

Regds

Manohar