topic Re: Finding Purchasing Document Numbers in Application Development and Automation Discussions

Finding Purchasing Document Numbers

Former Member — Fri, 09 Mar 2012 15:38:02 GMT

I have a DART download of Accounting Documents (FI), from BKPF, field BELNR. I want to find the matching Purchasing Document Numbers in a DART file (MM), from EKKO, field EBELN. Any ideas on how I could link the two in order to match Purchase Orders to paid Invoices?

Thanks

David Britain

Re: Finding Purchasing Document Numbers

kesavadas_thekkillath — Fri, 09 Mar 2012 18:36:16 GMT

You should have a look at table rseg

Re: Finding Purchasing Document Numbers

Former Member — Mon, 12 Mar 2012 15:46:28 GMT

Thanks for the response Kesavadas. Unfortunately, RSEG is not accessable from DART (not listed in the segments). Any other thoughts before I request a data download for RSEG from our outsourced IT provider?

Thanks,

David

Re: Finding Purchasing Document Numbers

kesavadas_thekkillath — Tue, 13 Mar 2012 12:10:45 GMT

Hi,

You can view my reply here http://scn.sap.com/thread/2132959 to know how the PO GR & paid invoices are related, other than this I do not see any easy way to link it. You can also do it through table EKBE differentiating the GR & Invoice using the BWART( Movement type ) & other fields ( I don't remember exactly ).