Using the Table Collection 

Purpose

The table collection contains data from the R/3 System that you can include in your office application.

Prerequisites

Before proceeding, you must create the central instance control for managing Office Integration. Refer to Instance for Managing Desktop Office Integration.

Process flow

1. Declare an instance with reference to the interface i_oi_table_collection:

DATA table_coll TYPE REF TO i_oi_table_collection.

2. Use the method get_table_collection on the central object for Desktop Office Integration control to create an instance for the table collection.

3. Use the methods add_table and add_table_by_url to add data to the table collection.

4. Read and change the table collection data in the desktop application using Visual Basic to access it.

5. Use the methods get_table and get_table_by_url to read data from the desktop application back into the R/3 System.

6. Delete the contents of the table collection using the methods remove_table and remove_all_tables.

Remember that you should include error handling after each method call.

Any parameters not contained in the individual method descriptions are listed under Generic Parameters.

The following example shows how you can access data in the table collection using a Visual Basic program.