10-19-2007 10:50 AM
hi,
I have to generate a report of vendor billing details,where i have to get the corresponding purchase order no for accounting document no.From bseg i am getting the ebeln field but i have fetched based on posting key bschl ='86' or '81'.for the corresponding document no.Without this can i get the ebeln from another table.
'Docu.Dt', 'Posting Dt', 'Bline Dt', 'Docu.No', ' Purchase Or.No'
from,
Dinamol
10-19-2007 11:23 AM
Hi Sasi,
Using accounting document number you can fetch the PO details from MSEG table.
<b>Reward for helpful answers</b>
Satish
10-19-2007 11:24 AM
Hi
use the tables<b> BSIK and BSAK</b> for vendor accounting doc details
it has Vendor and PO number fields in it
don't use BSEG as it creates performance issue
Regards
Anji