Logical Tables (ttaad4120m000)

Use this session to specify logical tables. The logical tables have a different company number than the company number where the data is physically stored. It is often used in financial packages.

You can define table sharing in these ways:

Table Sharing Modeler
Logical Tables

When table sharing is not yet defined through the Table Sharing Modeler, you can use this Logical Tables session.

When table sharing is configured using the Table Sharing Modeler, do not use the current session to make changes. Verify if a Table Sharing Set exists with the Actual indicator selected. If the status is actual, use the Table Sharing Modeler (TSM) for any changes. This Logical Tables (ttaad4120m000) session is read-only and changes are not allowed.

Note: There is a work around: from the menu, select . A message is displayed recommending you to use the Table Sharing Modeler to modify the logical tables. However, it also provides the option to modify the logical tables in the Logical Tables (ttaad4120m000) session.

After modifying table sharing, you must synchronize the Table Sharing Modeler using the Table Sharing Sets (tltsm1115m000) session. From the Actions menu, select Import from Logical Tables. If you skip this step, the tenant cannot be upgraded. This is a mandatory action verified during preliminary upgrade checks.

You can specify the modules, the tables, and the physical company for a logical company. What you specify for a table has a higher priority than what you specify for all tables in a module.


Example
Logical Comp.	Table Selection	Table/Module	Physical Company
100	Tables in Module	tiitm	500
100	Specified Table	tiitm001	100
100	Specified Table	tccom000	500

The tables from the tiitm module of logical company 100 are physically stored in company 500, except for the tiitm001 table. The tccom000 table is also stored in company 500.

After specifying the data, you must convert the data to the runtime DD. The runtime data is stored in the $BSE/lib/compnr6.2 file.

Use the appropriate menu to:

Copy modules or tables from the data dictionary.
Rebuild the $BSE/lib/compnr6.2 file in the runtime data dictionary.

Note: You can also define a physical company equal to the logical company. This is useful when defining an exception for a particular table in a module.

Enable Editing of Logical Tables

Use this command only in case of emergencies to enable editing of the logical tables. Logical tables are updated by making a Table Sharing Set actual in the Table Sharing Modeler.

Use the Table Sharing Modeler to set up and maintain table sharing. Use this session only to check table relations at the table level.

Field Information

Logical Company

Specifies the company to which the table(s) belong. The data is physically stored in another company.

Table Selection

Specifies how the tables are assigned to the logical company.

Table/Module

Specifies the module or the table that is assigned to the logical company.

Physical Company

Specifies the physical company where the data of the specified table(s) is stored. The data is not stored in tables of the logical company.

The physical company may be equal to the logical company. Use this option to define exceptions for tables in a particular module, where all other tables in that module are linked to a physical company.