Show TOC

Using the Table CollectionLocate this document in the navigation structure

Use

The table collection contains data from the SAP system that you can include in your office application.

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

Process

  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 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 SAP system.

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

Note

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

Note

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

Example

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