2009 Jan 13 10:41 AM
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
2009 Jan 13 10:43 AM
hi,
use as follows:
update ztable from itab.
when you use insert command you have to update from work area.
thanks,
anupama.
hi,
use as follows:
update ztable from itab.
when you use insert command you have to update from work area.
thanks,
anupama.
2009 Jan 13 10:43 AM
hi,
use as follows:
update ztable from itab.
when you use insert command you have to update from work area.
thanks,
anupama.
2009 Jan 13 10:45 AM
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
2009 Jan 13 10:50 AM
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
2009 Jan 13 10:50 AM
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
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |