Create an ABAP Table Type

1. Open your ABAP Cloud Project from the previous tutorial, then open the package in which you created the database table.

   

2. Select your package and choose New > Other ABAP Repository Object > Dictionary > Table Type from the context menu.

   

3. Enter a name and description and choose Next.

   

4. Create or assign a transport request and choose Finish.

The table type appears in a new editor.

Choose the category Dictionary Type For the type name, choose the database table you created in a previous tutorial, for example Z_BOOKING_XXX (replacing XXX with your group number or initials).

.

Note that, in the ABAP Environment, you can only work with whitelisted objects. The majority of tables you might expect, such as SFLIGHT are not whitelisted. For a complete list of whitelisted objects, see the folder Released Objects. To sort objects by object type, not package, use a Duplicate Tree:

1. You cannot define your own primary key for a standard table. First, change the access type to Sorted Table.

   

2. Change the Primary Key type to Key Components.

   

3. You can now choose the key fields from a drop-down list, by choosing Auto-complete (Ctrl+Space).

   

4. Choose each key field in turn:

   

This is for test purposes only. The access type you choose in real life affects performance. For more information, see:

• ABAP Keyword Documentation: Internal Tables, Selection of Table Category

• ABAP Examples: Internal Tables, Key Accesses

Users may want to query a database table using something other than the primary key. To enable this, create a secondary key.

1. First, select Secondary Key and choose Create… from the context menu:

   

2. Enter a name and choose the component(s) (or fields):

   

The keys are listed.

Finally, you will test your table type by using it to:

• define an internal table
• get database data into this table
• output the table content to the console

1. First create the ABAP Class, by selecting your package and choosing New > ABAP Class from the context menu:

   

2. Enter a name, such as ZCL_OUTPUT_BOOKINGS_XXX and description for your class (replacing XXX with your group number or initials).

   

3. Assign a transport request and choose Finish.

The class appears in a new editor.

You will now add the following code to the main method, remembering to rename the table type and database table to your own (for example, replacing XXX with your group number or initials)..

1. Create an internal table lt_bookings with the table type that you just created, ZTT_BOOKING_XXX.

   DATA: lt_bookings type ZTT_BOOKING_XXX.

2. Select data from the database table from the previous tutorial ZTBOOKING_XXX and add it to the internal table.

   select * from ZTBOOKING_XXX

   into table @lt_bookings.

3. Output the internal table to the console.

   out->write( EXPORTING

   data = lt_bookings

   name = 'Bookings:' ).

4. Then save and activate your class using Ctrl+S, Ctrl+F3.

Run your class in the console by choosing F9. Your output should look like this: