
Mapping Microsoft Project Objects to the R/3 Project System
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.

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:


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.
Although 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.

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 |

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