Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Material sales report.

Former Member

‎2006 Mar 18 3:51 PM

0 Likes
787

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!

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!

Reply
4 REPLIES 4
Read only

Former Member

‎2006 Mar 18 4:44 PM

0 Likes
657

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

Read only

Former Member

‎2006 Mar 19 3:14 AM

0 Likes
657

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

Read only

Former Member

‎2006 Mar 19 3:29 AM

0 Likes
657

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

Read only

Former Member
In response to Former Member

‎2006 Mar 19 2:23 PM

0 Likes
657

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 ?