FISL queries

[Former Member]

Hi all,

I have some doubts on FI_SL .

1. Alternative charts of accounts (operative, group-specific, and country-specific charts of accounts).

Can anyone explain them with examples.

2.Object table and summary table

How to create them

3.How to generate extract structure

Tcodes for this

Please explain them with some scenarios.

Thanks in advance!

[Former Member · Accepted solution]

Chart of Accounts List

Definition

The chart of accounts list is a directory of all charts of accounts that can be used in a client.

Use

You enter all the charts of accounts that you require for your company in this list. To do this, in the Financial Accounting Implementation Guide, choose General Ledger Accounting ® G/L Accounts ® Master Data ® Preparations ® Maintain Chart of Accounts List.

In the FI system, you can use as many charts of accounts as you require within a client. You can thus meet the varying needs of the individual company codes regarding the chart of accounts structure. The following characteristics of the individual company codes could, for example, place various demands on how the chart of accounts is set up:

Location (country)

Branch

Corporate structure

Corporate size

Legal requirements

However, several company codes can also use a common chart of accounts if a different grouping of the chart of accounts is not required.

You must assign one chart of accounts to each company code. You therefore need at least one chart of accounts for your company in the system.

The chart of accounts is shared by Financial Accounting as well as cost/revenue accounting. The items in a chart of accounts can be both expense or revenue accounts in Financial Accounting and cost or revenue elements in cost/revenue accounting.

Structure

If you enter a chart of accounts in the chart of accounts list, note the importance of the following settings:

Maintenance language

The chart of accounts is created and changed in one language, the maintenance language. This means that the names of the G/L accounts are created and changed in the maintenance language. If the chart of accounts is used by multiple company codes using varying languages, you can translate the account names into the languages needed. For more information on this, see Translating a Chart of Accounts.

Group chart of accounts

You can assign an alternative group chart of accounts to the chart of accounts. For more information, see Chart of Accounts.

Length of the G/L account number

You can define the length of the G/L account numbers. The maximum length is ten characters. Internally, the system keeps the account numbers with a ten character length. The system pads purely numeric account numbers with zeroes from the left, and alphanumeric account numbers from the right.

To change the chart of accounts list, read Changing the Chart of Accounts List.

[Former Member]

OBJECT TABLES

Tables and Archiving Objects

Use

Transaction DB15 enables you to determine which archiving objects archive the data records from a specific table, or enables you to display all of the tables for a specific archiving object. You can also call various statistics for the amount of used database space.

Integration

This function is integrated into data archiving. Therefore you can also call it from Archive Administration (Transaction SARA) via Database Tables.

Features

Archiving Objects

This pushbutton takes you to the part of the screen where you can determine archiving objects. To display the archiving objects that apply to a specific table, enter the table name under Objects for Table and choose Display Table.

Tables from which you want to archive data

This pushbutton takes you to the part of the screen where you can determine tables. To display the tables that belong to a specific archiving object, enter the archiving object under Tables for Object and choose Display Objects.

In the display, some archiving object types are not shown. These are all archiving objects that

· Read, but do not delete

· Archive using a view or a structure

· Archive using an archiving class for which no table information is maintained (transaction ACLA)

By default, the system displays only tables whose data records are deleted during Data Archiving. By selecting All Tables, you can, however, display all tables that are linked to the archiving object (with the exception of those mentioned above).

For more information about how to determine tables and archiving objects see Displaying Archiving Objects and Tables

[Former Member]

Extract structure

There are two ways of processing large quantities of data in ABAP - either using internal tables or extract datasets.

An internal table is a dynamic sequential dataset in which all records have the same structure and a key. They are part of the ABAP type concept. You can access individual records in an internal table using either the index or the key.

Extracts are dynamic sequential datasets in which different lines can have different structures. Each ABAP program may currently only have a single extract dataset. You cannot access the individual records in an extract using key or index. Instead, you always process them using a loop.

Internal Tables

Extracts

The following section contains examples of how to process large datasets for display in a list:

Formatting Data