Skip to Content
author's profile photo Former Member
Former Member

PI table for action/task statuses

I have a requirement to take a few fields from one PI table and process it further.
I'm having a problem locating the tables.

My client has defined the request like this:
They want to create a demo for data extraction from SAP PI to MS SQL.
They would need to process the Action table.
They need 2 fields passed to MS SQL: Action ID and Action Status.

Does it sound familiar? Action IDs and statuses for tasks/actions in PI?
Further explanation by client:
"What the integration needs to achieve from a functional perspective is that if tasks are updated manually ie by user in SAP (ie using SAP Task Manager - i think this is what SAP call their module to manage tasks/actions?), then in our database the corresponding Actions also have their status updated automatically by updating data from SAP to SQL."

Since I'm new to PI, I don't have an idea which table do I need to take a look at,
and use in my code to export it to SQL.
Technical part is easy, ABAP to extract the data, DBCON to connect to SQL and
then insert statement to write data to SQL.
Been there, done it easily in FI,CO,PP,SD... but PI is very new to me.

I wanted to get a clarification of the actions/tasks in PI, what are those, and what are their
statuses, and which tables to take a look at?
If anyone has idea on which table this could be I'll highly appreciate it...

Regards and happy new year!!!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jan 02, 2014 at 05:32 AM

    Hi Mihailo

    You can connect to MS SQL from SAP PI/XI using JDBC adapter. Once the JDBC drivers are deployed & connection is established, develop an interface to insert records in MS SQL database table.

    Please check below URL for the steps to configure JDBC adapter. Also you can google for sample scenarios on this.

    http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

    Thanks

    Sasidhar Gupta

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 02, 2014 at 07:24 AM

    Hi Mihailo,

    From my point of view if you want to extract data from SAP ERP or SAP PI ABAP system you would do a RFC o proxy over the ABAP tables. If you want to connect a PI system you can follow the steps pointed in this document http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac1399242f?quicklink=index&…

    Pay attention that depending of your PI version something cold be done differently.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 02, 2014 at 10:24 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 08:14 AM

    Thank you both for the answer I'm OK with the technical part of the story
    I just need the table name for actions/tasks in PI since I'm not familiar
    with PI functionality at all.
    A short explanation on what these actions/tasks are, what Task manager is,
    which tables are used for the actions/tasks statuses would be great help.

    Add a comment
    10|10000 characters needed characters exceeded


    • Hi Sundic

      If you are able to manage establishing connection to MS SQL database and build an interface in PI, below are the things you need to get

      - You can implement a BAPI to fetch data from SAP tables. Since you are not sure about system, please check with your client team/functional colleagues for system id and table where they store data. Develop a function module to query the database and call the BAPI to bring data into PI.

      - In PI, you can do the required transformations as per your target table structure definition. Again check with your client team for table details in MS SQL. You can develope SQL statement or procedure to update table in MS SQL.

      System & Table details need to be checked with client team or functional team.

      Thanks

      Sasidhar Gupta

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.