topic Re: replace table entries in Application Development and Automation Discussions

replace table entries

Former Member — Tue, 13 Nov 2007 08:12:29 GMT

Hi,

I want to replace some old values with new values at table level.there are so many tables need to replace those values.that means i have 30 to 40 tables to replace.for this i want a report program .Can any one give me the idea.

Thanks in advance.

Re: replace table entries

Former Member — Tue, 13 Nov 2007 08:27:00 GMT

if you want to replace some standard table value then better option is to change it through Standard SAP Tcode so that it will automatically change the values in all corresponding tables...

if you want to change values in the custom table then design a report that will change these values

Re: replace table entries

Former Member — Tue, 13 Nov 2007 08:29:34 GMT

Those tables are not standard one.only custom tables.So I need a custom program.Can any one give me the idea about this program.

Re: replace table entries

Former Member — Tue, 13 Nov 2007 08:51:39 GMT

you need to select the data from the custom table make sure you select proper record from each table.... (compare all the key values)

make change in the record (i.e. in internal table) ... update the custom tables with these values

Re: replace table entries

Former Member — Tue, 13 Nov 2007 08:59:40 GMT

can u give me the brief coding for this.means i want table name in the selection screen.so table of type what?.

Re: replace table entries

Former Member — Tue, 04 Dec 2007 04:42:44 GMT

this code may help u out try it

loop at itabline.

zg8_ekpo-ebeln = zg8_ekko-ebeln.

zg8_ekpo-ebelp = itabline-ebelp.

zg8_ekpo-matnr = itabline-matnr.

zg8_ekpo-menge = itabline-menge.

zg8_ekpo-meins = itabline-meins.

zg8_ekpo-netpr = itabline-netpr.

zg8_ekpo-waers = itabline-waers.

*Update the entries into item table

modify zg8_ekpo.

endloop.

here itabline is an internal table and zg8_ekpo is the custom table so first get the the values u want to modify into an internal table and then move them into the custom table the modify statement will do the rest

reward points if found helpful.