We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE: [sap-acct] Material Numbers Created During the Year

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from KenThomson on Nov 28 at 6:56 PM
Hi.

You can get the created on date information from SE16N from table MSTA where MSTA-MATNR = the material code you are interested in ? the created on date for the plant in question is where MSTA-STATM = 'B' and MSTA-BWKEY = the plant code you are interested in.

You can get the current live standard cost from table MBEW where MBEW-MATNR = the material code you are interested in and where MBEW-BWKEY = the plant code you are interested in.

If you want past years standard costs you can use table MBEWH for that ? but do some research on this table as it does not always have an entry for the material + plant you are interested in for every single year + period. Some periods can be missing from that table ? research how SAP updates entries to this table to understand why.

Regards,

Ken

---------------Original Message---------------
From: Betty
Sent: Monday, November 28, 2016 9:12 AM
Subject: Material Numbers Created During the Year

Need to run a report in SAP by Fiscal Year that will give me all Material Numbers that were created during the year (creation date) and the Standard Cost

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
© 2016 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
KenThomson  

achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Become a blogger at Toolbox.com and share your expertise with the community. Start today.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language