topic Re: modify insert or update statement not working for multiple records in Application Development and Automation Discussions

modify insert or update statement not working for multiple records

Former Member — Wed, 27 Jul 2016 05:31:52 GMT

Hi All,

I am trying to insert some data into a custom data. This table has no primary key ( except MANDT ).

I tried using modify, insert and update statement , but it is not working.

Only the last record in updated in the table.

Please let me know how this can be corrected ?

1. MODIFY zifrsadj FROM TABLE it_tc1.

COMMIT WORK.

LOOP AT it_tc INTO wa_tc.

wa_tc1-fyear = p_year.

wa_tc1-period = p_period.

wa_tc1-hkont = wa_tc-hkont.

* INSERT INTO zmonthadj VALUES wa_tc1.

MODIFY zmonthadj FROM wa_tc1.

CLEAR : wa_tc, wa_tc1.

ENDLOOP.

LOOP AT it_tc INTO wa_tc.

wa_tc1-fyear = p_year.

wa_tc1-period = p_period.

wa_tc1-hkont = wa_tc-hkont.

* INSERT INTO zmonthadj VALUES wa_tc1.

CLEAR : wa_tc, wa_tc1.

ENDLOOP.

Regards

Meenakshi

matt — Wed, 27 Jul 2016 05:44:18 GMT

If "This table has no primary key ( except MANDT )." then it can only contain one record per client. Your program is working absolutely correctly.

This is very basic - I think you should re-read your course notes on data dictionary and ABAP programming.

former_member252719 — Wed, 27 Jul 2016 05:52:26 GMT

Hi,

Try to define Primary key fields along with MANDT.

Thanks.

Former Member — Wed, 27 Jul 2016 05:52:31 GMT

This message was moderated.

former_member258661 — Wed, 27 Jul 2016 06:17:46 GMT

The table include just 1 row which there are not any primary key ( expect MANDT ),