The activation type is not relevant for database tables in application programming. In these tables,
the default value 00 can be kept. In the default setting, a database table can be activated interactively in the ABAP Dictionary tool.
The following values for the activation type only apply to those database tables required by the ABAP runtime environment itself (and hence only to internal SAP developments):
Activation type 01
The runtime object of the database table must be created using an
ABAP kernel program before the
table is activated in ABAP Dictionary. This may make it impossible to modify and activate important system tables directly.
Activation type 02
The database table is used in the ABAP
kernel, but the runtime object can be activated (and hence created) in ABAP Dictionary. It may be necessary to adjust the consumer program of the kernel. This is indicated by a note in the activation log.
Activation type 10
The database table is required before other objects are modified as part of a transport.