topic Re: Updating database table from an internal table in Application Development and Automation Discussions

Updating database table from an internal table

Former Member — Thu, 04 Oct 2007 12:46:21 GMT

Hi All,

I am updating a database table from an internal table.

I am changing the non-key fields in that table.

when I check sy-subrc = 4.

Record already exists, because I am changing non-key fields of the

database table.

Is there any addition like to accept the duplicate keys with update.

Alternatively, I have used Modify, It is adding new record,

Again, I have search the old record and use Delete on the database table.

Thanks & Regards,

Kalyan Chandramouli

SAP ABAP Consultant

Re: Updating database table from an internal table

RaymondGiuseppi — Thu, 04 Oct 2007 13:18:33 GMT

It seems that you changed key fields, else MODIFY wont create new records?

Look at your Z-table (I hope this is a Z-table, no?) is there an alternative index with unique key?

Regards

Re: Updating database table from an internal table

Former Member — Thu, 04 Oct 2007 13:25:12 GMT

HI,

You can use the UPDATE statment, but as we know, if the key fields are same then it will update that record, if the key fields are not same then it will add a record to the database table

Regards

Sudher

Re: Updating database table from an internal table

Former Member — Thu, 04 Oct 2007 14:09:07 GMT

Hi,

You are right, the field which I am trying to change is a part of primary key.

Because, sy-subrc = 4. says,

No line with specified primary key exits in the database table.

I have a Z-tabel, with Kunnr Vkorg Matnr Bzirk Bztxt Split_percentage

In this table primary key consists of KunnrVkorgMatnr+Bzirk.

I am able to change the Split_percentage using UPDATE.

Now, my client want to change Bzirk, Bztxt also in the table.

How can I Go.

Thanks & Regards,

Kalyan Chandramouli

SAP ABAP Consultant

Re: Updating database table from an internal table

RaymondGiuseppi — Thu, 04 Oct 2007 14:16:47 GMT

You can not update when changing primary key, so you need to delete the database from the <b>old</b> values of your internal table and then insert from the <b>new</b> values.

Regards

Re: Updating database table from an internal table

Former Member — Thu, 04 Oct 2007 15:11:20 GMT

Using Update we can change only non-key fields,

Kalyan Chandramouli

Re: Updating database table from an internal table

varma_narayana — Fri, 05 Oct 2007 06:19:21 GMT

This is the way to update ur Table in this Scenario.

From internal table to DB table.

data : itab type table of <ur Ztable> with header line.

<<Fill the Data into the itab>> . "Key fields must also be filled

UPDATE <ZTABLE> FROM TABLE ITAB .

REWARD IF HELPFUL.