Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

insert records from report program into R3 table

Former Member
0 Likes
733

Hi

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
704

hi,

use as follows:

update ztable from itab.

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

thanks,

anupama.

Hi

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

4 REPLIES 4
Read only

Former Member
0 Likes
705

hi,

use as follows:

update ztable from itab.

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

thanks,

anupama.

Read only

Former Member
0 Likes
704

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

Read only

Former Member
0 Likes
704

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

Read only

Former Member
0 Likes
704

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