topic Re: how to refresh old data in Application Development and Automation Discussions

how to refresh old data

Former Member — Wed, 25 Jan 2006 06:26:46 GMT

original table has column A, now add column B, right now is input A , B will automatically show up. but old data will have B blank, how to make the old data have B automatically refreshed.

thanks kitty

Re: how to refresh old data

abdul_hakim — Wed, 25 Jan 2006 06:31:35 GMT

Can you explain your question more clearly.

If you want to refresh an itab then u can use

REFRESH itab.

Abdul

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 06:32:15 GMT

To set e default value,

UPDATE table SET b = value WHERE b IS INITIAL.

Is that what you want?

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 06:38:21 GMT

you have to match the value of col a and col b manually and update the table

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 06:47:41 GMT

Hi,

Use Delete and in the condition where column B = Space

it will work ..

Regards,

PAVAN.

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 06:49:34 GMT

Hi kitty,

1. The old data of B will NOT GET

automaticlly refreshed.

2. Either one needs to etner it via SM30

3. OR

4. Make a new program.

USE THIS KIND OF LOGIC :

*----

Get all B Blank Records

select * from DBTAB into table ITAB.

where B is initial.

*----

Get the value of B from SOURCE TABLE

Loop at ITAB.

select single FIELD

into itab-B

from sourcetable

where primarykey = itab-A.

*----

update in DBTAB

MODIFY dbtab FROM itab.

endloop.

regards,

amit m.

Message was edited by: Amit Mittal

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 06:56:23 GMT

what's your meaning 'manual matech a and b'.

thanks kitty

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 06:56:39 GMT

itab_tmp[] = itab[]

sort itab_tmp .

loop at itab.

read table itab_tmp with key field_a = itab-field_a

binary search.

if sy-subrc = 0 and itab-field_b is initial.

delete itab where field_a = itab_tmp-field_a.

endif.

endloop.

this also works ..

Regards,

PAVAN..

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 06:57:36 GMT

could you pls further explain how to do in SM30? thanks kitty.

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 07:00:46 GMT

Open your table in SE11.

Go to menu Utilities -> Table Maintenance Generator

and create the table maintenance prog.

Now go to SM30 and open your table amd maintain. You can do the changes / insert data to your tables here.

Ps: Reward points if helpful.

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 07:04:48 GMT

I have sm30, but the question is how to update old data.

and you said to create table maintenance prog. where ?

thanks kitty

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 07:09:26 GMT

The table maintenance generator creates the maintenance program for you.

After which you may use SM30 for Table maintenance.

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 07:12:37 GMT

yes, can maintain and insert new record, but how about the old one, you only indicate the normal procedure, but I need get the old data updated.need a program to update?

thanks kitty

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 07:15:11 GMT

Yes then, you may use a program to update like,

Update table SET field1 = value WHERE field1 IS INITIAL.

This updates all the INITIAL VALUES to a constant value.

You may also use logical condition to update values differently for a specified value in other field.

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 07:19:04 GMT

select cola colb into table itab from <table>.

loop at itab.

if itab-colb is initial.

update <table> set colb = value.

endif.

endloop.

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 07:25:09 GMT

but this is not set to a constant value, the data in B will be displayed automatically as input A.

thanks kitty

Re: how to refresh old data

Former Member — Wed, 25 Jan 2006 07:27:32 GMT

but this is not set to a constant value, the data in B will be displayed automatically as input A.

thanks kitty