Entering content frame

Process documentation Configuration Locate the document in its SAP Library structure

Purpose

Before you can use the functions of the special purpose ledgers, you have to decide how you want to configure the ledgers in your system. You can then make the settings. To do this, you have to carry out the following steps. For detailed information about configuration, see the ImplementationGuide (IMG) for the Special Purpose Ledger.

Process Flow

...

        1.      Plan the structure of your FI-SL system

Before you install and set up the special purpose ledgers in your system, you must carefully design your system structure. It is very important that you take time to design your system and data structures in detail. A well-planned system structure is the prerequisite for an efficient production system and improves system performance.

You have to define which dimensions and field movements you want to use in your ledgers dependent on your reporting requirements. (A dimension represents specific criteria of a business process. Technically, a dimension is a single field or column of a database table.)

 

This graphic is explained in the accompanying text

 

Example

In the figure above, Ledger 1 uses the dimensions Account and Cost Center; Ledger 2 uses the dimensions Cost Center and Plant; and Ledger 3 uses the dimensions Product and Product Number. Since Ledgers 1 and 2 both use the dimension Cost Center, and all the dimensions used by these two ledgers are defined in one table group, both ledgers can use one table (Table Group 1). Since the dimensions Product and Product Number do not exist in Table Group 1, Ledger 3 must use a different table group.

        2.      Create your database tables

Once you have designed your FI-SL system structure, you can create your database tables and specify which dimensions you want to include in your tables.

FI-SL uses the following table types:

·   Object tables (for receiver/sender and transaction attributes)

·   Summary tables

·   Actual line item tables

·   Plan line item tables

You define your database tables in Customizing for the Special Purpose Ledger under Basic Settings ® Tables ® Definition. The tables are stored in the ABAP Dictionary. A table group is a group of interdependent tables (object tables, summary tables, actual and plan line item tables).

Note

You can also create a rollup actual line item table and a rollup plan line item table, if, for example, you want to drill down from the rollup totals records to the original data in a Report Writer report.

You cannot install these tables automatically using the Define Table Group function. If you want to use a rollup table, you have to copy the standard tables delivered with your system (GLREFU: Rollup actual line item table and GLREFV: Rollup plan line item table) using the Copy Table function in Customizing and then modify them according to your requirements.

When you create your database tables, you have to decide the following:

¡        Whether you require a local table (for a company code) or a global table (for a company)

¡        Which dimensions you want to include in the object/partner object table (for example, account, cost center, business area, and so on), and which of these dimensions you also require as partner dimensions (sender/receiver relationship)

¡        Whether you require a second object table for movement attributes

¡        Whether you want to include additional dimensions in the data part of the summary table. These dimensions are known as derived dimensions because they can be uniquely derived from the dimensions in another summary table.

¡        Whether you want to include additional dimensions in your actual line item table. These dimensions are only used in document display (or in line item reporting).

¡        Which currencies and quantities you want to use in your database tables

¡        How many periods you require in your totals records

¡        Which database indexes you want to define for your FI-SL tables

For more information, see Database Definition and Installation.

        3.      Install the FI-SL database tables

Once you have defined, saved, and activated your table group, you have to install your database tables. To do this, in the IMG activity Define Table Group, choose the subsequent function Install.

        4.      Create the FI-SL master data

After you have defined the dimensions that you want to use in your ledgers (table structures), you can define the master data (special purpose ledgers, companies, transactions, and field movements) that you want to use in your system.

 

This graphic is explained in the accompanying text

 

Special purpose ledgers: When you create your special purpose ledgers, you define the ledger master data (such as the currencies and quantities the ledger should use, whether the ledger is open for posting, and whether the ledger can be used as a rollup ledger). You also have to assign a company code or company to your ledger so that data can be posted to the ledger. You then define which transactions can update the ledger (company code/ledger/transaction or company/ledger/transaction assignment). If you want to define additional criteria for posting data to your ledger, you can enter ledger selection conditions.

Company codes and companies: You can use company codes and companies in your FI-SL system. Company codes are defined in Financial Accounting, and in FI-SL, are used more frequently than companies. You can set up your system so that a company code directly updates a local ledger (ledger/company code assignment). Companies usually group together one or more company codes. You can assign a company code to a company so that the company code updates a global ledger and a local ledger (ledger/company assignment).

Transactions: The data entered in other SAP applications or external systems is transferred into the FI-SL system using a transaction. You have to assign transactions to your ledgers so that this data can be included in these ledgers.

Field movements: You can create field movements to define which dimensions are filled within the FI-SL system. Field movements determine which dimensions from other SAP applications are transferred to the dimensions in the FI-SL system.

For more information about creating master data, see the activities under Master Data in the Implementation Guide (IMG) for Special Purpose Ledger.

Note

You can also define your master data using the Graphic Navigation function, which enables you to display relationships between company codes, companies, ledgers, and transactions graphically. If required, you can also branch to the assignment to change it. To do this, in Customizing for the Special Purpose Ledger, choose Basic Settings ® Tables ® Display Assignments Graphically.

        5.      Define additional requirements for working with your system

After you have created the master data that you want to use in your system, you have to define additional system settings (such as posting periods and versions) required for working in your productive system.

You can also define your own validations and substitutions to check and/or substitute values and combinations of values as they are entered in your system. Since validation and substitution occur before data is posted, only valid information enters the FI-SL system.

Result

Once you have configured your FI-SL system, you can work with it and use functions in accordance with your requirements.

 

 

Leaving content frame