07-28-2016 2:21 PM
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.
07-28-2016 3:09 PM
Are MM invoice details not in RBKP/RSEG (RBKP has the field LIFNR)? Why are you going to BKPF/BSEG?
Thanks,
Juwin
07-28-2016 3:09 PM
Are MM invoice details not in RBKP/RSEG (RBKP has the field LIFNR)? Why are you going to BKPF/BSEG?
Thanks,
Juwin