SAP ABAP IMG Activity SIMG_CFORFBSXDASAKO2 (Hierarchical Structure for Data Transfer)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ FB0C (Package) Financial Accounting customers
IMG Activity
ID SIMG_CFORFBSXDASAKO2 Hierarchical Structure for Data Transfer  
Transaction Code S_ALR_87004597   IMG Activity: SIMG_CFORFBSXDASAKO2 
Created on 19981222    
Customizing Attributes SIMG_CFORFBSXDASAKO2   Data Transfer Workbench for G/L Account Master Data I 
Customizing Activity SIMG_CFORFBSXDASAKO2   Data Transfer Workbench for G/L Account Master Data I 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name SIMG_CFORFBSXDASAKO2    

In this activity, you can create G/L accounts automatically using the data transfer workbench by editing the data via a standard table calculation file and then reloading it into the system.

Requirements

Create a target company code in the R/3 System to which the data is to be reloaded. Assign this company code to a chart of accounts that does not yet contain any G/L accounts.

Assign a field status variant to this target company code (use the field status variant of the reference company code). To do this, choose the activity Assign Company Code to Field Status Variants.

Copy the account groups belonging to your reference chart of accounts to the empty chart of accounts that does not yet contain any G/L accounts. To do this, choose the activity Define Screen Layout per Account Group (G/L Accounts). Select the relevant entries and choose Copy as. All you then need do is enter the name of the empty chart of accounts.

Define a retained earnings account for the new chart of accounts, ensuring that the retained earnings account category is the same as the reference chart of accounts. To do this, choose the activity Define Retained Earnings Account.

Activities

  1. If necessary, create your own structure for the batch input. This should contain those fields that you really require. To do this, choose the function "Dictionary" under the object-specific settings. Then proceed as follows:
    • Enter "ZSKX" as the name of your structure.
    • Select the dictionary object "structures" followed by the function "Create".
    • Enter a short text and choose Extras -> Copy fields...
    • Enter "BSKX" as table name (contains the reference structure) and choose "Select flds". Select the fields you require from the reference structure. The fields STYPE and TBNAME must be copied - they must be in first and second place in your structure. You also require fields TCODE, SAKNR and BUKRS. You can define their position yourself. You do not need to use any other fields. Once you have marked them, choose "Copy" followed by "Paste".
    • Save your new structure and then activate it. You cannot use the structure until you have exited this activity and restart the data transfer workbench.
  2. Create a file capable of table calculation to which you write R/3 System data. To do this, under the object-specific settings, choose "Test data" and then enter the following data on the selection screen:
    • All G/L accounts belonging to a company code. In this case, enter the company code only, and make no entry in the G/L account field.
    • Certain G/L accounts belonging to a company code (a balance sheet account or tax account for example).
    • The company code from which you want to obtain the data
    • The target company code in which data is entered when the data is reloaded into the R/3 System. This target company code must first be created in the R/3 System and then assigned to a chart of accounts that contains no G/L accounts.
    • File names

      You can now run the program.

      The program writes the data to the application server's file system.

  3. Copy the file from the application server to the presentation server. To do this, choose Transfer object -> Copy file.
  4. Convert the file to a text file that can be correctly read and interpreted by a table calculation.

    The name of the target file must have the extension ".txt". This ensures that the text file can be correctly read by a table calculation program.

    To do this, choose "File conversion", enter the file name, and choose "Fixed length -> Separator" as the conversion direction.

  5. Process the file using the table calculation.

    When reading the data, set the columns of the data format to "Text". You can enter your data manually or import it from another table calculation fille. Once you are finished processing, save the file with extension "txt".

  6. Reconvert the text file back to SAP format.

    To do this, choose the function "File Conversion", enter the file name, and choose "Separator -> Fixed Length" as the conversion direction.

  7. Copy the file from the presentation server to the application server.
  8. Reload the data into the R/3 System by choosing Goto -> Carry out data transfer. The report program creates a batch input file.
  9. Carry out the batch input session.

Business Attributes
ASAP Roadmap ID 254   Transfer Data 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 1   Critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG SIMG_CFORFBSXDASAKO2 0 HLA0006520 O HLB0006314  
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
IMGDUMMY D - Dummy object SXDA 00100002 Data Transfer Workbench: G/L Account Master Data I 
History
Last changed by/on SAP  19990423 
SAP Release Created in