topic Re: Table activation error in Application Development and Automation Discussions

Table activation error

Former Member — Thu, 12 Oct 2006 13:56:06 GMT

Hi,

We are implementing SRM 4.0

We want to add some customized fields for accounting information. To achieve this we have reffered to SAP note 672960. We have carried out all the steps mentioned in the note. One of the steps mentioned is

Use Transaction SE16 to include the user-defined fields that were defined in structure INCL_EEW_PD_ACC_CSF in table BBP_C_ACC_F.

In the "Z" append structure in structure INCL_EEW_PD_ACC_CSF we have added a field, ZZGL_FAVORITE, which is of line type (ie instead of a data element it refers to a structure, ZZSGL_CODES). When we activate the "Z" append structure we get the folowing error messages

1." TABL BBP_PDACC is inconsistent in active version"

2" Field ZZGL_FAVORITE: Structured type ZZSGL_CODES cannot be used in DB table BBP_PDACC "

3."Error in ALTER TABLE generation for table BBP_PDACC"

4."Table BBP_PDACC (Statements could not be generated)"

How can we rectify this error.

Thanks and Regards,

Jayesh

Re: Table activation error

Former Member — Thu, 12 Oct 2006 13:58:22 GMT

You can try to use database utilities trx SE14

Max

Re: Table activation error

Former Member — Thu, 12 Oct 2006 13:58:43 GMT

Instead of referring the structure directly, you have to

define each of the fields separately in the append structure. and then activate it.

Refer the link:

Regards,

ravi

Message was edited by: Ravi Kanth Talagana

Re: Table activation error

Former Member — Thu, 12 Oct 2006 14:00:05 GMT

Check the same is coming after doing activate and adjust database. utilities -> Database utiities -> Activate and adjust database.

Regards,

Prakash.

Re: Table activation error

Clemenss — Sat, 14 Oct 2006 13:23:35 GMT

the append structure should be compliant with the tables enhancement structure category:

Use menu-extras( or environment?)-Enhancement Category.

There is a radiobutton set for

- Can be enhanced(Deep)

- Can be enhanced, Character-Type or Numeric-Type

- Can be enhancedmChracter-Type

- Cannot Be Enhanced

- Not Classified

This Enhancement Category is new with 4.6. For many tables, SAP did not yet maintain it. Some tables are set to "Can be enhanced, Character-Type". Check if your append structure does not contain any data type not matching the category.

You may add one field after another, making a syntax check for each step. Finally you know which field causes trouble.

Regards,

Clemens