SAP ABAP IMG Activity DPR_DX_PROJECT (Import from Microsoft Excel to Projects)
Hierarchy
CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   PPM (Application Component) Portfolio and Project Management
     PPM_IMG (Package) Portfolio and Project Management IMG Objects
IMG Activity
ID DPR_DX_PROJECT Import from Microsoft Excel to Projects  
Transaction Code S_X1D_36000067   (empty) 
Created on 20100607    
Customizing Attributes DPR_DX_PROJECT   Import from Microsoft Excel to Projects 
Customizing Activity DPR_DX_PROJECT   Import from Microsoft Excel to Projects 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name DPR_DX_PROJECT    

Use

In this Customizing activity, you can import data from a Microsoft Excel workbook to create or delete multiple projects simultaneously.

The Microsoft Excel workbook that you can import contains the following sheets with fields that match the project fields:

  • Structure
  • Project
  • Phase
  • Task
  • Checklist
  • Checklist Item
  • Role
  • Staffing

Requirements

You have defined the fields for the import workbook in the Customizing activity Configure Fields for Mass Import.

Standard settings

Activities

You can download the Microsoft Excel workbook as a template that includes all the fields available. To start this activity, you choose Display DX Layout.

You can populate the workbook with information for one of the following operations: create new projects, or delete existing projects. To perform different operations you have to create and import separate workbooks.

  • Create
    • When you import the workbook, new projects are created. If an error occurs during the mass import, the objects for which errors occurred are not imported.
  • Delete
    • When you import the workbook, the projects listed on the Structure worksheet are deleted from the system.
    • Deletions are made at project level only: phases, tasks or any other project elements are not deleted independently from a project.

For each of the operations above, you can choose Test Run so that the import runs and messages are generated, but the data is not saved. If no errors occur, you can then run the import.

After each import, the system records all successes and errors in the application log.

Example

Business Attributes
ASAP Roadmap ID 204   Establish Functions and Processes 
Mandatory / Optional 2   Optional 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 DPR_DX_PROJECT 0 APL0000008 Project Management 
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 DPR_DX_PROJECT  
History
Last changed by/on SAP  20100608 
SAP Release Created in 500_702