Adding new field in a custom table.

[Former Member]

Hi gurus,

I have a problem adding a new field into a custom table.

I added a new non-primary field to a custom table as the last field(type char10). the custom table already has some entries in it. I went into SE14 and adjusted the table and also re-generated the table maintenance generator.

In a custom program i am using this custom table to fetch the data. I am selecting data from custom table with the new field in the WHERE clause of SELECT. Even though the custom table has data in it,satisfying the condition, but it is not populating the data into the internal table.

Please advise on this.

[Former Member]

I think problem is with your SELECT statement.

Please write your select statement.

[Former Member]

Hi Anand,

If the select statement is correct, check the internal table structure. have you added the new field in the structure?

Cross check points:

1. From SE11, if you are getting the entries for the new field, from the select statement should work fine.

2. Check the internal table structure or define the internal table as: data itab type standard table of <custom table>.

Regards,

Shiva.

[Former Member]

Have you added values in the new field of the table?

[Former Member]

Hi,

What is the condition you have added in WHERE clause on the new feild.

The problem might be with the WHERE clause of SELECT query or the fileds in the internal table.

Write the SELECT query as well as the internal table declaration to probe further.

[Former Member]

Hello Anand,

I think if select querry is correct then please use conversion_exit_alpha_input befor saving the data in custom table and same use before retreving the data.

[SujeetMishra]

Hello Anand,

Is there data available in your added new field?? if yes then send your code

so that i can give you the solution.

Regards.

Sujeet

[Former Member]

Hi Anand,

Please check the if the INITIAL check box for the new field is set. In your case; since some records already exist; the values for the added field will be set as NULL. So the select statement won't return any records. If you set INITIAL, it would rather be treated as SPACE.

Thanks,

Ranjith