Click here to Skip to main content
12,078,489 members (46,826 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as

Stats

17.7K views
397 downloads
10 bookmarked
Posted

Merging SAP PS with Microsoft Project

, 6 Feb 2011 CPOL
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

You may also be interested in...

Comments and Discussions

 
QuestionThisAddIn constructor error when compiling…? Pin
Mohammed Shaneeb30-May-13 2:37
memberMohammed Shaneeb30-May-13 2:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 | Terms of Use | Mobile
Web04 | 2.8.160212.1 | Last Updated 6 Feb 2011
Article Copyright 2009 by PhiB
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid