Get purchase order list from Project

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

Can you elaborate...?

[Venkat_Sesha]

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

[Former Member]

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.

[Former Member]

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.

[RaymondGiuseppi]

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

[Former Member]

Thank you friends...

Query has been solved.

Avirat