‎2009 Mar 30 2:45 PM
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.
‎2009 Mar 30 4:14 PM
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
‎2009 Mar 30 3:07 PM
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
‎2009 Mar 30 3:27 PM
‎2009 Mar 30 3:42 PM
‎2009 Mar 30 4:14 PM
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