topic Re: Errors while activating database table. in Application Development and Automation Discussions

Errors while activating database table.

Former Member — Mon, 19 May 2014 07:45:45 GMT

Hi all,

I have added zfields(ztz_stceg and zz_mwsk1) to database table using append structure.

while trying to save i am getting errors.

I am attaching the picture, please suggest me why those errors are coming.

Thanks & regards,

NarsiReddy.

Re: Errors while activating database table.

pavanm592 — Mon, 19 May 2014 07:59:51 GMT

Hi,

In Error Description it is given as your using enhancement category as "can be enhanced charecter or numeric " try to use "Can Be Enhanced Deep"

Regards,

Pavan

Re: Errors while activating database table.

former_member192854 — Mon, 19 May 2014 08:01:46 GMT

Hi Cheruku,

Because when you check SE11, in menu Extra -> Enhancement category, you will see that it states Only extendable via numbers, characters. I think you attached a structure or a string, which is not applicable to this extension preference.

So you can change the extension type, or add the fields - no strings, xstrings etc. - to the table structure directly.

Best,

Sander

Re: Errors while activating database table.

Former Member — Mon, 19 May 2014 08:02:38 GMT

Hi,

In SE11, open your table in change mode and got menu Extras-> Enahncement Category...

click and reset as below.

if your table is one level then set the enhancement category set as using option " can be enhanced(character type or numeric type)" and if your table using deep structure or table then use option " can be enhanced (deep)" option.

Please try.

Regards,

Prasenjit

Re: Errors while activating database table.

satyabrata_sahoo3 — Mon, 19 May 2014 08:08:38 GMT

Change its enhancement type and adjust/activate database from SE14.

Re: Errors while activating database table.

former_member192854 — Tue, 20 May 2014 09:22:08 GMT

Solved?

Re: Errors while activating database table.

RaymondGiuseppi — Tue, 20 May 2014 09:31:37 GMT

When you create an append structure, perform some where-used to get list of structures that will be impacted, your new include must

not be more enhance-able that any table or structure which contains it
only contains fields of types allowed in those structure

Regards,

Raymond

Re: Errors while activating database table.

Former Member — Tue, 20 May 2014 09:39:32 GMT

Hi Raymond,

I am appending my fields to a old structure which already present there.

I am using the type CHAR which is used for old fields in structure.

Thanks & regards,

NarsiReddy.

Re: Errors while activating database table.

RaymondGiuseppi — Tue, 20 May 2014 09:59:49 GMT

Then look in one/some of the not-activated objects for another Include with a wrong "Deep" enhancement mode, as most of those tables/structures only allow "Numeric or character" enhancement.

Regards,

Raymond