Relation between MM and PS Tables.

[Former Member]

Hi Gurus,

I´m trying to replicate the functionality of the ME2J trx. (Purchasing docs per Project) and ME5J trx(Purchase req. for project) by developing two diffrent RFC´s, but unfortunalitely I don´t know the relations between the MM and PS tables (Tables/fields).

I know that EKKO and EKPO are the MM tables for Purchase Orders, Eban for Purchase Req. and PROJ for Projects...but ineed the relation between those tables.

Please !!! Any data will be helpfull.

Thanks in advance .

Regards.

Diego.

[Former Member]

Dear Diego,

You want to replicate ME2J, which means you have Project or WBS as inputs and PO's as Output.

Pass the Project in PRPS-PRPHI,

and get all the wbs elements of that project in field PRPS-POSID.

Now Pass the PRPS-POSID values in table EKKN in field PS_PSP_PNR

You will get the POs in EBELN field. (Line Items in EBELP)

For Multiple WBS Assignment in PO, there are further steps but if you are fine with the PO and line items, the above mentioned process will suffice.

For PR, Instead of passing wbs elements in EKKN pass them in EBKN.

You will get PRs in BANFN and line item number in BNFPO.

Take care of the deleted PRs and POs from the field LOEKZ in EBKN and EKKN. (X in this field shows that the document is deleted)

(MENGE field shows the Quantity).

Regards,

Amol Sarode

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.