topic Re: insert Statement in Application Development and Automation Discussions

insert Statement

Former Member — Sat, 08 Mar 2014 05:11:18 GMT

Hi All,

I am having a problem regarding Insert Statement.

I am getting data in the ITAB but when I insert this data in the Ztable it is not inserting in the table..

The same logic I have implemented in other program and it is working, I mean it inserts data in the ztable.

But in this case it is not inserting.

Any idea about this?

LOOP AT it_work.

it_final_scheme-schno = v_schnumber.

it_final_scheme-advstar = it_work-advstar.

it_final_scheme-perend = it_work-perend.

it_final_scheme-amount = it_work-amount.

it_final_scheme-percent = it_work-percent.

APPEND it_final_scheme.

INSERT INTO /vcrebate/schtab VALUES it_final_scheme.

COMMIT WORK.

*IF sy-subrc = 0.

* MESSAGE 'S' TYPE 'S'.

* ENDIF.

ENDLOOP.

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 06:37:49 GMT

Hi Yash,

what is this /vcrebate/schtab, is this your table, simply use

INSERT your ztable FROM it_final_scheme.

Re: insert Statement

Former Member — Sat, 08 Mar 2014 06:40:15 GMT

Hi Sanjeev.

/vcrebate/ is namespace..

But this is not the issue.

I am using Table control and the data is populated from the same in the ITAB.

I Did the same as you said, the issue is when the data is inserted for the first time, the data gets inserted but when I run the transaction for second time or third time , the data is not getting inserted.

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 06:44:25 GMT

Hi Yash,

always use work area instead , because it will be easy to do updation by use of work area,

once you insert your data through work area, just clear your work area.

See this code

CLEAR : your work area.

LOOP AT internal table INTO work area.

fetch your data.

INSERT Ztable FROM work area.

IF sy-SUBRC eq 0.

MESSAGE 'Data has been save sucessfully' TYPE 'S'.

ENDIF.

ENDLOOP.

CLEAR work area.

REFRESH INTERNAL TABLE[].

Just do one thing before your loop statement, just clear your internal table (it_final).

Re: insert Statement

Former Member — Sat, 08 Mar 2014 07:00:58 GMT

Thank You Sanjeev.

I am doing by this way..

But getting error of "Unicode Convertible"

LOOP AT it_work INTO wa_work.

wa_final_scheme-schno = v_schnumber.

wa_final_scheme-advstar = wa_work-advstar.

wa_final_scheme-perend = wa_work-perend.

wa_final_scheme-amount = wa_work-amount.

wa_final_scheme-percent = wa_work-percent.

APPEND wa_final_scheme TO it_final_scheme.

INSERT zschtab FROM wa_final_scheme.

COMMIT WORK.

IF sy-subrc = 0.

MESSAGE 'S' TYPE 'S'.

ENDIF.

ENDLOOP.

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 07:05:38 GMT

Yash,

then there is problem in your table structure , you have declared in top most of your program,

Keep it as your data base table is, please see each field and its declaration in your program and table

for data consistency.

Re: insert Statement

Former Member — Sat, 08 Mar 2014 07:09:29 GMT

Sanjeev I have declared like this..

So is it correct??

data : it_work TYPE TABLE OF ty_work,

wa_work LIKE LINE OF it_work,

it_final_scheme TYPE TABLE OF ty_work,

wa_final_scheme like LINE OF it_final_scheme.

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 07:14:36 GMT

Hi Yash,

i means to say that please check where you have written your TYPES structure

types : begin of ty_final,

data type your data base table-data,

...check your data types here also

...

end of ty_final.

data : it_final type standard table of ty_final,

wa_final type ty_final.

Re: insert Statement

Former Member — Sat, 08 Mar 2014 07:24:01 GMT

TYPES : BEGIN OF ty_scheme,

schno TYPE zschtab-schno ,

advstar TYPE zschtab-advstar ,

perend TYPE zschtab-perend ,

amount TYPE zschtab-amount ,

percent TYPE zschtab-percent,

END OF ty_scheme.

DATA : it_scheme TYPE TABLE OF ty_scheme,

wa_scheme LIKE LINE OF it_scheme,

it_work TYPE TABLE OF ty_scheme,

wa_work LIKE LINE OF it_scheme,

it_final_scheme TYPE TABLE OF ty_scheme,

wa_final_scheme LIKE LINE OF it_scheme.

See I am doing this as you said...

Still getting the same error.

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 07:29:51 GMT

Hi ,

please use and see , is it still giving error ?

DATA : it_scheme TYPE STANDARD TABLE OF ty_scheme,

wa_scheme TYPE it_scheme,

it_work TYPE STANDARD TABLE OF ty_scheme,

wa_work TYPE it_scheme,

it_final_scheme TYPE STANDARD TABLE OF ty_scheme,

wa_final_scheme TYPE it_scheme.

Re: insert Statement

Former Member — Sat, 08 Mar 2014 07:31:54 GMT

Yes Sanjeev I did the same..

Used standard table also.. But the same error.

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 07:37:43 GMT

Hi Yash,

please uncheck (UNICODE CHECKS ACTIVE ) as shown in screenshot here in the attribute in SE38

if still having problem ,please attach your whole code

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 07:43:55 GMT

Hi Yash,

if you have used like this, then please change your code as shown below

LOOP AT it_work INTO wa_work.

wa_final_scheme-schno = v_schnumber.

wa_final_scheme-advstar = wa_work-advstar.

wa_final_scheme-perend = wa_work-perend.

wa_final_scheme-amount = wa_work-amount.

wa_final_scheme-percent = wa_work-percent.

INSERT zschtab FROM wa_final_scheme.

CLEAR wa_final_scheme.

IF sy-subrc = 0.

MESSAGE 'S' TYPE 'S'.

ENDIF.

ENDLOOP.

Re: insert Statement

Former Member — Sat, 08 Mar 2014 07:47:13 GMT

I did this also..

Same Result....

Re: insert Statement

Former Member — Sat, 08 Mar 2014 07:48:03 GMT

After unchecking this the program gave an error of Unicode.

So i checked it.

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 07:49:46 GMT

Its problem in the declarations, plz check your data throughtly

Re: insert Statement

Former Member — Sat, 08 Mar 2014 07:57:31 GMT

I copied and pasted all the fields from the database itself.

Re: insert Statement

Former Member — Sat, 08 Mar 2014 08:20:13 GMT

Error solved.

I added MANDT in this ITAB.

Another runtime error generated Error in internal table in screen

Re: insert Statement

Former Member — Sat, 08 Mar 2014 08:33:11 GMT

Hi Yash,

Please read help on INSERT statement.

The work area must be of Line Type of the table used in INSERT statement.

Declare the work area as that of ZTABLE.

Data : IT_TAB type standard table of ZTABLE,

wa_tab type ZTABLE.

Populate the workarea with the data and then use INSERT statement.

INSERT ZTABLE from workarea.

or INSERT INTO ZTABLE values IT_TAB.

Hope it helps....

Cheers,

Sumit

Re: insert Statement

former_member187748 — Sat, 08 Mar 2014 08:39:38 GMT

Hi Yash,

i told you earlier that please check your data consistency with your databse table,

now what is the issue with screen