Transferring G/L Account Master Data
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.
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 CodeAssign 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 VariantsCopy 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 AccountProcedure
Extracting G/L Account Data from the SAP System
Object type: BUS3006 G/L account
Program type: BINP
Program/method: RFBISA00
File type: P
File name: As required
The Extract G/L account master data in file screen appears.
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.
Creating a spreadsheet file
The Copy file dialog box appears.
Processing a file with spreadsheets
Creating a File in SAP Format
Reloading the File into the SAP-System
The program creates a batch input session.
Result
The G/L account master data is transferred to the SAP System.