topic Re: Get purchase order list from Project in Application Development and Automation Discussions

Get purchase order list from Project

Former Member — Wed, 12 Dec 2012 05:38:42 GMT

Hi,

how to collect purchase order list from given project name ,

here i need table name , i have search via tcode ME2J but it is not helping me i have perform sql trace on ME2J after then get all the table details even it is not useful for me.

Avirat

Re: Get purchase order list from Project

Former Member — Wed, 12 Dec 2012 05:56:13 GMT

identify WBS element from project and query it with ekkn field - ps_psp_pnr , then you can further move to ekko/ekpo.

Re: Get purchase order list from Project

Former Member — Wed, 12 Dec 2012 06:13:18 GMT

Hi,

you can get posid in table prps and in prps you have pspnr which you can query with ekkn with the field ps_psp_pnr to get the purchase orders.

thanks.

Re: Get purchase order list from Project

Former Member — Wed, 12 Dec 2012 06:42:44 GMT

Can you elaborate...?

Re: Get purchase order list from Project

Venkat_Sesha — Wed, 12 Dec 2012 07:02:15 GMT

Please check this Table RESB. Here you have Project Number PROJN and Purchase related data BANFN and all other Order related data AUFNR.

Please have a look into this table. Then you can drill down to tables PROJ, CAUFV, RESB, EKPO, EBAN, EKKO, EKBN etc.... Hope this helps

Re: Get purchase order list from Project

Former Member — Wed, 12 Dec 2012 07:05:49 GMT

Hi,

1> If you have internal project description (pspnr) in table PROJ you can get the corresponding external project description in PRPS (filed pspid) for this pspnr In EKKN you have field ps_psp_pnr. Using this field you can get purchase order document.

thanks.

Re: Get purchase order list from Project

Former Member — Wed, 12 Dec 2012 07:09:11 GMT

details mapping.

PROJ-pspnr-------get pspid.

PRPS--posid(which is same as pspid of PROJ) -----get pspnr..

EKKO--ps_psp_pnr(which is same as pspnr of PRPS)---------ebeln.

thanks.

Re: Get purchase order list from Project

RaymondGiuseppi — Wed, 12 Dec 2012 07:24:21 GMT

Suggested steps

Get the whole project hierarchy objects list (e.g. PROJ->PRPS->AUFK via foreign key relations or FM like GET_PROJECT_HIERARCHY or GET_PS_OBJECTNUMBER)
Cross the list of object with table EKKN for WBS and Orders.
Then join with EKKO, EKPO, EKBE, etc.

Regards,

Raymond

Re: Get purchase order list from Project

Former Member — Wed, 12 Dec 2012 07:46:30 GMT

Thank you friends...

Query has been solved.

Avirat