Pricelist column wise
When I develop a query with tables ITM1 and OPLN , it returns me the different pricelist like purchase price , sales price etc in for a particular item in different rows.I want it to return the output where for a single item it should return the pricelist columnwise.
Pls advise how to do it.
The same Sub SELECT will not work or Alt Items. We need to handle this differently