One of its main purposes is for possessive, but it is also used for noun modification. You can kind of think of it as possessive though.
つくえのうえ - means "the top of the desk/table". Or "the table's top". In English the second is not quite natural but it makes sense.