The solution to use MSProject and SAP Project System together
Mps is a integrating tool for MS Project and SAP R/3 PS which allows you the access to data and functions of both systems.
The benefits of Mps include
· No SAPGUI required
· Easily perform create/updates of PS data
· Set/revoke System Status
· Free up costly ABAP programming resources
· Increase your productivity saving time and money
· Mps is easy to use, eliminating extensive training needs
· Security - Mps utilizes SAP´s internal security profiles
Key Features
· MSProject <<>> R/3
· Excel <<>> R/3
· R/3 <<>> R/3
· Status <<>> R/3
· Work Center
· User Field
· Joint Venture
· Other Field
· More than one Network per each Wbs
· Relation Lag in %
The solution to use MSProject and SAP Project System together
Mps is a integrating tool for MS Project and SAP R/3 PS which allows you the access to data and functions of both systems.
The benefits of Mps include
No SAPGUI required
Easily perform create/updates of PS data
Set/revoke System Status
Free up costly ABAP programming resources
Increase your productivity saving time and money
Mps is easy to use, eliminating extensive training needs
Security - Mps utilizes SAP´s internal security profiles
Key Features
MSProject <<>> R/3
Excel <<>> R/3
R/3 <<>> R/3
Status <<>> R/3
Work Center
User Field
Joint Venture
Other Field
More than one Network per each Wbs
Relation Lag in %
Uploading MS Project to R/3 PS - Create/Update (189)
· ProjectDefinition, WBSElements, WBSHierarchie, WBSMilestones
· Networks, Activities, Activity Milestones, Relationships and Activity Elements for internal processing
· ActualStart and PercentComplete for WBSMilestones and Activity Milestones
· Factory Calendar, Work Center, Plant, Work Activity, Activity Costs and Control Key
· User Field (Text Numeric Date Flag), Joint Venture and Other Field
Downloading R/3 PS to MS Project (196)
· Same as uploading MSProject and
· Actual Dates and PercentComplete for Activities
· Planned Cost and Actual Cost for Activities
· Calendar with working days, holidays and hours per day
Uploading Excel Tables in CSV format to R/3 PS (218)
· Same as uploading MSProject and
· all Activity Elements (Internal, primary costs, etc as defined in control key)
Downloading R/3 PS to Excel Tables in CSV format (278)
· Same as uploading Excel and
· Actual Dates and PercentComplete for Activities
· Planned Cost and Actual Cost for Activities and Calendar
· Components
Status R/3
· Import System Status for project definition, Wbs elements, network headers and activities.
· Export System Status (set/undo) for project definition, Wbs elements, network headers and activities.
After import the tables StatusProjectDefinition, StatusWbsElement, StatusNetwork and StatusAcivity, edit them in Excel and choose which table should
