Entering content frameFunction documentation Mapping Microsoft Project Objects to the R/3 Project System Locate the document in its SAP Library structure

Use

This is in general the more complex of the two mapping operations, since the Microsoft Project objects have to be in certain formats in order to be mapped successfully to the R/3 Project System. The mapping of R/3 Project System objects to Microsoft Project is described in Mapping R/3 PS Objects to MS Project Objects.

Features

How MS Project Objects are Mapped to the Project System

When creating objects in Microsoft Project that you want to transfer to R/3 PS at a later date, you must remember that the names of projects and WBS elements in the Project System must be unique. If you try to create a project definition or WBS element that already exists in the R/3 system, Open PS issues an error message during transfer and the project is not created.

Project Information

When you create a project in Microsoft Project, the program creates so called Program Information (a dialog box with default values appears). This information is used to create the project definition in PS. The project dates are taken from the summary tasks.

Summary Tasks

WBS elements as such do not exist in Microsoft Project. Open PS maps summary tasks to WBS elements in PS.

For a task to be a summary task, it must have subordinate tasks.

Note

The first task in your project must be a summary task. Otherwise it cannot be transferred to R/3 PS.

For details on the syntax of the names you can use for summary tasks, refer to the Names of Microsoft Project Objects section.

Tasks

Tasks in Microsoft Project are the equivalent of activities in the Project System. Since an activity number in PS can have up to four characters, you can only use this number of characters in Microsoft Project.

Entering resources

In Microsoft Project you can enter resources for a task. If, however, you want the resources to be transferred to the R/3 Project System as work centers, you must enter the resource as follows:

    1. Open the resource sheet by clicking on the icon in the left-hand margin. This graphic is explained in the accompanying text
    2. If they are not already present, insert the fields Text20 and Text21 for the plant and the work center respectively in the table. (In Microsoft Project select the column to the right of where you want to insert the new field and choose Insert Column in the context menu. Select the field name Text20 orText21. If you want, you can add another title for the field, such as Plant or Work Center. Choose OK.)
    3. In Text20 enter the plant and in Text21 the work center.

Note

Both the plant and the work center must exist in the R/3 system, before you can transfer them from Microsoft Project

You can enter several resources for a task in Microsoft Project. Open PS assigns the first resource to the activity and the following resources to the activity elements. The distribution of work amongst the resources is not transferred to R/3. The work is distributed evenly between the work centers in the Project System.

 CautionAlthough you can enter the activity type in the Text17 field, Open PS always creates internal activities in PS. However, during synchronization the activity type is not changed.

Milestones

Milestones in Microsoft Project are defined as tasks with a duration of 0 days. They have the Mark task as milestone indicator set. Milestones in Microsoft Project do not have the same functionality as milestones in the R/3 Project System. Therefore you will in general have to edit the milestones in the Project System, before you can use them.

Milestones for summary tasks

In Microsoft Project the milestone must be directly under the summary task, if you want to transfer it as a WBS element milestone. These are transferred to the Project System as WBS element milestones. They are not linked directly to the summary task. If a milestone is the earliest or latest subordinate task, the milestone defines the start or finish date for the summary task. If you move the milestone, the summary task is moved automatically. This is one way of assigning a milestone to the start or finish of a WBS element. You can thus use milestones to specify the dates of a WBS element independently of the subordinate task (activity dates). This is only valid in Microsoft Project.

Milestone for tasks

These are transferred to the Project System as activity milestones. In Microsoft Project the milestone must be directly under the task, if you want to transfer it as an activity milestone. Again they are not linked directly to the superior task. However, you can create a relationship between a task and a milestone. As a result if you move the task in Microsoft Project, the milestone is also moved.

Note

It is not possible to specify in Open PS whether a milestone refers to the start or finish of an activity. When it creates a milestone in the Project System, the milestone date is automatically given the start date of the activity or the WBS element. Any entries you made in Microsoft Project are overwritten.

Relationships

Since relationships are common to both the R/3 Project System and Microsoft Project, there are no difficulties mapping them. The four types of relationship (Finish-Start (FS), Start-Start (SS), Finish-Finish (FF), and Start-Finish (SF)) are used in both programs. You can also transfer time intervals, expressed either in absolute values or as a percentage of one of the two activities.

You can use the Predecessors and Successors fields in Microsoft Project to display the task to which a task is linked. If the relationship is not a FS relationship (default value), the relationship type is displayed. Any time interval between the two tasks is also displayed. Here the tasks are referred to by their ID, which is the line number in the project.

In Microsoft Project a task that must start or finish before another task can begin is called a predecessor task. A task that depends on the start or finish of a preceding task is called a successor task.

 

Names of Microsoft Project Objects

To be transferred correctly to the Project System, the names of the various Microsoft Project objects have to meet the same criteria as the names of the corresponding PS objects.

Microsoft Project Object

Corresponding PS Object

Type of Entry

Maximum Length (characters)

Unique

Summary task

WBS element

Alphanumeric

24

Y

Task

Activity

Alphanumeric (see below)

4

Within the network

Milestone

Milestone

Numeric

12

Within the project

Note

Although it is possible to use letters to depict activities, this can produce unexpected results in PS. We therefore recommend that you only use numbers for activities.

See also: Detailed Mapping of Fields

 

 

 

Leaving content frame