topic Re: Changeing the data in Application Development and Automation Discussions

Changeing the data

Former Member — Tue, 27 Feb 2007 23:06:01 GMT

In the Module pool program, Create, change, delete options are there to enter data in to a custom table.

Create and Delete are working fine.

With the change option table is having 2 lines of data one with changed data and other with unchanged data.

Can you please help me, what I am doing wrong here.

EX:

Customer Customer Cust Rsn

Number Name Code Code

1012 Wal Mart Stores, Inc 024 003

1012 Wal Mart Stores, Inc 025 003

1012 Wal Mart Stores, Inc 444 003

I tried changing CUSTCODE 025 as 444, know I have both.

Thanks,

Veni.


CASE OK_CODE.
    WHEN 'SAVE'.
      CLEAR OK_CODE.
      WA-KUNNR = ZRCODE-KUNNR.
      WA-CCODE = ZRCODE-CCODE.
      WA-RSTGR = ZRCODE-RSTGR.
      INSERT INTO ZRCODE VALUES WA.
      CLEAR: WA, ZRCODE.

    WHEN 'DELE'.
      WA-KUNNR = ZRCODE-KUNNR.
      WA-CCODE = ZRCODE-CCODE.
      WA-RSTGR = ZRCODE-RSTGR.
      DELETE ZRCODE FROM WA.
      CLEAR: WA, ZRCODE.

    WHEN 'CHAG'.
      CLEAR OK_CODE.
      WA-KUNNR = ZRCODE-KUNNR.
      WA-CCODE = ZRCODE-CCODE.
      WA-RSTGR = ZRCODE-RSTGR.
      MODIFY ZRCODE FROM WA.
      CLEAR: WA, ZRCODE.

Re: Changeing the data

Former Member — Tue, 27 Feb 2007 23:08:04 GMT

Hi,

Try Instead of MODIFY use UPDATE..

UPDATE ZRCODE FROM WA...

Because MODIFY will insert record if the key value is not found..

Thanks,

Naren

Re: Changeing the data

Former Member — Tue, 27 Feb 2007 23:31:03 GMT

Hi Naren,

I tried with Update and key value is also in the system, again I am having 2 entries.

Please help me.

Thanks,

Veni.

Re: Changeing the data

Former Member — Tue, 27 Feb 2007 23:45:55 GMT

Hi,

Okay...what are the keys to the table..You can also try this..

UPDATE ZRCODE SET RSTGR = WA-RSTGR

WHERE KUNNR = WA-KUNNR

AND CCODE = WA-CCODE.

Thanks,

Naren

Re: Changeing the data

Former Member — Wed, 28 Feb 2007 00:24:50 GMT

Thankyou Naren!

Regards,

Veni.