topic Re: Adding New field in a Table in Application Development and Automation Discussions

Adding New field in a Table

Former Member — Tue, 19 Oct 2010 11:52:51 GMT

Hello Experts,

I have created a table. I have 3 fields in that table and i hav used that table for 2 months. Now i have added a

new field( FLAG Field ) values will be 'X' or Blank. Now when i am using a select query on this table in where condition if i am using Flag = ' ' , it is not considering the old records it is fetching values from the day i have added the new field, Kindly provide me a solution

Thanks & Regards,

Kams.

Re: Adding New field in a Table

Former Member — Tue, 19 Oct 2010 11:59:58 GMT

Hi,

then you forgot to set the INITIALIIZE flag for your new field in SE11.

Regards,

Klaus

Re: Adding New field in a Table

Former Member — Tue, 19 Oct 2010 13:26:49 GMT

Hi,

After extending the table, SE14 must be executed as well. Have you executed the SE14 ?

Re: Adding New field in a Table

Former Member — Tue, 19 Oct 2010 13:44:01 GMT

And be sure to check "save data".

Rob

Re: Adding New field in a Table

nabheetscn — Tue, 19 Oct 2010 17:10:31 GMT

Kindly use Se14 to to adjust your table and save your all records.

Thanks

Nabheet

Re: Adding New field in a Table

Former Member — Sun, 07 Nov 2010 05:31:59 GMT

U can do it by 2 ways...

1) To manually enter the flag field values

2) Use Se14 to to adjust your table and save your all records

Re: Adding New field in a Table

Former Member — Wed, 10 Nov 2010 04:25:03 GMT

hi,

for this go in se14 database utility or make a bdc program and update ur flag.

Sulabh

Re: Adding New field in a Table

Former Member — Wed, 10 Nov 2010 05:44:44 GMT

Hi You have to activate and adjust the data base table from the utility menu.

Regards

Mona

Re: Adding New field in a Table

jayanthi_jayaraman — Wed, 10 Nov 2010 05:47:16 GMT

Hi,

For fetching old values, you should use flag is null. But new blank values will be fetched flag = ''. So use both flag = ' ' or flag is null.