topic update problem in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/update-problem/m-p/6642987#M1443716 <HTML><HEAD></HEAD><BODY><P>hi gurus....</P><P></P><P></P><P></P><P>as i use below code for update fields in sales order which the user enter in selection screen.. for that i update VBAK table...</P><P>instead of update that particular sales order it update all sales order by shipment value....</P><P></P><P>my requirement is the shipment number which is associated with particular sales order i want to update that sales order...</P><P>please suggest me the solution...</P><P></P><P></P><P></P><P>SELECT TKNUM</P><P> ZZARLINENM1</P><P> ZZARLINENO1</P><P> ZZARLINENM2</P><P> ZZARLINENO2</P><P> ZZARLINENM3</P><P> ZZARLINENO3</P><P> ZZARLINENM4</P><P> ZZARLINENO4</P><P></P><P> FROM VTTK INTO CORRESPONDING FIELDS OF TABLE IT_VTTK</P><P> WHERE TKNUM IN S_DOC.</P><P></P><P> SELECT TKNUM</P><P> VBELN</P><P> FROM VTTP INTO CORRESPONDING FIELDS OF TABLE IT_VTTP</P><P> WHERE TKNUM IN S_DOC.</P><P> </P><P> IF IT_VTTP[] IS NOT INITIAL.</P><P> SELECT VBELN</P><P> VGBEL</P><P> FROM LIPS INTO CORRESPONDING FIELDS OF TABLE IT_LIPS</P><P> FOR ALL ENTRIES IN IT_VTTP</P><P> WHERE VBELN = IT_VTTP-VBELN.</P><P> ENDIF.</P><P></P><P> IF IT_LIPS[] IS NOT INITIAL.</P><P></P><P> SELECT VBELN</P><P> FROM VBAK INTO CORRESPONDING FIELDS OF TABLE IT_VBAK</P><P> FOR ALL ENTRIES IN IT_LIPS</P><P> WHERE VBELN = IT_LIPS-VGBEL.</P><P> ENDIF.</P><P></P><P> LOOP AT IT_LIPS.</P><P></P><P> READ TABLE IT_VTTP WITH KEY TKNUM = IT_VTTK-TKNUM.</P><P> IF SY-SUBRC = 0.</P><P></P><P> READ TABLE IT_LIPS WITH KEY VBELN = IT_VTTP-VBELN.</P><P> IF SY-SUBRC = 0.</P><P></P><P> READ TABLE IT_VBAK WITH KEY VBELN = IT_LIPS-VGBEL.</P><P> IF SY-SUBRC = 0.</P><P></P><P> UPDATE VBAK SET</P><P> ZZAIRLINENAME1 = IT_VTTK-ZZARLINENM1</P><P> ZZAIRLINENO1 = IT_VTTK-ZZARLINENO1</P><P> ZZAIRLINENAME2 = IT_VTTK-ZZARLINENM2</P><P> ZZAIRLINENO2 = IT_VTTK-ZZARLINENO2</P><P> ZZAIRLINENAME3 = IT_VTTK-ZZARLINENM3</P><P> ZZAIRLINENO3 = IT_VTTK-ZZARLINENO3</P><P> ZZAIRLINENAME4 = IT_VTTK-ZZARLINENM4</P><P> ZZAIRLINENO4 = IT_VTTK-ZZARLINENO4</P><P> WHERE VBELN = IT_LIPS-VGBEL.</P><P>COMMIT WORK.</P><P></P><P> ENDIF.</P><P> ENDIF.</P><P> ENDIF.</P><P></P><P> ENDLOOP.</P><P></P><P></P><P>kind regards</P><P>rahul</P></BODY></HTML> Wed, 10 Feb 2010 04:31:40 GMT Former Member 2010-02-10T04:31:40Z update problem https://community.sap.com/t5/application-development-and-automation-discussions/update-problem/m-p/6642987#M1443716 <HTML><HEAD></HEAD><BODY><P>hi gurus....</P><P></P><P></P><P></P><P>as i use below code for update fields in sales order which the user enter in selection screen.. for that i update VBAK table...</P><P>instead of update that particular sales order it update all sales order by shipment value....</P><P></P><P>my requirement is the shipment number which is associated with particular sales order i want to update that sales order...</P><P>please suggest me the solution...</P><P></P><P></P><P></P><P>SELECT TKNUM</P><P> ZZARLINENM1</P><P> ZZARLINENO1</P><P> ZZARLINENM2</P><P> ZZARLINENO2</P><P> ZZARLINENM3</P><P> ZZARLINENO3</P><P> ZZARLINENM4</P><P> ZZARLINENO4</P><P></P><P> FROM VTTK INTO CORRESPONDING FIELDS OF TABLE IT_VTTK</P><P> WHERE TKNUM IN S_DOC.</P><P></P><P> SELECT TKNUM</P><P> VBELN</P><P> FROM VTTP INTO CORRESPONDING FIELDS OF TABLE IT_VTTP</P><P> WHERE TKNUM IN S_DOC.</P><P> </P><P> IF IT_VTTP[] IS NOT INITIAL.</P><P> SELECT VBELN</P><P> VGBEL</P><P> FROM LIPS INTO CORRESPONDING FIELDS OF TABLE IT_LIPS</P><P> FOR ALL ENTRIES IN IT_VTTP</P><P> WHERE VBELN = IT_VTTP-VBELN.</P><P> ENDIF.</P><P></P><P> IF IT_LIPS[] IS NOT INITIAL.</P><P></P><P> SELECT VBELN</P><P> FROM VBAK INTO CORRESPONDING FIELDS OF TABLE IT_VBAK</P><P> FOR ALL ENTRIES IN IT_LIPS</P><P> WHERE VBELN = IT_LIPS-VGBEL.</P><P> ENDIF.</P><P></P><P> LOOP AT IT_LIPS.</P><P></P><P> READ TABLE IT_VTTP WITH KEY TKNUM = IT_VTTK-TKNUM.</P><P> IF SY-SUBRC = 0.</P><P></P><P> READ TABLE IT_LIPS WITH KEY VBELN = IT_VTTP-VBELN.</P><P> IF SY-SUBRC = 0.</P><P></P><P> READ TABLE IT_VBAK WITH KEY VBELN = IT_LIPS-VGBEL.</P><P> IF SY-SUBRC = 0.</P><P></P><P> UPDATE VBAK SET</P><P> ZZAIRLINENAME1 = IT_VTTK-ZZARLINENM1</P><P> ZZAIRLINENO1 = IT_VTTK-ZZARLINENO1</P><P> ZZAIRLINENAME2 = IT_VTTK-ZZARLINENM2</P><P> ZZAIRLINENO2 = IT_VTTK-ZZARLINENO2</P><P> ZZAIRLINENAME3 = IT_VTTK-ZZARLINENM3</P><P> ZZAIRLINENO3 = IT_VTTK-ZZARLINENO3</P><P> ZZAIRLINENAME4 = IT_VTTK-ZZARLINENM4</P><P> ZZAIRLINENO4 = IT_VTTK-ZZARLINENO4</P><P> WHERE VBELN = IT_LIPS-VGBEL.</P><P>COMMIT WORK.</P><P></P><P> ENDIF.</P><P> ENDIF.</P><P> ENDIF.</P><P></P><P> ENDLOOP.</P><P></P><P></P><P>kind regards</P><P>rahul</P></BODY></HTML> Wed, 10 Feb 2010 04:31:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/update-problem/m-p/6642987#M1443716 Former Member 2010-02-10T04:31:40Z Re: update problem https://community.sap.com/t5/application-development-and-automation-discussions/update-problem/m-p/6642988#M1443717 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P></P><P>You are looping at LIPS which is an delivery item list . Im not sure if this is the best solution to have a table update in this manner.</P><P></P><P>//instead of update that particular sales order it update all sales order by shipment value....</P><P></P><P>This is problem of duplicates i suppose in ur case. </P><P></P><P>Try to build the relation with delivery header table LIKP and check to have one sales order update .</P><P></P><P>Br, </P><P>Vijay.</P></BODY></HTML> Wed, 10 Feb 2010 04:40:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/update-problem/m-p/6642988#M1443717 Former Member 2010-02-10T04:40:38Z