11-05-2016 4:10 PM - edited 02-03-2024 5:12 PM
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!
User | Count |
---|---|
7 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.