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 defined through the Table Sharing Modeler, do not use Logical Tables session to make changes. Verify if a Table Sharing Set exists with for which the Actual indicator is selected. If the status is actual, then use the Table Sharing Modeler (TSM) instead for making changes. This Logical Tables (ttaad4120m000) session is made read-only and changes are not allowed.

Note: There is a work around. In the menu, select . A message is displayed that recommends you to use the Table Sharing modeler to modify the Logical Tables. But it offers also the option to still modify the Logical Tables through the Logical Tables (ttaad4120m000) session.

After making changes in the table sharing, you must make the Table Sharing Modeler consistent again through the Table Sharing Sets (tltsm1115m000) session. In the Actions menu, select Import from Logical Tables. If you neglect to do so, then you cannot upgrade the tenant anymore. This is a required action that is verified by the 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 of the tiitm module of the logical company 100 are physically stored under company 500, except for the tiitm001 table. The tccom000 table is also stored under company 500.

After you have entered the data you must convert the data to the runtime DD. The runtime data is stored in $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 run-time 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.

Actions/Buttons

These options are available:

Enable Editing of Logical Tables: Use this command only in case of emergencies to enable the editing of the Logical Tables. Updates of the Logical Tables are performed by making a Table Sharing Set actual in the Table Sharing Modeler.
Use the Table Sharing Modeler to set up and maintain the table sharing and use this session only to check table relations on table level.

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. See this option to define exceptions for tables in a particular module, where all other tables in that module are linked to a physical company.