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

[former_member277592]

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!