Start of Content Area

Procedure documentation Inserting New Fields  Locate the document in its SAP Library structure

Procedure

  1. In the maintenance screen for the table, place the cursor on the field in front of which the new field should be inserted and choose Insert line. You can append several new fields at the end of the table with New lines.

    2. An empty line appears in which you can insert the new field. Creating Tables. describes how to add a field to a table.

  2. Set the Init flag if the new field should be created in the database as NOT NULL.

    3. In this case the entire is scanned during activation and the new field is filled with the initial value. This can be very time-consuming for large tables.

    Key fields are always defined as NOT NULL. When a new key field is inserted, the primary index of the table is built again in the database.

  3. Choose This graphic is explained in the accompanying text.

Result

The new field is added to the table when it is activated in the database. This does not depend on the position of the new field in the field list of the table, that is the order of the fields in the ABAP Dictionary does not have to be the same as in the database.

Note

If the table is a check table of a foreign key, new key fields can only be appended to the previous primary key. When the table is activated, the foreign keys concerned are defined as generic with regard to the new key fields. The foreign keys changed in this way are listed in the activation log.

Caution

Inserting a client field results in a table conversion (see Adjusting Database Structures). The data in the table is copied to all the clients listed in client table T000.

If the table is a check table of a foreign key, it is not possible to insert a client field. In this case you must first delete the existing foreign keys.