Create tables using AET

There are many approaches  . 

1) Rapid Development feature of EhP1 

2) AET Table enhancement feature of EhP1.

If its just creating a table view, even the BOL wizard feature can be used,

I will cover AET in this blog . 

For a table enhancement, UI elements are generated that have to be stored in a UI component.

Before you can create a table enhancement, you have to create at least one UI component by using transaction AXTSYS. 

Start transaction AXTSYS in SAP GUI and create at least one UI component as a container for the generated UI elements.

You can use the Application Enhancement Tool to add tables that include new fields to an object. You can enable the expert mode to adapt some of the technical settings, for example, data element and technical field names.

Prerequisites

There are applications that require that you activate a business function to make the functions for table enhancements available. For more information, see SAP Note 1448299.

You have enabled the configuration mode in the general settings on the central personalization page of the WebClient UI.

You need to generate a UI component in Customizing for UI Framework under  UI Framework Definition Application Enhancements Define System Settings . You can however create several UI components and set one UI component as default. These UI components are available in the search help of the Component field.

Procedure

1. Create a new table

1. Start the WebClient UI and select the application that you want to enhance.
2. Start the page configuration in the application.
3. Choose the Display Enhancements pushbutton to display or create a new table.
    Note

   You can also click Create Table if you want to directly create a new table. However, you cannot enable or disable the expert mode if you do this.
4. Enable or disable the expert mode.
5. Choose the New pushbutton in the Tables block.

2. Select an object part

1. Select a valid package. The namespace is automatically derived from the package name.
    Note

   You can select a package only if you have enabled the expert mode beforehand.
2. Select an object part in which the new table is available, for example, header, item, and so on.

3. Enter the details of the new table

You enter the details of the new table in the Table Details dialog box. Once you have created a new table in theTables block, the enhancement ID and the table ID are automatically generated.

1. Enter the new table name in the Description field.
2. In the Relationship field, you can choose one of the following relationships:
   • 1: N Table View
     This relationship specifies that the table contains an unlimited number of entries.
   • 1: 1 Form View
     This relationship specifies that the table contains one entry for every parent object.
     You can make the table fields available in the form view of the parent object.
      Note

     1:1 relationships can be used instead of fields to prevent the main application tables are being overloaded, especially if the fields are rarely used.
3. In the Component field, you can choose a UI component.
4. In the Window field, you can enter a name for the window.
   The window belongs to the UI component, in which you create the new table. The window name needs to be unique.

 Note

If you have enabled the expert mode beforehand, you can change the table ID.

4. Select or deselect the generation checkbox

The Generate checkbox indicates that you want to generate a table. The checkbox can be selected or deselected in the Tables block or in the Table Details dialog box. This checkbox is selected by default for new and changed tables. If you want to exclude a table from generation, you need to deselect the checkbox.

5. Add new fields to the table

You can add fields to the new table. In the Table Details block, choose the Add pushbutton in the Table Fieldsblock. You can select the Logical Key checkbox if you want to assign a logical key to the new field in the table. For more information, see Adding Fields.

In a table, you have to define at least one field that is not a calculated field. For more information, see Calculated Field.

6. Save and generate the new table

For more information, see section “Saving and Generating the Field” at Adding Fields.

7. Make the new table available on the UI

After the WebClient UI has been restarted, select the application and start the page configuration of the application, to make the new table available on the user interface. If you have started the Application Enhancement Tool from the UI Configuration Tool, you can return to the UI Configuration Tool, by choosing the Back pushbutton, and add the new table to the UI configuration before you restart the WebClient UI.

 Note

Tables that you have added to a business object might also appear in the Available Assignment Blocks list of a page configuration that is associated with another enhanced business object, if these business objects have the same enhancement place. However, at runtime only the tables created for the rendered enhancement object is displayed. If you want to display these tables at runtime, you can add them as reusable tables.