Skip to Content

How to check which vendor was used during posting on PO

Hi Guys,

I have a list of POs and I am looking for best way to check which vendor was used during posting invoice on particular PO.

It is obvious that only invoices related to specific vendor (for which PO was created) should be posted there but if we have a process of invoicing party then it is possible to post an invoice against different vendor. Such posting would look like this:

Dt GRIR account PO created for vendor XXX
CT Vendor account YYY

while standard posting looks like this:

Dt GRIR account PO created for vendor XXX
CT Vendor account XXX

In BSEG table I can choose all documents posted against defined list of POs but vendor number will be visible only for GRs postings and all will be related to vendor for which PO was created so XXX.

I am considering this way:
1.Get MM numbers of all documents posted against POs from EKBE table

2. Find FI doc numbers basing on MM numbers in BKPF

3. Extract vendor number from BSEG

Maybe there is a better way to do it?

Also I am curious why searching by POs in BSEG gives different results than checking by doc number.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 28, 2016 at 02:09 PM

    Are MM invoice details not in RBKP/RSEG (RBKP has the field LIFNR)? Why are you going to BKPF/BSEG?

    Thanks,

    Juwin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.