link between purchase order & reservation

[Former Member]

We have one report for project purchase order where we need to have relation between Reservation & purchase order( or Purchase requisition)

Can you provide table linkage between them through table so that I can get Reservation no. for purchase order.

Thanks,

Kiran

[Former Member · Accepted solution]

Hello Kiran,

Also check following in RSDBS table.

RSNUM = Reservation

BANFN = PURCHASE REQ.

EBELN = PURCHASING DOC.

Regards

Tushar

[Former Member]

Hi Kiran,

The table is RSDBS.

Either pass BANFN (P.Req) or EBELN (P.Doc) to get the RSNUM (Reservation Number).

Regards,

Amit Rajoria

[Former Member]

I have entered data in the above tables given by you but not success . I am getting network & activity no . in report CN52N & against that purchase requisition. Can I please know from which table this report fetches data.

[MTerence]

Hi Kiran,

You want to fetch the purchase requisition through network.

1. Pass Network number into RESB Table, you get the Reservation Number / Operation/Activity / routing no of operation / Purchase requisition number

2. FromTable AFVC you can get the service PR and Service PO number.

3. Pass the same Purchase Req to EBAN and get the line items / PO number

4. Pass the PO number in EKPO.

You will need to look into the GR/IR documents to get the actual costs.

Regards

Terence

[MTerence]

Hi Kiran

Adding to Varshal....

Three tables

RESB - reservation

EBAN - PR

EKPO - PO

Regards

Terence

[varshal_kachole3]

Hi,

Please check if the below makes any sense:

RESB-BANFN = EBAN-BANFN

RESB-BNFPO = EBAN-BNFPO

Hope it helps!

Thanks and Regards,

Varshal Kachole