topic Table update/ Modify poblem.... in Application Development and Automation Discussions

Table update/ Modify poblem....

Former Member — Thu, 19 Jun 2008 22:18:46 GMT

Hello,

I am trying to populate the custom table. Now after certain logic, I am using update statement as follows.

Loop.

WA_ZKEYSAP-KEYROLE = I_KEYROLE-KEYROLE.

WA_ZKEYSAP-ROLE = I_ROLE-ROLE.

UPDATE ZKEYSAPMAP FROM WA_ZKEYSAP.

ENDLOOP.

In every run the values of I_KEYROLE-KEYROLE and I_ROLE-ROLE but the table does not

get updated with a new line.

I want as following:

For example:

If in first loop run, the values of I_KEYROLE-KEYROLE = A and I_ROLE-ROLE =B,

then, table should have.

A...B

If in next run again the values are same as A and B for rescpective field then

no change in table

In third run if values are A and C, then table should get updated by A and C

Table will have final result like below.

A...B

A...C

Regards,

Rajesh.

Re: Table update/ Modify poblem....

former_member195698 — Thu, 19 Jun 2008 22:31:36 GMT

use MODIFY statement instead of Update.

Re: Table update/ Modify poblem....

Former Member — Thu, 19 Jun 2008 22:39:10 GMT

It doesn't work. See the more simplified program below:

TABLES: ZKEYSAPMAP, ZROLEMAP.

DATA: WA_ZKEYSAP TYPE ZKEYSAPMAP.

DATA: BEGIN OF I_KEYROLE occurs 0,

KEYROLE LIKE ZROLEMAP-KEYROLE,

TCODE LIKE ZROLEMAP-TCODE,

OBJECT LIKE ZROLEMAP-OBJECT,

FIELD LIKE ZROLEMAP-FIELD,

VALUE LIKE ZROLEMAP-VALUE,

END OF I_KEYROLE.

Select KEYROLE TCODE OBJECT FIELD VALUE from ZROLEMAP into table

I_KEYROLE.

WA_ZKEYSAP-KEYROLE = 'KR001'.

WA_ZKEYSAP-ROLE = 'KIS09'.

MODIFY ZKEYSAPMAP FROM WA_ZKEYSAP.

WA_ZKEYSAP-KEYROLE = 'KR002'.

WA_ZKEYSAP-ROLE = 'KIS10'.

MODIFY ZKEYSAPMAP FROM WA_ZKEYSAP.

Still only one line getting updated and the ultimate result is:

KR002....KIS10

Re: Table update/ Modify poblem....

Former Member — Thu, 19 Jun 2008 22:50:42 GMT

what is the key for this Ztable . Try making the two fields as key .

Re: Table update/ Modify poblem....

former_member195383 — Fri, 20 Jun 2008 04:54:19 GMT

Hi..

The problem is the first field(KEYROLE) is the primary key..So it cant have duplicate entries...

Hence its modifying the existing entry...instead of appending a new entry....Try making the 2nd field the primary key...Or declare another field and make it primary key....Then u will get appending entries...as u want...

Reward points if the above ans is useful...

Edited by: Rudra Prasanna Mohapatra on Jun 20, 2008 6:55 AM

Re: Table update/ Modify poblem....

GauthamV — Fri, 20 Jun 2008 05:06:00 GMT

hi,

try to use clear statement after ur first modify statement.