topic Re: sentence Modify in Application Development and Automation Discussions

sentence Modify

Former Member — Mon, 30 Mar 2009 13:45:07 GMT

Hi guys , i have a small technical doubt , i want to update a Z table with some registers using modify , i dont have the key of the table only some fields , in some cases if the register already exits i want to modify the register but in some cases even if the register exits i want to add new registers, which one is the best way (optimal) to do that? , thank you guys.

Re: sentence Modify

Former Member — Mon, 30 Mar 2009 14:07:26 GMT

hi ,

If registers is only the Primary key ..

the if you want to add another record with registers already exist it will not allow, it will allow to modify.

If registers is one of the Primary key ..

the if you want to add another record with registers already exist it will to add or modify.

Regards,

Dass

Re: sentence Modify

Former Member — Mon, 30 Mar 2009 14:27:49 GMT

Hi Prabhu,

Would like to share what registers are??

regards

sas

Re: sentence Modify

former_member156446 — Mon, 30 Mar 2009 14:42:23 GMT

hi how about hitting F1 on Modify statement in abap editor

Re: sentence Modify

former_member585060 — Mon, 30 Mar 2009 15:14:17 GMT

Use MODIFY statement, it does 2 operaions, both INSERT as well as UPDATE

If entry found with key, just update non key fields

If entry not found with key, it inserts new record.

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb35eb358411d1829f0000e829fbfe/content.htm

Regards

Bala Krishna