Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to check which vendor was used during posting on PO

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Juwin
Active Contributor
0 Kudos

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

Thanks,

Juwin

1 REPLY 1

Juwin
Active Contributor
0 Kudos

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

Thanks,

Juwin