To construct a table set

This topic describes how you create and fill a table set that you can use to define a suitable table sharing configuration. You can subsequently implement this table sharing configuration by using table linking or data replication.

The construction of a table set is an iterative process. You start with a table set with a few tables based upon a functional sharing requirement. Then, you repeatedly verify the table set and add the tables that must be shared for technical reasons. For technical details, refer to the Reference Guide for Multicompany Structures.

Alternatively, you can import the current table linking situation into a table set, to identify or to diagnose problems. For more information, refer to To analyze the present table linking configuration.

Prerequisites

Before you define a table set, you must specify the relevant package combination(s) and companies. For more information, refer to To specify relevant package combinations and companies.

Procedure to construct a table set

To construct a table set:

  1. Start the テーブルセット (tltsm1100m000) session.
  2. Click New to start the テーブルセット (tltsm1100m009) session. Add a new table set.
  3. Use the パッケージコンビネーション別テーブルセット (tltsm1150m000) session to link the table set to a package combination. LN uses the link with the package combination to determine which references are active for this software version.
  4. Fill the table set with tables. In the テーブルセット (tltsm1100m009) session, complete one or more of these steps:
    • To add tables manually, on the Lines menu, select New Table. You can add tables individually or add entire modules, from which you can exclude specific tables.
    • To copy tables from an existing table set, on the Specific menu, select Copy Tables From Other Table Sets. For more information, refer to Predefined table sets.
    • To add a range of tables or a range of modules, on the Specific menu on the Tables by Table Set tab, select Copy from DD.
    • To use the current table linking configuration (logical tables) as a starting point, on the Specific menu on the Tables by Table Set tab, select 論理テーブルのインポート.
  5. Click Verify Shared Logical Tables.
  6. Click Table Sharing Exceptions. (If the 高速検証 check box in the テーブル共有パラメータ (tltsm0100m000) session is selected, the テーブル共有例外 (tltsm2100m000) session is started automatically when you verify the table set).
  7. Assess the exceptions found. For a graphical view, click 関係ツリーを表示. Check for exceptions with status 有効.

    You can respond to an identified exception in one of these ways:

    • 受入
      If you accept an exception, the 例外の状況 turns to 承認済. The exception will no longer block a table sharing set from being made actual.
    • 修正
      If you correct an exception, LN adds the reference table that produced the exception to the table set and removes the exception from the list.
  8. Repeat previous steps until all remaining exceptions have the 承認済 status.
  9. In the テーブルセット (tltsm1100m009) session, set the 状況 field to 承認済. (If you need to modify the table set later, you can change its status back to ドラフト).

For more information on table sharing, see the Infor LN テーブル共有ユーザガイド.

Related topics