Start of Content Area

Procedure documentation Transferring G/L Account Master Data  Locate the document in its SAP Library structure

Use

You can transfer G/L account data by processing the data using a normal spreadsheet and then reloading it into the system.

There are also other ways of changing the G/L account master data to the required SAP format. The following procedure is however recommended to simplify the conversion of data in the SAP System.

Note

If you want to work with your own batch input structure, create a new structure under the predefined name ZSKX. From the SAP Easy Access screen, select Tools ABAP Workbench Development ABAP Dictionary. Copy the fields you require in your structure from the reference structure BSKX. Your structure should contain the fields STYPE and TBNAM in first and second place. You also require the Transaction code (TCODE), G/L account number (SAKNR), and Company code (BUKRS) fields. You can decide the position of these fields in the structure yourself. All other fields from the standard structures beginning with "B" can be used at any position in the user-defined structures or can also be omitted.

Prerequisites

You have created a target company code in the SAP System into which you are reloading data. To do this, select the following activity in Customizing for the Enterprise Structure: Definition Financial Accounting Define, Copy, Delete, Check Company Code

Assign the following to this company code:

To do this, choose the following activities in Customizing for Financial Accounting: General Ledger Accounting G/L Accounts Master Records Preparations Edit Chart of Accounts List and Assign Company Code to Chart of Accounts; Financial Accounting Global Settings Document Line Item Controls Assign Company Code to Field Status Variants

Copy the account groups from your reference chart of accounts into the empty chart of accounts that does not contain any G/L accounts. To do this, select the following activity in Customizing for Financial Accounting: General Ledger Accounting G/L Accounts Master Data Preparations Define Account Group Select the relevant entries and choose Copy as. You then only have to enter the name of the empty chart of accounts.

Define a retained earnings account for the new chart of accounts. The P&L statement account type must be the same as for the reference chart of accounts. To do this, select the following activity in Customizing for Financial Accounting: General Ledger Accounting G/L Accounts Master Records Preparations Define Retained Earnings Account

Procedure

  1. In Customizing for Financial Accounting, carry out the activity Data Transfer Workbench under General Ledger Accounting.

Extracting G/L Account Data from the SAP System

  1. On the initial screen of the data transfer workbench, choose Goto Analyze files and data structures.
  1. Enter data as required.

Object type: BUS3006 G/L account

Program type: BINP

Program/method: RFBISA00

File type: P

File name: As required

  1. Select Create file with data.

The Extract G/L account master data in file screen appears.

  1. Enter the following data on the selection screen:

Enter several selected G/L accounts in a company code (for example, one balance sheet account, one tax account).

If you want to select all G/L accounts for a company code, enter only the corresponding company code and leave the General ledger account field blank.

Enter the company code from which you want to take the data.

The target company code into which data is entered when you reload the data into the SAP System.

Enter the previously selected file names.

  1. Select Program ® Execute. The program writes the data into the application server’s file system.

Creating a spreadsheet file

  1. To copy the file from the application server to the presentation server, go back to the Data Transfer - Tools screen and select Copy file.

The Copy file dialog box appears.

  1. Under Source, select Application server, and under Target, select Presentation server and enter the name of the target file. The name of the target file must have the extension "txt". Under Copy with/without conversion, select Conversion of fixed length -> delimited tab.

Processing a file with spreadsheets

  1. Import the file using a spreadsheet program and set the columns to the data format Text.
  2. Edit the file using the spreadsheet. You can enter your data manually or copy it from another spreadsheet file.
  3. When you have finished editing the file, save it with the extension "txt".

Creating a File in SAP Format

  1. To copy the file from the presentation server to the application server, select Copy file.
  1. In the dialog box, under Source, select Presentation server and enter the name of the file to be copied. Under Target, select Application server, and under Copy with/without conversion, select Conversion of Delimited tab fixed length.

Reloading the File into the SAP-System

  1. To reload the file into the SAP System, go back to the initial Data Transfer Workbench screen.
  2. Create a data transfer project with a subproject, run definition, and tasks for the batch input program for G/L account master data.
  3. Choose Start run.
  4. The program creates a batch input session.

  5. Choose System Services Batch-Input Sessions Process.

Result

The G/L account master data is transferred to the SAP System.