Create a list/query with cost and sales prices? Or is this standard?

Hello.

I need to create a list that looks something like this:

MATERIAL-NAME COST-PRICE SALES-PRICE

IceCream2000 $40 $80

I want all of our materials included in the list/query.

Can anyone please help me?

I have tried myself, but when i use the tables i believe i should use, with SAP-Query, i get an error message telling me that the table cannot be used in a join.

I have unfortuneatly no ABAP skills 😔

Any answer will be rewarded.