topic Re: MODIFY statement does not work in Application Development and Automation Discussions

MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 18:56:27 GMT

Hi,

I am using

MODIFY <DB Table> FROM TABLE <ITAB>.

ITAB has a single line that does not exist in DB table. But still it does not create a new record in DB table.

The sy-subrc is 0.

COuld some one please help me figure out why this is not working.

Thank you.

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 19:09:13 GMT

itab is the same structure/type as the database table? itab contains the client/mandt value? Always works for me...

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 19:12:32 GMT

'MODIFY' statement checks if there is an entry with the same primary key in the database table and makes corresponding changes. If the primary key value exists, it replaces, if not, it creates one. Make sure your primary key has proper values in internal table.

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 19:18:27 GMT

Hi,

I have the MANDT field in the table and ITAB.

ITAB is of the type as that of the internal table. So no type difference.

I have even tried specifying CLIENT SPECIFIED.

The sy-subrc is ZERO but this record does not get inserted...

Any thoughts...

Thank you.

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 19:24:12 GMT

A single line - are you sure it's in the table and not just the header?

Rob

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 19:26:55 GMT

Hi,

Try reading the itab into work area.

Then modify DB Tab from work area.

Regards,

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 19:40:49 GMT

F1 Help excerpt:

Alternative 2 ... FROM TABLE itab

Effect

If an itab internal table is specified, the system processes all lines in the internal table according to the rules for the wa work area. The line type of the internal table has to meet the requirements for use in Open SQL statements.

If the change to a line in the internal table would lead to a double entry in a unique secondary index, the corresponding line is not inserted and sy-subrc is set to 4. If the internal table is empty, sy-subrc is set to 0. The sy-dbcnt system field is always set to the number of lines that were actually processed.

Also check the sy-dbcnt?

Kind regards,

Robert

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 20:32:24 GMT

This is the code that I am trying to execute:

DATA: gt_temp LIKE TABLE OF ztemp,

wa_temp TYPE ztemp.

wa_temp-mandt = sy-mandt.

wa_temp-zplatformkey = 'AT'.

wa_temp-zplatformacctid = '597'.

wa_temp-lifnr = '0013650035'.

APPEND wa_temp TO gt_temp.

BREAK-POINT.

MODIFY ztemp FROM TABLE gt_temp .

BREAK-POINT.

This record does not exist in the table but still, it does not get updated.

SY-SUBRC is 0. SY-DBCNT is 1 and SY-TABIX is 1.

There is another keyfield which I am sending it as BLANK. There are entries with field as blank in the table, but we do not have this key combination record in the table.

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 20:39:06 GMT

BREAK-POINT.

MODIFY ztemp FROM TABLE gt_temp .

" add this:
COMMIT WORK.

BREAK-POINT.

Regards, Sebastian

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 20:43:24 GMT

If sy-subrc = 0 and sy-dbcnt = 1, then a record was created. Go to SE16 and search the table with

zplatformkey = 'AT'. There should be something there.

Rob

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 20:46:26 GMT

I had this in my mind, but I was like "NO NEED TO COMMIT AFTER A MODIFY TABLE" as I have never done this in my 5 years of ABAP development.

I was wrong...

Thank you Sebastian... COMMIT work helped...

But isnt this weird?????????????????

My apologies if I sound like a fool.. But I have never done a commit after a modify table in my life...

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 20:47:55 GMT

No Rob, no records in the table... COMMIT worked... really freaked out now..

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 20:53:16 GMT

WEre you looking at the table in SE16 after the break-point, but before the program finished??

Rob

Re: MODIFY statement does not work

Former Member — Thu, 03 Mar 2011 20:55:44 GMT

No Rob, I was very careful. I had a friend of mine look into this as well.

Any idea why I have to specify a COMMIT work explicitly?

Thank you.

Re: MODIFY statement does not work

former_member196064 — Fri, 04 Mar 2011 20:05:39 GMT

hmmm... I don't use Modify. I use Update <dbtabname> from <workarea>

Re: MODIFY statement does not work

former_member697508 — Wed, 24 Feb 2021 10:36:24 GMT

Thank you. That solved my issue as well.