topic Re: save data in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557202#M1075798 <HTML><HEAD></HEAD><BODY><P>hello</P><P>'use modify instead of insert...</P><P>tell me wat error it shows</P></BODY></HTML> Tue, 30 Sep 2008 11:52:00 GMT Former Member 2008-09-30T11:52:00Z save data https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557201#M1075797 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Following Codeing using to table control data save ztable.</P><P></P><P>module update_database input.</P><P>IF ok_code = 'SAVE'.</P><P> DATA : itab2_save LIKE ZPSRP OCCURS 10 WITH HEADER LINE,</P><P> itab2_db LIKE ZPSRP OCCURS 10 WITH HEADER LINE.</P><P> CLEAR : itab2_save , itab2_db.</P><P> REFRESH : itab2_save , itab2_db.</P><P> LOOP AT itab2.</P><P> MOVE-CORRESPONDING itab2 TO itab2_save.</P><P> MOVE sy-mandt TO itab2_save-mandt.</P><P> APPEND itab2_save.</P><P> ENDLOOP.</P><P> IF LIPS-vbeln IS NOT INITIAL.</P><P> SELECT * FROM ZPSRP</P><P> INTO CORRESPONDING FIELDS OF TABLE itab2_db</P><P> WHERE vbeln = LIPS-vbeln.</P><P></P><P> ELSEIF likp-vbeln IS NOT INITIAL.</P><P> SELECT * FROM ZPSRP</P><P> INTO CORRESPONDING FIELDS OF TABLE itab2_db</P><P> WHERE vbeln = likp-vbeln.</P><P></P><P> ENDIF.</P><P> IF sy-subrc = 0.</P><P>*if itab2_db[] = itab2_save[].</P><P> LOOP AT itab2_db.</P><P> DELETE ZPSRP FROM itab2_db.</P><P> ENDLOOP.</P><P>*Loop AT Itab2.</P><P></P><UL><LI level="1" type="ul"><P> MODIFY ZPSRP FROM TABLE itab2_save.</P></LI></UL><P> INSERT ZPSRP FROM TABLE itab2_save.</P><UL><LI level="1" type="ul"><P> COMMIT WORK.</P></LI></UL><P> REFRESH: itab2. "_save.</P><P>*ENDLOOP.</P><UL><LI level="1" type="ul"><P>endif.</P></LI></UL><P> ELSE.</P><P></P><P> LOOP AT itab2_save.</P><P> MODIFY itab2_save.</P><P> ENDLOOP.</P><P></P><UL><LI level="1" type="ul"><P> LOOP AT ITAB2_SAVE.</P></LI><LI level="1" type="ul"><P> MODIFY ZPSRP FROM TABLE itab2_save.</P></LI></UL><P></P><P> INSERT ZPSRP FROM TABLE itab2_save.</P><UL><LI level="1" type="ul"><P> COMMIT WORK.</P></LI><LI level="1" type="ul"><P> ENDLOOP.</P></LI></UL><P> ENDIF.</P><P> REFRESH : itab2_save, itab2.</P><UL><LI level="1" type="ul"><P> CLEAR :itab2 , flag , vbeln , vstel.</P></LI><LI level="1" type="ul"><P> CLEAR: likp-vbeln,</P></LI><LI level="1" type="ul"><P> likp-vstel.</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> CLEAR: vbrp-vbeln,</P></LI><LI level="1" type="ul"><P> vbrp-vstel.</P></LI></UL><P>*</P><UL><LI level="1" type="ul"><P> CLEAR : TOT_BAG,</P></LI><LI level="1" type="ul"><P> TOT_WEG.</P></LI></UL><P></P><P> ENDIF.</P><P></P><P></P><P>endmodule. " update_database INPUT</P><P></P><P></P><P></P><P>ITAB2 and ZPSRP is same fields.</P><P></P><P>Prb Is : 1. multiple record not save .</P><P></P><P>EG:</P><P>Vbeln posnr QTY1 weight</P><P>-1000 10 50 100</P><P>-1000 10 60 110 </P><P></P><P>the above record not save in same time </P><P></P><P>*<STRONG>error is</STRONG>:*INSERT ZPSRP FROM TABLE itab2_save.</P><P></P><P></P><P>Kindly Advise me.</P><P></P><P>By,</P><P>Jeevan</P></BODY></HTML> Tue, 30 Sep 2008 11:47:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557201#M1075797 Former Member 2008-09-30T11:47:17Z Re: save data https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557202#M1075798 <HTML><HEAD></HEAD><BODY><P>hello</P><P>'use modify instead of insert...</P><P>tell me wat error it shows</P></BODY></HTML> Tue, 30 Sep 2008 11:52:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557202#M1075798 Former Member 2008-09-30T11:52:00Z Re: save data https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557203#M1075799 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Try for the Modify </P><P> MODIFY tablename FROM TABLE iinternal table .</P><P>Regards,</P><P>Bharani</P></BODY></HTML> Tue, 30 Sep 2008 11:58:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557203#M1075799 BH2408 2008-09-30T11:58:00Z Re: save data https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557204#M1075800 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Modify Comment Using stored value are 0</P><P></P><P></P><P>By,</P><P>Jeevan</P></BODY></HTML> Tue, 30 Sep 2008 12:02:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557204#M1075800 Former Member 2008-09-30T12:02:17Z Re: save data https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557205#M1075801 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Modify Comment Using stored value are 0</P><P></P><P></P><P>By,</P><P>Jeevan</P></BODY></HTML> Tue, 30 Sep 2008 12:02:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557205#M1075801 Former Member 2008-09-30T12:02:39Z Re: save data https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557206#M1075802 <HTML><HEAD></HEAD><BODY><P>modify do both update and insert according to the condition</P><P></P><P>can u tell me wat error it shows when you run the program.</P></BODY></HTML> Tue, 30 Sep 2008 12:05:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557206#M1075802 Former Member 2008-09-30T12:05:48Z Re: save data https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557207#M1075803 <HTML><HEAD></HEAD><BODY><P>ANS</P></BODY></HTML> Wed, 26 Nov 2008 05:32:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/save-data/m-p/4557207#M1075803 Former Member 2008-11-26T05:32:29Z