topic insert records from report program into R3 table in Application Development and Automation Discussions

insert records from report program into R3 table

Former Member — Tue, 13 Jan 2009 10:41:56 GMT

I wanted to insert records from report program into R3 table.

here is my code

data : itab type standard table of zemp initial size 10 with header line.

itab-EMPNO = '012'.

itab-ENAME = 'XXXX'.

itab-JOB = 'XXXX'.

APPEND itab.

insert ztable from table itab.

but i am getting the following error

the type of the data base table and work area/internal table "ITAB" are no unicode-converible.

how can I insert records from report program into R3 table

should I have to write move corresponding

pls guide

thanks

manian

Re: insert records from report program into R3 table

Former Member — Tue, 13 Jan 2009 10:43:02 GMT

hi,

use as follows:

update ztable from itab.

when you use insert command you have to update from work area.

thanks,

anupama.

Re: insert records from report program into R3 table

Former Member — Tue, 13 Jan 2009 10:45:40 GMT

Hi,

Check that your ITAB and the ZTABLE are of same Sturcture.

And use Modify Statement instead of insert.

Because in insert if it is found that record already exists then it will give Dump.

Regards

Sandipan

Re: insert records from report program into R3 table

Former Member — Tue, 13 Jan 2009 10:50:04 GMT

Hi,

You have declared the work are and internal table of type zemp, but you are inserting the reocrods in the table ztable.

There will be compatibility issues if the structure of zemp is not exactly same as ztable.

What you need to do is declare the internal table as same as the database table.

regards,

Advait

Re: insert records from report program into R3 table

Former Member — Tue, 13 Jan 2009 10:50:05 GMT

Hi,

itab-EMPNO = '012'.

itab-ENAME = 'XXXX'.

itab-JOB = 'XXXX'.

APPEND itab.

insert ztable from table itab.

Do one thing

Data : itab type table of ztable with header line.

itab-EMPNO = '012'.

itab-ENAME = 'XXXX'.

itab-JOB = 'XXXX'.

APPEND itab.

insert ztable from table itab.

error will resolve, then try to make structure similar to ZTABLE