topic Re: Modify DBTable in Application Development and Automation Discussions

Modify DBTable

Former Member — Mon, 28 Dec 2015 12:31:47 GMT

Hi All,

I try to modify or insert data to database table but the code just modify only 1 row.

I just added only 1 data to ztable.

Do you know why i cant add data to ztable.

Thanks for help.

LOOP AT IT_REPORT INTO WA_REPORT WHERE TEDARIK IS NOT INITIAL.

READ TABLE GT_TEDRK_TESM WITH KEY KUNET = WA_REPORT-KUNET

KUNWE = WA_REPORT-KUNWE

RMATNR = WA_REPORT-RMATNR

NAMET = WA_REPORT-NAMET

TARIH = WA_REPORT-TARIH

SFRTR_TX = WA_REPORT-SFRTR_TX.

IF SY-SUBRC IS NOT INITIAL.

MOVE-CORRESPONDING WA_REPORT TO WA_TEDRK_TESM.

INSERT ZPP_T_TEDRK_TESM FROM WA_TEDRK_TESM.

ENDIF.

ENDLOOP.

LOOP AT IT_REPORT INTO WA_REPORT WHERE TEDARIK IS NOT INITIAL.

READ TABLE GT_TEDRK_TESM WITH KEY KUNET = WA_REPORT-KUNET

KUNWE = WA_REPORT-KUNWE

RMATNR = WA_REPORT-RMATNR

NAMET = WA_REPORT-NAMET

TARIH = WA_REPORT-TARIH

SFRTR_TX = WA_REPORT-SFRTR_TX.

IF SY-SUBRC IS NOT INITIAL.

MOVE-CORRESPONDING WA_REPORT TO WA_TEDRK_TESM.

MODIFY ZPP_T_TEDRK_TESM FROM WA_TEDRK_TESM.

ENDIF.

ENDLOOP.

LOOP AT IT_REPORT INTO WA_REPORT WHERE TEDARIK IS NOT INITIAL.

READ TABLE GT_TEDRK_TESM WITH KEY KUNET = WA_REPORT-KUNET

KUNWE = WA_REPORT-KUNWE

RMATNR = WA_REPORT-RMATNR

NAMET = WA_REPORT-NAMET

TARIH = WA_REPORT-TARIH

SFRTR_TX = WA_REPORT-SFRTR_TX.

IF SY-SUBRC IS NOT INITIAL.

MOVE-CORRESPONDING WA_REPORT TO WA_TEDRK_TESM.

APPEND GT_TEDRK_TESM.

ENDIF.

ENDLOOP.

MODIFY ZPP_T_TEDRK_TESM FROM WA_TEDRK_TESM.

THANKS FOR YOUR HELP

Re: Modify DBTable

Ajit_K_Panda — Mon, 28 Dec 2015 13:04:16 GMT

Hi Erm,

The data will be modified based on key fields. It check with the key fields of structure to the database table and modifies accordingly. Please check the key fields.

And also Your question is not clear. If it doesnot help, make sure you give enough clarification or detail to understand your issue.

Regards,

Ajit

Re: Modify DBTable

shadab_maldar — Mon, 28 Dec 2015 13:19:47 GMT

Hi Erm,

What are the key fields in ztable.?

Regards,

Shadab.

Re: Modify DBTable

Private_Member_5521 — Mon, 28 Dec 2015 20:32:20 GMT

The INSERT command adds lines to the DB table as long as there are no duplicate keys present, if there are it will throw an ABAP DUMP.

The MODIFY command changes behavior depending on the existence or not of the record when comparing key fields:

If the key field values are already present in the table, it will change the record that exists in the table
If the key field values are new, then it will add that new record to the table.

In your code, you only do a straight insert in the first loop, the other two will most likely change the same existing DB record when finding the same key values.

Re: Modify DBTable

bauert — Tue, 29 Dec 2015 15:03:11 GMT

The last MODIFY statement is outside of the LOOP. Is that correct? This will Change the DB Data only with the last valid data from the LOOP.

Did you check already the sy-dbcnt?

Re: Modify DBTable

VenkatRamesh_V — Tue, 29 Dec 2015 17:02:25 GMT

Hi Erm,

Try,

Declare a internal table as like ztable.

Append the internal tables instead of updating ztable in loop.

Ater endloop.

MODIFY ZTABLE FROM TABLE it_upd. ( new internal table).

COMMIT WORK.

Hope it helpful,

Regards,

Venkat.

Re: Modify DBTable

Former Member — Wed, 30 Dec 2015 01:53:00 GMT

If inside the loop, Use MODIFY ztable from work_area TRANSPORTING field1 field2.

Outside loop, use MODIFY ztable From table it_table WHERE <condition>.