Integrate

Verify the Tables and Views were Created in SQL by the Auto Generate Process for an RFC

Review the steps to post data using an RFC.

If the Auto Generate Database Objects feature was used, confirm that database objects were created.

NOTE: This use case provides an example of posting using the RFCBOA/ZRFC_READ_TABLE – External access to R/3 tables via RFC, but does not supply comprehensive instructions to suit all RFCs.

Access the SQL database to view the views and tables Integrate created during the auto-generation process.

  1. Log in to SQL Management Studio.
  2. Locate the database assigned to the process.

  3. Locate the views and tables created in the database.

    NOTE: Integrate creates tables and views in the database for all process template loops for a process, including download tables that contain the unique identifier Posting ID for those loop s that contain download fields. It names the tables tt[Process Name][Template Name][Loop Name]_Upload and tt[Process Name][Template Name][Loop Name]_Download. The View Name for each process template is tx[Process Name] [Template Name] [Loop Name]Int.

  4. Open the Download tables in Design mode and verify that each has a PostingID column.
  5. Open the table created for the primary loop.

  6. Add records to the table. In the example, the following fields were populated.

    • ID – Leave blank as this will be auto-created.
    • Cross_Client – Enter a single space
    • Delimiter – Enter |
    • No_Data – Enter a single space
    • Query_Table – Enter T001W
    • Rowcount – Enter 0

    • Rowskips – Enter 0

      In the example, the step above is repeated for Query_Table – KNA1.and for Query_Table – TVKO.

  7. Close the table.