topic Re: purpose of modify statement in Application Development and Automation Discussions

purpose of modify statement

Former Member — Wed, 19 Sep 2007 16:59:12 GMT

MODIFY ymtid_tab FROM TABLE itab.

what will the above statement do, considering ymtid_tab is a custom database table and itab is an internal table.

Re: purpose of modify statement

Former Member — Wed, 19 Sep 2007 17:03:08 GMT

It will update the database table with the values in internal table

Also click F1 in your modify statement and see SAP help for details

Message was edited by:

ANIRUDDHA DAS

Re: purpose of modify statement

RichHeilman — Wed, 19 Sep 2007 17:04:25 GMT

This statement will update all records of database table YMTID_TAB where the key fields match the records in ITAB.

Regards,

Rich Heilman

Re: purpose of modify statement

JozsefSzikszai — Wed, 19 Sep 2007 17:06:48 GMT

hi vivek,

thi statement will add the entries from itab to DB table ymtid_tab. If any of the entries are already in the table (acc. to table key), it will change them.

Re: purpose of modify statement

former_member249594 — Wed, 19 Sep 2007 17:07:13 GMT

Hi vivek vangala

itab should have the same structure as ymtid_tab so that they will have the same key field

if a record in ymtid_tab have the same table key as the record in itab, then this record in ymtid_tab will be modified(non-key field value is changed as the value in itab)

if no record in ymtid_tab have the same table key as the record in itab, then record of itab will be insterted in ymtid_tab.

Re: purpose of modify statement

Former Member — Wed, 19 Sep 2007 17:07:45 GMT

hi,

Modify statment will work both insert and Update..

Modify ymtid_tab FROM TABLE itab.

if you are changing non primary key,then it works like update..

if you are creating new record then it works like insert command.

when a record is found then modify works like update and saves that changes to internal table with new record.

if it didnt found any record then it appends a record at the end of internal table with given data.