From Invoice to PO

[Former Member]

I'm not sure if I got this in the right spot. I normally don't handle this part of SAP, hence the question here. I'm trying to confirm some numbers I was given. I need to get a list of Invoices that were posted in the month of Feb. by a certain payer. Then I need to take that list and get the appropraite POs of the sales orders that they belong too. Can anyone help me out with any report names or table names? Any information would help.

Thanks in advance,

Curits

[Former Member · Accepted solution]

Hi

Kindly check the belwo

Report :VF05n

Tables :VBRK ,VBRP & VBFA

Regards

Damu

[Former Member]

You can find the sales order nos in the VBRP table AUBEL field . You can then pass this in VBFA table, preceding doc with subsequent document category as V- Purchase order. You can rty sqvi for this

Conversely you can use VBFA twice by entering invoice no in follow doc and preceding doc category as C. Then you can pass this in VBFA table with subsequent document category as V- Purchase order.

[manthana_c]

Hello:

VF05 :report by PAYER

FBL5N : report by Customer Account (payer) and click Dynamic Selection button then put Document type = RV, open key date can be up to end of feb.

Hope this help.

Best Regards,

Manthana