Skip to Content
author's profile photo Former Member
Former Member

Extract purchase and sales prices info based on limited information in SAP

Hello,

I've got three scenario's where i have limited information to look up other data in SAP, if possible. I'd like to know a table (accessible with se16n?) or a transaction to complete the search.

Background info to help solve the question:
All articles in SAP have integer unit numbers (i.e. correspond with physical articles, no bulk goods), one purchase price / supplier and one sales price / sales point. Suppliers are always between 1-3 for one article, sales points for each article are plenty (100+).

______________

Scenario:
- - - - - - - -

1)

Given: A list of SAP article Nr.s, Supplier Nr., purchasing company (your own) Nr.

(Not available: Any PO or invoice data.)

Requested info: Purchase prices of the requested SAP articles for the given supplier ( a list of all purchase prices without supplier filter will also do). - MM43 will not do, too time consuming to do for all articles.

2)

Given: Purchase price / unit (as can be seen in transaction mm43 in tab purchasing if you select a supplier)

(Not available: Any PO or invoice data.)

Requested: All SAP articles with a supplier with that purchase price in the system.

3)

Given: Final purchase price of an item, this includes VAT, commission, etc as can be seen in mm43 transaction in the sales tab if you specify a sales point and calculate final price.
The VAT/commission itself is not specified.

(Not available: Any PO or invoice data.)

Requested: All SAP articles with that final sales price in one of the sales points in the system.

______________

I need this to try data mining info based on limited available info i get from collegues.

Txs a lot to everyone for you assistance!

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.