Click here to Skip to main content
Click here to Skip to main content

Tagged as

Go to top

Merging SAP PS with Microsoft Project

, 6 Feb 2011
Rate this:
Please Sign up or sign in to vote.
Installation instructions for the CodeProject “Merging SAP PS with Microsoft Project”

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

  • 3rd November, 2009: Initial version

License

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

Share

About the Author

PhiB

Unknown
No Biography provided

Comments and Discussions

 
QuestionThisAddIn constructor error when compiling…? PinmemberMohammed Shaneeb30-May-13 1:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140926.1 | Last Updated 6 Feb 2011
Article Copyright 2009 by PhiB
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid