G/L Account List

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

top

 

Print the List

1. If you chose a list format, click the Print button 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 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 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 Execute button .

1. Choose Table and click the Enter button Enter button .

2. MS Excel is enabled. Click the Enter button 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 Enter button .

4. Click the Matchcode arrow matchcode 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