Merging SAP PS with Microsoft Project

• Download source - 1.65 MB

Prerequisites

• Microsoft Project Professional 2007 Client
• Microsoft Visual Studio 2008

Step by Step Installation Instructions

1. Unzip the “Merging SAP PS with Microsoft Project.zip” file to a working directory. This creates the “Projects” directory and sub folders listed below:

   

2. Run Microsoft Visual Studio 2008 and open D:\Projects\ProjectAddIn2\ProjectAddIn2.sln.
3. In the ProjectAddIn2 -> Properties -> Settings page, modify the settings to match your configuration:

   

4. Make sure that the solution reference to CSAPData points to: D:\Projects\CSAPData\bin\Debug\CSAPData.dll.
5. Compile the project and run it.
6. A merged working copy of the selected SAP Project is saved to the “TestDir” listed above as a Microsoft Project .mpp file.
7. The SAPProject.mpt template file in the TestDir folder has our global constructs.
8. To recompile the CSAPData.dll, you must open the project in Microsoft Visual Studio .NET 2003. There is a reference article listed in the “CodeProject Merging SAP PS with Microsoft Project” document detailing how to do this.

Please feel free to send any questions or pointers to PBremner@bak.rr.com or go to www.VisualSAP.net and use the contact option (top center).

Sample project (which you don't have in your SAP system):

Alternative SAP Connection string:

String sConn = "CLIENT=" + Properties.Settings.Default.Client +
               " USER=" + Properties.Settings.Default.User +
               " PASSWD=" + Properties.Settings.Default.Password +
               " LANG=" + Properties.Settings.Default.Lang +
               " ASHOST=" + Properties.Settings.Default.ASHOST +
               " SYSNR=" + Properties.Settings.Default.SYSNR;

Running the Applet

This project updates or inserts a new Network-Activity (MSP Task) to/from SAP<–> Microsoft Project.

1. From Microsoft Visual Studio, run the project. You should get the following Microsoft Project screen. The status bar tells us the “SAP Addin loaded successfully”.

   

2. Click on the “GetSAPProject” button. This will log in to your SAP system and retrieve a list of available SAP projects. Select a project.
3. If the selected project (e.g. 7004) exists as an MSP .mpp file in the TestDir, the SAP Project and the MSP .mpp file are merged together.

   

4. Let's insert a new Activity task and set the system to just move our new activity/task from MSP to SAP. We set the “SAP Object” field to “No” for all tasks except our new task. On task 17, we populate the:

    SAP Object 	= “Yes”		, our control field
    Object Type 	= “Activity”	, our control field
    WBS# 		= “7004.001”      , SAP field
    Network 		= “000000903899”  , SAP field
    Activity		= “0031”          , we create, must be unique in SAP

5. Click on the “Save to SAP” button. Status bar says “Project saved to SAP successfully.

   

If you have any questions, email me at PBremner@bak.rr.com.

Thanks,
Phil

History

• 3^rd November, 2009: Initial version

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)