VP for FinanceG/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
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.
Use the following navigation path from the User Menu screen:
Navigation Path: |
- User Menu |
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 |
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 
.
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.
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. |
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.
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.
