topic Re: Material sales report. in Application Development and Automation Discussions

Material sales report.

Former Member — Sat, 18 Mar 2006 15:51:04 GMT

Hello,

I have a problem with a material sales report. I want to see when a material was sold and how much. From the MCHP transaction I saw S083-SPTAG as the date fields, S085-MATNR, S085-UMSMNG as the quantity. But this tables probably are used only for calculation...

Can anyone help me with the right tables?

Thnk you!

Re: Material sales report.

Former Member — Sat, 18 Mar 2006 16:44:43 GMT

Hi George,

Welcome to SDN.

Please take a look at this link.

http://www2.warwick.ac.uk/services/finance/sap/training/salesguides/salesreports/

Hope this will help.

Regards,

Ferry Lianto

Re: Material sales report.

Former Member — Sun, 19 Mar 2006 03:14:07 GMT

T-code VA05 allows you to view sales orders for a material. This info is stored in table VBAP - sales order detail table.

Re: Material sales report.

Former Member — Sun, 19 Mar 2006 03:29:33 GMT

HI George

you can get all details of the Sales order items in VBAP table and the header details in VBAK

VBAP-MATNR

VBAP-KWMENG

regards

kishore

Re: Material sales report.

Former Member — Sun, 19 Mar 2006 14:23:31 GMT

Thank ypu for your answer.

But I need to select material sales finalised with a goods issue, in my case moovment type 251. I saw that many materials from VBAP tables don't have goods issue...Would it be better to select data from MSEG table with moovment type 251 ?