hi,
Procedure
Go to change mode in the maintenance screen of the table where you want to add the append structure.
If the table contains a long field (data type VARC, LCHR or LRAW), you cannot add an append structure.
Choose Goto -> Append structures.
Either a dialog box appears in which you can enter the name of the append structure or a list of all the append structures. that were already created for the table appears. If append structures already exist, you have to choose to get the dialog box for entering the name.
Enter the append structure name and choose . The name must lie in the customer namespace.
You go to the field maintenance screen of the append structure.
Define the fields of the append structure. You can proceed as when creating a normal structure with two restrictions (see Creating Structures).
The fields of an append structure must lie in the customer namespace, that is the field names must begin with ZZ or YY. This prevents conflicts with fields inserted in the table by SAP.
An append structure must be flat, that is each field of the append structure must either refer to a data element or be directly assigned a data type, length, decimal places and short text.
If you want to create foreign keys or search help attachments for table fields that already exist, you can display these fields with Show appending objects. Proceed as if you wanted to create the foreign key or search help attachment in the underlying table (see Creating Tables).
If a foreign key or search help attachment is already defined for a field in the table, you cannot change this definition with the append structure.
Choose .
Result
The table will also be activated when the append structure is activated. The fields of the append structure are appended to the table in the database. Foreign keys or search help attachments for the fields that are already in the table and that were defined with the append structure are also activated.
You can display information about the activation process with Utilities -> Activation log. Errors occurring when the append structure is activated are displayed directly in the activation log.
Hope this helps, Do reward.
Bluesky
