Adding New field in a Table

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi,

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

Regards,

Klaus

[Former Member]

Hi,

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

[Former Member]

And be sure to check "save data".

Rob

[nabheetscn]

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

Thanks

Nabheet

[Former Member]

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

[Former Member]

hi,

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

Sulabh

[Former Member]

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

Regards

Mona

[jayanthi_jayaraman]

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.