Minimum value

Hi Gurus,

I have 2 small requirements for my object.

1)I have to select the Minimum value of field AUFNR from table AUFK. Is there any command for that instead of using a select query.

2)Also i have to extract the common values from 2 internal tables and then I have to select the minimum value.

Could anyone let me know about the solution for the above 2 issues.

Thanks

Natasha SS.