i said that it could be found through the infotype 0007 . we can find wether a posion is vaccant or filled
It's the Vacancy Infotype 1007. The Vacancy infotype allows you to identify position vacancies, at present and in the future. You can create a vacancy infotype record for a position that is occupied, or unoccupied.
The most diffucult question was an SQL query I was asked ... it is as follows you have the following database table sid customer_name commodity lowval highval write a SQL query to get the total profit and loss for each customer and commodity.