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 , 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.

2 , 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. 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.

3 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 .. 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 .. 96 Format to 97 Number Format.

4 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) .. 137 Transferring Data from Materials Management (MM) .. 139 Transferring Data from Sales and Distribution (SD).. 141 Transferring Data from Controlling (CO).]

5 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 .. 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.

6 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 .. 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.

7 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 .. 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.

8 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 .. 306 Currency Translation 307&DUU\LQJ )RUZDUG %DODQFHV $UFKLYLQJ ,QIRUPDWLRQ 6\VWHP 5 HSRUW 3 DLQWHU 5 HSRUW :ULWHU Report Painter or Report Writer? .. 316 Report Painter .. 318 Working with the Report Painter .. 320 Defining Reports for the Report/Report Interface .. 323 Creating a Report Painter 326 Creating an Example Actual/Plan Comparison Report Using the Report Painter . 328 Create Actual/Plan Comparison Report .. 333 Defining Row and Column Models .. 336 Creating a Model.

9 337 Inserting a Model .. 338 Transporting Models .. 339 Defining 340 Defining Rows .. 343 Exploding Report Rows .. 345 Formatting Rows and Columns .. 347 Defining Cells .. 350 Defining Sections .. 351 Defining Horizontal Pages .. 353 General Data 354 Defining Report Headers .. 3576 SHFLDO 3 XUSRVH /HGJHU 6$3 $* $SULO Extracts .. 358 Create Extract .. 360 Managing Extracts .. 361 Example Process: Report Callup with Extract 363 Report Text .. 366 Defining Report Texts .. 367 Layout .. 368 Standard 369 Creating a Standard 371 Parameters for the Standard Layout .. 374 Displaying a Standard Layout .. 376 Changing a Standard 377 Deleting a Standard Layout .. 379 Section Layout .. 380 Report Layout .. 381 Displaying the Report Layout .. 382 Defining Report Layouts .. 383 Saving Changed Report Layout Parameters .. 385 Summation Levels .. 386 Report Writer.

10 389 Working with the Report Writer .. 392 Report Writer Reports .. 396 Process Example: Creating a Report Writer Report .. 398 Creating a Report Painter Report .. 403 Checking a Report .. 405 Displaying a 406 Changing a Report 407 Deleting a Report .. 408 Defining Report Headers .. 409 Entering Language-Specific Report Header 410 Freezing Page 411 Sections .. 412 Defining Sections .. 413 Section Layout .. 415 Report Text .. 416 Defining Report Texts .. 417 Variables for The Definition of Report 418 Using Standard Text Variables in Report Texts .. 419 Using Special Text Variables when Defining Report Texts .. 421 Report Definition: Using Text Variables for Selection 423 Report Definition: Using Text Variables for Characteristics .. 425 Defining Selection Criteria .. 427 Defining Rows .. 433 Inactivating Columns for a Row Block .. 437 Entering Characteristic Information for a Row Block.