combining sales, purchase and inventory .

[Former Member]

Dear Friends

I need to generate a report .which consists of sales,movements and purchasing info . and they want these charc for the selection . sales org,purch org,vendor,MC,D.ch,purchasing group .

My question how we can combine all these three info into one cube . i tried searched standard Datasource . MM- doesnot have purchase org,purchase group and sales org . Purch- doesnt have sales org billing- doesnot have puchase org and purchse org .

the common charcterstic in all of them are article .so to achevie this . please letme know the solution this very urjent .

thanks

Edited by: Raghavendra Kumar on Aug 13, 2008 8:07 AM

[Former Member]

Hi,

Actually you can quite easily make a report for purchasing and movements all together.

A movement has got a reference to the purchasing document.

But you can hardly get together Sales with Purchasing, there is no common document.

If you use the MM extractors 2LIS_02_ITM and 2LIS_02_HDR, and 02LIS_03_BF, you will get the purchasing org and purchasing group of the documents.

Regards,

Mickael