Skip to content
ProjectControls.com
Oracle Primavera - PM6

SAP into P3e ??

In the Open Standard
Sundeep NijranMember for 20 years
Created
4
1
0
Has anyone figured out the most efficient way of intergrating the SAP actuals directly into P3e.

I have used the SDK but have found it to be unreliable, can corrupt the whole database.

As SAP outputs in CSV you can have it all merge together in Excel but that defeats the whole idea.

I appreciate that you need to align the WBS and CBS to achieve this and there is a product from Impress that does this but I hear it is too expensive so won’t get sign off.

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Alex Wong ·
    #1
    Sundeep,

    My question is

    What is the level of integration??
    Bi-directional??
    Which modual in SAP is your inteface point CO, IM, PS, PM??
    Is all data in Primavera is going to replicate in SAP??

    I can give you some direction/solution of how the integrate these system if you can provide a bit more information

    Cheers

    Alex
    Report
  2. 0
    Sundeep Nijran ·
    #2
    Hi Alex

    SAP into P3e (uni Directional)

    Modules of SAP are FI, CO

    Level for P3e are not recreated in SAP . SAP is detailed for Materials and Expenses And Labour

    Where as P3e Total Material, Expenses.

    But WBS elements for labour .


    Report
  3. 0
    Alex Wong ·
    #3
    Sundeep

    Since it is one direction, you can use what I call batch integration. (Unless the data is time critical that when you need real time integration)

    By batch processing mean you will have a dump file that generated from SAP daily, hrly, weekly. (Depends on the reporting and update requirement)
    Then by programming either API or SDK you can pick up that file and intergate the resource/material and actual $ into P3e where you can update the activity progress separately.

    There is off the shelf product also enable you to do most of the above task without any tailor made development.

    As a result, your P3e schedule will have all the actual expenses, cost, material delivery forcast automatically.

    Of course, "$" - using this method you will looking @ 1/3 or even less of using Impress. If you need more info I can tell you a bit more details. PM me with your e-mail I can provide you a money saving solutions.

    Alex
    Report
  4. 0
    Dang Corp ·
    #4
    hi Sundeep,

    i have a customer asked me this same question 3 days ago.

    what they wanted to do is, get SAP FI actuals dollars for each PO (purchase Orders).

    and update that into there current P3e plans.
    that way the project managers does’nt need to jump into SAP to look at the actuals and to get a nice S-curve graphs etc.


    this is what they used in the meantime.

    - SAP export the data to CSV (excel format)
    - they get this data and automatically loaded it into P3e, ’User Defined Fields’ UDF.
    - when the UDF have the data for each activities, then they run a "global change" to update the actuals column with that UDF fields.

    I have a movie on my website on explaining this methods more.



    Vu Dang
    http://www.dangcorp.com



    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?