ABAP: Append structure to a table and status is “partially active”

Most often at customer sites one can get in trouble as they want to enhance a table and at times the length of table fields is more than what SAP supports and the appended structure is not activating fully in other words... "partially active" status.

The limit for field length mentioned is 4030 bytes as of basis release 620 SP25.

Even though it has partially active status we can add data and retrieve data from database but its flag an error "inconsistency persist".


In such situations the below tips can make life easy :

You can either execute report TOUCHTAB - Generate Program After Structure Changes in R/3 Repository to bump the limit whatever your database supports

OR

Change the DB Constants for Tables  using report RADTBCON.

Note:  As per SAP, "We recommend that you do not extend it any further than this. See note 636217. For detailed information, see note 355898 (Restrictions for transparent tables)".

Hope this helps.

Cheers,
Sandeep