Issue with PP-PI report

[Former Member]

Dear PP-PI Expert!

I already searched many forums on internet about this subject, but i have not got any answer about this issue

I want to collect the pp-pi datas which is inputed into SAP system with TCODE CO54, CO53,CO60,

The follow process is:

1.Generate Control recipe of Process Order(PO)

2.Use TCode CO53 , send Control Recipe

3.Use TCode CO60, find the PO which is sent control recipe, then open it for input pi-datas, if finish, we complete this

4.Use TCode CO54, send the complete pi-sheet .

now, we want to collect these pi-datas with ABAP, but i cannot determine where is PI-data store, what's table and what's function to get data ...

Right now, we only see PI-sheet data of only process order by process order , we cannot get datas for analysis and make decide.

so, Dear PP-Pi expert, pls help me to get out pi data for analysis.

I already ask the consultant, who is implement my system, but they did not know.

Thanks for your support!

TDiep.

[former_member189817]

Hi

check with tables AFFT and AFFV.You can also use FM to display the data in PI sheet against Process order.

Regards,

Velmurugan S

[Former Member]

Thanks Velmurugan S !

Could you give me the FM name? base on this FM, i will try to get the pi-datas in PI-sheet against process order.

Regards.

DiepNguyen

[Former Member]

Hi everybody,

Could you help me the Function Module name which is use to get the pi-datas in PI-sheet against process order.

Regards,

DiepNguyen

[Former Member]

Hi everybody,

Could you help me the Function Module name which is use to get the pi-datas in PI-sheet against process order.

Regards,

DiepNguyen

[former_member189817]

Hi

Please try with this FM PI_SHEET_GET_LIST

Regards,

Velmurugan S

[Former Member]

Hi Velmurugan S

Sorry for late,

The FM PI_SHEET_GET_LIST is not get PI-data as i need.

You can check this Programe RMXTP_PISHEET, i want to get PI-data which is show on this screen then i collect it for analysis....

Regards,

DiepNguyen

[Former Member]

All information about process messages is stored in tables COME and COMH. These are the data that come into SAP, once the process messages have been generated, after PI Sheet closing.

Process Instructions (From SAP to PI Sheet) are in tables COFV, COFT.

Regards

[Former Member]

Thanks Dario for your information.

But how can we get the datas that we already key in for PI-sheet.

I knew table POC_DB_VALUE content pi-datas, but i don't know how to get it out.

Could anyone help me!

Regards,

DiepNguyen.

[Former Member]

Hi everyone!

Pls help me.

Thanks all.

Edited by: Diep . Nguyen on Feb 26, 2011 3:20 PM

[Former Member]

Hi ,

I was ABAP consultant before. You need to check is this POC_DB_VALUE is table or structure . If this is structure , you are not able to do anything except some debugging by abap to "catch" the value. If this is table, you should find is there any way to link this data out.

Hope can help you.

[Former Member]

Hi Kent9999 ,

Thanks for your reply .

It is a table, storing every PI data which input by end user.

But, this table was encode, i don't know what way to link this data out.

Pls help me on this.

Thanks & Regards!

DiepNguyen.