SAP ABAP IMG Activity ORFA_ALTDAT_EXCEL (Legacy Data Transfer using Microsoft® Excel)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       AA (Package) Application Development R/3 Assets: Master Data
IMG Activity
ID ORFA_ALTDAT_EXCEL Legacy Data Transfer using Microsoft® Excel  
Transaction Code S_ALR_87099667   (empty) 
Created on 19990317    
Customizing Attributes ORFA_ALTDAT_EXCEL   Legacy Data Transfer Using Microsoft Excel 
Customizing Activity ORFA_ALTDAT_EXCEL   Legacy Data Transfer Using Microsoft Excel 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name ORFA_ALTDAT_EXCEL    

In this step, you transfer legacy data using Microsoft Excel. This procedure is suitable when you want to tranfer not more than a few hundred assets.

Example

Requirements

You have to have already created an Excel sheet containing your legacy data.

Standard settings

Recommendation

Activities

  1. Start the transfer program.
  2. Make the following settings in the initial screen of the transfer transaction:
    1. Enter the path of the input file.
    2. If you want to create a new field assignment, choose "Create field assignment." On the next screen, assign the field descriptions from your Excel worksheet to field in the SAP System.
    3. If you want to use an existing field assignment, then select this field assignment and choose "Start with field assignment."
  3. Carry out a test run, and correct any errors that occur during the test run.
  4. Create the assets.
  5. You can save field assignments by choosing "Saved assignments."

Further notes

For more information on legacy data transfer and on the structure of the Excel sheet, refer to the SAP library under "Legacy Data Transfer Using Microsoft Excel."

Business Attributes
ASAP Roadmap ID 254   Transfer Data 
Mandatory / Optional 3   Nonrequired activity 
Critical / Non-Critical 2   Non-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 ORFA_ALTDAT_EXCEL 0 HLA0006110 Basic Functions 
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 AS100  
History
Last changed by/on SAP  20010907 
SAP Release Created in