02-27-2007 11:06 PM
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.
02-27-2007 11:45 PM
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
02-27-2007 11:08 PM
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
02-27-2007 11:31 PM
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.
02-27-2007 11:45 PM
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
02-28-2007 12:24 AM