SAP Special
purpose ledger
configuration
Product of
www.sapścoconsuItant.com
© 2005 sapficoconsultant com. All rights reserved. No part of this e-book
should be reproduced or transmitted in any form, or by any means, electronic
or mechanical including photocopying, recording or by any information
storage retrieval system without permission in writing from
www.sapficoconsultant.com
This e-book version is for an individual. No corporation, training classes,
training institutes are allowed to use this e-book.
“SAP” is a trademark of SAP AG, Neurottstrasse 16, 69190 Walldorf,
Germany.
SAP AG is not the publisher of this e -book and is not responsible for it under
any aspect.
Warning and Disclaimer
This e-book is sold as is, without warranty of any kind, either express or implied.
While every precaution has been taken in the preparation of this e -book,
www.sapficoconsultant.com assumes no responsibility for errors or omissions.
Neither is any liability assumed for damages resulting from the use of the
information or instructions contained herein. It is further stated that the publisher
is not responsible for any damage or loss to your data or your equipment that
results directly or indirectly from your use of this e-book.
SPL configuration Page 2 of 81 www.sapficoconsultant.com
TABLE OF CONTENTS
INTRODUCTION................................................................................................4
1. Organizational Structures...............................................................................5
1.1 Define Table Group.................................................................................5
1.2 Maintain Fiscal Year Variants..................................................................24
1.3 Maintain Ledgers....................................................................................25
1.4 Maintain Local Posting Periods................................................................39
1.5 Maintain Actual Versions........................................................................39
1.6 Maintain Valid Document Types..............................................................40
1.7 Maintain Local Number Ranges...............................................................41
1.8 Perform Diagnosis..................................................................................43
1.9 Actual posting test from FI to Special Ledger............................................49
1.10 Entering an FI-SL document....................................................................52
1.11 Define Libraries......................................................................................57
1.12 Define Report Painter Reports.................................................................63
INTRODUCTION
In the FIGL configuration we configured the company code A Ltd 9100 for a
fiscal year variant K4 (January – December). This book (Ledger 0) is used for
reporting to the parent company.
A Limited also wants to prepare accounts for tax purpose based on fiscal year
variant (April to March). This is possible by implementin g Special purpose
Ledger. The data from FI module will be passed on to the Special Purpose
Ledger.
Special Purpose Ledger calls for creating a new table group, new Ledger and
the field movements. The fields which are required for reporting needs to be
captured in the object table 1.
You have to define your own reports in the report painter reports in Special
purpose Ledger. This can be a Trial Balance, Balance sheet and profit and
loss account.
1. Organizational Structures
For configuration we use the following path on the SAP application screen:-
SAP Menu € Tools € AcceleratedSAP € Customizing € SPRO - Edit
Project €
Configuration for all the modules will be done here. The above path will
not refer henceforth; we will directly refe r to the IMG node.
1.1 Define Table Group
IMG € Financial Accounting € Special Purpose Ledger€ Basic Settings €
Tables € Definition € Define Table Group
Here , you create table groups for the FI-SL system. You can define the
variable dimensions for two object tables; the system automatically generates
the tables assigned to these object tables. A summary table, an actual line
item table and a plan line item table are generated (all tables contain the fixed
dimensions such as "Ledger", "Fiscal year" or "Version").
Specify which fields should be contained in the object tables of your table
group.
When you create or maintain an object table, the corresponding summary,
actual line item and/or plan line item tables are automatically created or
updated. The automatically generated summary and line item tables contain
the fixed fields such as "Fiscal year", "Ledger", "Version", and so on.
Update the following:-
Click on
Select Local table group
Click
Click to scroll down or press Page down button
Press Page down button
After going through the note click
Update the following:-
Click on
Click on
Click on
Click on
Click on
Update the following:-
Uncheck Store add. quantity to reduc e data storage. Similarly we want only
13 periods in this ledger.
Click
Click on
Update the following:-
Click on
Click on
Update the following:-
Click on
Click
Click
Click
Click
Click
Click
Click
Click to continue
Click
Click
Click
1.2 Maintain Fiscal Year Variants
IMG € Financial Accounting € Special Purpose Ledger€ Basic Settings €
Master Data € Maintain Fiscal Year Variants
Here we will maintain a fiscal year variant for April to March period
Click on
Update the following:-
Select
Double click
Click on
Update the following:-
Click on
1.3 Maintain Ledgers
IMG € Financial Accounting € Special Purpose Ledger€ Basic Settings €
Master Data € Maintain Ledgers
Here you create and maintain a Special Purpose Ledger. Data is posted to
the ledgers from other SAP application areas or external systems and can
also be entered directly in the FI-SL system.
Special Purpose Ledgers are ledgers that you can define for your specific
business and organizational requirements. The ledgers contain the
dimensions you enter. You can only create Special Purpose Ledgers in your FI-
SL system.
.
To make sure you can post to your ledger, you must assign the correct
activities to it. To do so, the following options are available.
You assign the same activities for all company codes.
Click on
Update the following:-
Click
Update the following:-
Click on
Click
Position the cursor on
Click
Update the following:-
Select
Click
Click on
Click
Click
We will first assign FI postings
Click to scroll down
Position cursor on
Click
Take a drop down in the field - Field movement
Click
Update the following:-
Update the following:-
Click on
Click
Again click
Select
Click
Take a drop down in the field movement
Click
Update the following:-
Update the followin g:-
Click on
Click
Click on
Similarly assign various activities to field movement
Click twice
Click
Click on
1.4 Maintain Local Posting Periods
IMG € Financial Accounting € Special Purpose Ledger€ Actual Posting€ Maintain
Actual Versions
Here you maintain the posting period variant for the company code for special
purpose ledger.
Click on
Update the following:-
Click on
1.5 Maintain Actual Versions
IMG € Financial Accounting € Special Purpose Ledger€ Actual Posting€ Maintain
Actual Versions
For maintaining actual version you first create an actual version while creating
a Ledger.
In this step you maintain the description for the actual version.
Update the following:-
Click on
1.6 Maintain Valid Document Types
IMG € Financial Accounting € Special Purpose Ledger€ Actual Posting€
Maintain Valid Document Types
Here we check the Standard document types provided. The Document type
relevant for special purpose Ledger local posting is A0 (FI-SL direct posting
actual).
Note down the number range attached to these document types.
The number range attached to Document type A0 is 01
In the next step we need to maintain the number ranges.
1.7 Maintain Local Number Ranges
IMG € Financial Accounting € Special Purpose Ledger€ Actual Posting€
Number Ranges € Maintain Local Number Ranges
This number range is used for direct posting into the special purpose ledger.
Click
Click
Click
Update the following:-
Click
Update the following:-
Click
Click on
1.8 Perform Diagnosis
IMG € Financial Accounting € Special Purpose Ledger€ Tools€ Perform
Diagnosis
Diagnosis is a tool used to analyze the data flow into the Special Purpose
Ledger system.
The following functions are available in this step:
Posting test
The "Posting test" function allows you to display a list of ledgers which would
be posted to with the current system configuration
Direct posting statistics
The "Direct posting statistics" function allows you to check which ledgers have
been posted to by a certain document.
Troubleshooting
Amongst other things, the "Troubleshooting" function allows you to check why
a certain ledger was not posted to by a certain document. In this case, an
error message appears from whose long text you can branch directly into
configuration to make any necessary corrections.
Click
Update the following:-
Take a drop down in activity
Select RFBU
Click
The posting is ok from financial accounting.
Click twice
Similarly select MM and SD and check whether posting will happen.
Now select
Click
Update the following:-
Click
So Special purpose ledger direct posting is also Ok.
1.9 Actual posting test from FI to Special Ledger
Go to transaction code FB50 in FI and Update the following:-
Click on
Check accounting document
Click
Double click
Note that the period shown is 12 2005
1.10 Entering an FI-SL document
Transaction code GB01
Path: SAP Easy Access € Accounting € Financial Accounting € Special
Purpose Ledger € Actual Posting € Local Documents € GB01 - Enter
Update the following:-
Click
Update the following:-
Click
Update the following:-
Click
Click
Click on
Click
Click
1.11 Define Libraries
IMG € Financial Accounting € Special Purpose Ledger € Information
System € Define Libraries
You have to define your own libraries in special purpose Ledger.
Update the following:-
Click
Update the following:-
Click
Click
Click
Click
Click
Click on
1.12 Define Report Painter Reports
IMG € Financial Accounting € Special Purpose Ledger € Information
System € Define Libraries
Double click
Click
Double click
Click
Select
Click
Update the following:-
Click
Click
Click
Create variable
Update the following:-
Click on
Double Click
Click
Position the cursor on account number
Click
Click
Change the lead column from 20 to 40
Click
Update the following:-
Click
Double click
Update the following:-
Click
By default the report is assigned to %001. We want to create a New report group
Click
Update the following:-
Click
Click
Click
Click
Position the cursor on each of the variables and change
For e.g.
Update the following:-
Which will finally look as follows
Click on
Click
Click
Click
Change the fiscal year from 2006 to 2005
Click
You can also create a profit and loss and balance sheet in the report painter.
That brings us to an end to the configuration of special purpose Ledger
