Material sales report
I have some troubles writting a sales report. The problem is that, in my case, sales are processed in another application, interfaced with SAP, so sales orders & stuff are automaticaly made, so I only see the sales in reports. I don't really know from what tables to get the data. I saw that I can find sales orders in VBAK and VBAP tables, but these sales orders doesn't produces goods issues, so I don't really care about them. I am interested for materials that were sold out from my warehouse, with 251 moovement type in my case. I also took into consideration the possibility to extract the data from the MSEG table, with 251 moovement type. What do you think about this? And another issue is where to get the profit margin for that sale.