..

Financial Operations G/L Account List Displaying a G/L Account List Contents Go to the Initial Screen Run the Variant Print the List Create a Document Download to a Spreadsheet File on the PC Download to a Spreadsheet File on the Mac Overview You can run a variant to see a list of G/L accounts. The variants include: Active expense and revenue G/Ls Active expense G/Ls Active revenue G/Ls All G/L accounts (active and inactive) All active G/Ls You can then print the list as it is, or download it to a Word document or an Excel file.   Go to the Initial Screen Use the following navigation path from the User Menu screen: Navigation Path: - User Menu - Role ZMIT - Master Data - Financial Data - S_ALR_87012333-G/L accounts list top   Run the Variant 1. Click the Get Variant button . 2. Double-click on the variant. Result: The required fields are filled in. 3. Click a radio button to select an output format. The recommended options are: Field Name Description ABAP list (most recommended) Lists the G/L accounts, company code, and their description in a text table. Display as table Lists the same information as above but in an SAP screen format. Word Processing Lets you create a file of G/L accounts which you can open as a Word document. See Create a Document below for instructions. Spreadsheet File Lets you download the G/L accounts list to a spreadsheet file. See Download to a Spreadsheet File on the PC or Download to a Spreadsheet File on the Mac below. 4. Click the Execute button . top   Print the List 1. If you chose a list format, click the Print button . Result: The "Print Parameters" screen is displayed. 2. Choose your printer in the Output Device field. 3. Click the Continue button. Result: The "Print request for list was generated" message appears on the bottom of the screen. The list was printed. top   Create a Word Document If you chose the Word Processing option, a pop-up window is displayed after you clicked the Execute button . 1. On a Mac, the Create document option is already selected.   On a PC, select the Create document and Start MS Word options. 2. Click the Enter button . Result: A window where you can select a location and a file name is displayed. 3. Select the location of your file on top. 4. Type the file name in the blank box on the bottom. 5. Click the Save button. 6. On a PC, the Word application opens and the list is displayed.   On a Mac, double-click on the file and choose the Microsoft Word application to open it. top   Download to a Spreadsheet File on the PC If you chose the Spreadsheet option, an "Export list object to XXL" pop-up window is displayed after you clicked the Execute button . 1. Choose Table and click the Enter button . 2. MS Excel is enabled. Click the Enter button . Result: The Excel application opens and the G/L accounts list is displayed. 3. Work on the spreadsheet file and Save Copy As to save the file to a location or Close to discard the file and exit Excel. top   Download to a Spreadsheet File on the Mac 1. After you run the variant, follow the menu path: System > List > Save > Local file. Result: The "Save list in file . . ." dialogue box is displayed. 2. Choose Spreadsheet. 3. Click the Enter button . 4. Click the Matchcode arrow on the resulting dialogue box. 5. Type in a file name and choose a location to save the file. 6. Click the Save button. 7. Click the Transfer button. Result: The number of bytes transferred appears at the bottom left of your screen. 8. Double-click on the file and then choose the Excel application to open it. top Copyright 2002 © Massachusetts Institute of Technology SAP for MIT Documentation on the Web Valid From: 04/11/2002