topic Re: Adding new field in a custom table. in Application Development and Automation Discussions

Adding new field in a custom table.

Former Member — Mon, 26 Oct 2009 12:26:46 GMT

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.

Re: Adding new field in a custom table.

Former Member — Mon, 26 Oct 2009 12:52:39 GMT

I think problem is with your SELECT statement.

Please write your select statement.

Re: Adding new field in a custom table.

Former Member — Mon, 26 Oct 2009 13:28:34 GMT

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.

Re: Adding new field in a custom table.

Former Member — Mon, 26 Oct 2009 13:37:46 GMT

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

Re: Adding new field in a custom table.

Former Member — Tue, 27 Oct 2009 10:40:07 GMT

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.

Re: Adding new field in a custom table.

Former Member — Tue, 27 Oct 2009 10:52:56 GMT

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.

Re: Adding new field in a custom table.

SujeetMishra — Wed, 28 Oct 2009 04:42:03 GMT

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

Re: Adding new field in a custom table.

Former Member — Thu, 29 Oct 2009 07:16:50 GMT

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