Database Definition and Installation 

Use

One of the first tasks in setting up your FI-SL system is to define the variable dimensions that your ledger(s) will use. Next you must define your database structure.

Variable dimensions determine which dimensions are stored in the key part of a data record. They also determine which variable fields of the data record key can be filled when a document is posted to FI-SL.

When you set up your system, you should first define the dimension combinations and ledger structures that you want to use in your system. Efficient structuring of your variable dimensions results in a reduced amount of data storage space being required.

Features

You use the Define Table Group function to define complete table groups and store them in the ABAP Dictionary. A table group is a group of interdependent database tables (object/summary/actual and plan line item tables). To define the table groups, in Customizing for the Special Purpose Ledger, choose Basic Settings ® Tables ® Definition ® Define Table Groups.

When you use the Define Table Group function, you no longer have to maintain object tables and the structures assigned to them in the ABAP Dictionary. You can define the variable dimensions for two object tables (partner/object and/or movement attributes). The system automatically generates the summary and line item database tables assigned to these object tables.

Once you have saved your table group, you can activate it.

You should only activate your table group when it is complete and you want to save it permanently. If you make changes to tables that have been activated, you may have to make manual changes in the ABAP Dictionary.

Once you have created and activated the table group, you can install it directly from the Define Table Group transaction. To do this, in the function Define Table Group, choose the subsequent function Install.

You can also deactivate database tables, for example, if syntax errors have occurred during installation. You deactivate database tables in the table directory in Customizing. When you use the deactivation function, all tables that belong to the same table group are deactivated. For more information, see the Implementation Guide for the Special Purpose Ledger under Basic Settings ® Maintain Table Directory.