Special Purpose Ledger - consolut

1 Purpose Ledger6 SHFLDO 3 XUSRVH /HGJHU 6$3 $* $SULO &RS\ULJKW Copyright 2001 SAP AG. All rights part of this publication may be reproduced or transmitted in any form or for any purposewithout the express permission of SAP AG. The information contained herein may be changedwithout prior software products marketed by SAP AG and its distributors contain proprietary softwarecomponents of other software , WINDOWS , NT , EXCEL , Word , PowerPoint and SQL Server are registeredtrademarks ofMicrosoft , DB2 , OS/2 , DB2/6000 , Parallel Sysplex , MVS/ESA , RS/6000 , AIX , S/390 ,AS/400 , OS/390 , and OS/400 are registered trademarks of IBM is a registered trademark of ORACLE -OnLine for SAP and Informix Dynamic ServerTM are registered trademarks ofInformix Software , X/Open , OSF/1.

2 And Motif are registered trademarks of the Open , DHTML, XML, XHTML are trademarks or registered trademarks of W3C , World WideWeb Consortium,Massachusetts Institute of is a registered trademark of Sun Microsystems, is a registered trademark of Sun Microsystems, Inc., used under license fortechnology invented and implemented by , SAP Logo, R/2, RIVA, R/3, ABAP, SAP ArchiveLink, SAP Business Workflow, WebFlow,SAP EarlyWatch, BAPI, SAPPHIRE, Management Cockpit, Logo and trademarks or registered trademarks of SAP AG in Germany and in several other countriesall over the world. All other products mentioned are trademarks or registered trademarks of theirrespective companies.

3 6$3 $*6 SHFLDO 3 XUSRVH /HGJHU$SULO ,FRQV,FRQ0 HDQLQJC autionExampleNoteRecommendationSyntaxTip 6 SHFLDO 3 XUSRVH /HGJHU 6$3 $* $SULO 6 SHFLDO 3 XUSRVH /HGJHU 7KH ), 6/ 6\VWHP DQG 2 WKHU 6$3 $SSOLFDWLRQV 6 KDUHG )XQFWLRQV ,QWHJUDWLRQ RI ), 6/ ZLWK 2 WKHU 6$3 $SSOLFDWLRQV &RQILJXUDWLRQ 2 YHUYLHZ &RQILJXULQJ DQG 8 VLQJ WKH ), 6/ 6\VWHP ), 6/ 'DWDEDVH 7 DEOHV Object Tables .. 32FI-SL Summary 34FI-SL Line Item 36 Database Definition and 38 Indices .. 390 DVWHU 'DWD FI-SL Master Data: Special Purpose 42FI-SL Master Data: 49FI-SL Master Data: Field Movements .. 51FI-SL Master Data: 53 Introduction to Master Data.

4 54 Creating Master Data .. 57 Displaying Master Data .. 59 Changing Master Data .. 60 Deleting Master Data .. 61 Reinstating a Deleted Master File 63 Displaying the Source of Master File Values .. 64$GGLWLRQDO ), 6/ 6\VWHP 3 UHUHTXLVLWHV Posting Periods .. 69 Validations, Substitutions, and Rules .. 703 ODQQLQJ 0 DVWHU 'DWD DQG 3 ODQQLQJ 6 HWWLQJ 8S 3 ODQQLQJ Planning 76 Planner Profile .. 77&UHDWLQJ 3 ODQ 'DWD Creating Plan Data .. 80 Planning Functions .. 82 Reload Data .. 83 Clear Row, Undo, Redo .. 85 Copy .. 87 Paste .. 89 Change 91 Line Item 92 Long Text .. 93 Goal Seek 94 Contents 6$3 $*6 SHFLDO 3 XUSRVH /HGJHU$SULO Insert.

5 96 Format to 97 Number Format .. 98 Lead Columns .. 99 Header Display On/Off .. 101 All Key Values On/Off .. 102 Distribution Key .. 103 Standard Distribution 105 Examples of Standard Distribution Keys .. 107 Defining a Distribution 110 Excel Integration in 111 Planning with Excel Integration .. 113 Planning Locally with Excel Upload .. 115 Functions for Editing Excel 118:RUNLQJ ZLWK WKH 3 ODQQLQJ 7 RRO 7 UDQVIHUULQJ &2 3 ODQ 'DWD 8 VLQJ D 3 ODQ 7 HPSODWH 'LVSOD\LQJ 7 RWDOV 5 HFRUGV 'LVSOD\LQJ 3 ODQ 'RFXPHQWV $FWXDO 3 RVWLQJ 'DWD 7 UDQVIHU IURP 6$3 $SSOLFDWLRQ &RPSRQHQWV 'DWD ,QSXW IURP ([WHUQDO 6 RXUFHV 'DWD ,QSXW 'LUHFWO\ LQ ), 6/ 'DWD 7 UDQVIHU 3 URJUDPV Transferring Data from Financial Accounting (FI).]

6 137 Transferring Data from Materials Management (MM) .. 139 Transferring Data from Sales and Distribution (SD).. 141 Transferring Data from Controlling (CO) .. 143 Transferring the Opening Balance of Statistical Key Figures from 145 Transferring Plan Documents from Controlling (CO) .. 147 Transferring Plan Data Posted to CO Objects .. 149'RFXPHQW Document Entry in the FI-SL System .. 153 Document Types and Number Assignment .. 156 Document Display .. 158 Creating Actual 159 Display Actual Documents .. 163 Reversing Actual Documents .. 1657 RWDOV 5 HFRUG Totals Record Display .. 167 Displaying Totals 168 Updating Totals 1703 HULRGLF 3 URFHVVLQJ $OORFDWLRQ Allocation Types.

7 175 Allocation 178 Sender 179 Receiver Rules .. 1816 SHFLDO 3 XUSRVH /HGJHU 6$3 $* $SULO Allocation Cycle .. 185 Allocation Segment .. 187 Selection Criteria .. 191 Rules for Selection Criteria .. 192 Dimensions in Allocation .. 194 Tips for Optimizing System Runtime .. 198 Overview: Carrying out the Allocation .. 199 Creating Allocation Cycles .. 201 Creating Header Data for an Allocation Cycle .. 203 Cumulative Processing of Allocation 205 Iterative Processing of Allocation 207 Creating a Segment for an Allocation Cycle .. 209 Creating Sender Values for a 212 Creating a Receiver Tracing Factor for a Segment.

8 214 Scaling of Negative Tracing Factors .. 216 Defining Receiver Weighting Factors .. 218 Allocating Plan and Actual Values .. 219 Locking Segments in an Allocation 220 Copying Segments .. 221 Displaying Allocation Cycles .. 222 Changing Allocation Cycles .. 224 Deleting Allocation 226 Executing Allocation Cycles .. 227 Executing an Allocation Cycle Online .. 229 Defining an Allocation Job for Background Processing .. 231 Settings for Execution of Cycles .. 232 Reversing Allocation 234 Deleting Allocation Line 235 Displaying Allocation Results .. 236 Displaying Cycle 238 Displaying Standard Settings.

9 239 Displaying Messages .. 240 Displaying Line Items .. 242 Displaying Segment 243 Displaying Sender 244 Displaying Receiver Lists .. 245 Displaying Journals .. 246 Technical Statistics, Expert Trace, and Divergence Analysis .. 247 Displaying Previous 249 Printing Detail 2505 ROOXS Sets and Rollups .. 254 Field Movements and Rollups .. 257 Line Item Database and Rollups .. 260 Types of 261 Special Periods and Rollups .. 262 User Exits and Rollups .. 263 6$3 $*6 SHFLDO 3 XUSRVH /HGJHU$SULO Using FI-SL on Distributed Systems .. 264 Carrying out Drill Downs on Rollup Line 266 Defining Rollups.

10 269 Overview: Executing 270 Creating Rollups .. 272 Creating Rollup Headers for Standard 273 Creating Rollup Headers for Hierarchical Rollups .. 277 Creating Rollup Headers for Export Rollups .. 281 Creating a Rollup Sequence .. 283 Creating Field Movement .. 285 Entering Substitution Activity Information .. 287 Checking Rollups .. 290 Documenting Rollups .. 291 Displaying Rollups .. 292 Defining a Rollup for Background 293 Reversing a Rollup .. 294 Executing 296 Exporting/Importing Rollup Data .. 299 Deleting Rollups .. 300 Changing Rollups .. 301&XUUHQF\ 7 UDQVODWLRQ Translation Methods .. 305 Exchange Rate Indicator.