PS Budget Reporing

[former_member843258]

Hello dear friends,

I am Jr Ps Consultant. I'm making a PS Budget Development Report for a client. My client wanted to see purchase request and purchase order as reserved budget in this report. I exported these fields as rmba+rmbe from rpsco table with prps objnr, that's correct. But they want to see the purchase request and purchase order documents that are registered in the reserved budget, and they want to go into the documents. I used f-02, Acdoca for Migo in my report. Please tell me from which fields of which table I can bring purchase requisition and purchase order documents to my report in this way. Since the build is progressing with Acdoca from the beginning, could you tell me how to fetch the correct tables and fields with Acdoca if any or not?

Please only people who can really help comment 🙂

Thank you.

Respect,

Gizem Kaya

[raymond_giuseppi]

Coud you look at fields AWTYP, AWREF, AWORG and AWSYS in ACDOCA. Then look at FM AC_DOCUMENT_SENDER to display the original document (movement, vendor invoice, po, pr, etc.)

[Neeraj_Jain]

Hello kygizem,

Please check below tables:

PR - EBAN

PO - EKKO and EKPO

PO History - EKBE

Regards,

Neeraj Jain

[former_member843258]

Hello Neeraj Jain,
First of all, thank you very much for your information. I can transfer f-02 and Migo expenses to my report from Acdoca, and the structure of my report is generally shaped by PRPS, RPSCO and Acdoca. So I am trying to setup a join for purchase request and purchase order from Acdoca.
I used ebeln and banfn fields in my transaction, but this brings purchase requisition and purchase order documents only when I do Migo.
How can I connect them with Acdoca and join them independently?
I would be very happy if you have information about joining the tables you specified with Acdoca. As far as I searched, I couldn't find anything about this join.
Thank you very much in advance.

Kind regards, 

Gizem KAYA

[Neeraj_Jain]

Have you tried EKBE in which you can find PO, MIGO and Invoice number? With these field or vice versa from ACDOCA you can build your logic. Please check.

[former_member843258]

First of all, I am grateful for your interest 🙂 Yes, I tried this way too, but when I go with Migo or document number, only if Migo occurs for the relevant PYP, a purchase request and a purchase order are received in my report. I want to display purchase requisition and purchase order even if I don't have Migo or F-02. Is there any way to this?