sp_help displays information about precomputed result set objects in the Object_type column. The SAP ASE server treats precomputed result set objects internally as user tables. When you issue sp_help with a precomputed result set as the objectname, it reports all the relevant details about columns, partitions, keys, indexes, and so on, similar to when you run sp_help against a user table.
For user tables – returns precomputed result set defined in the Object_Status column if any precomputed result set objects are defined on the user table
The refresh mode – immediate or manual
The precomputed result set state – enabled or disabled
The query rewrite state – enable for QRW or disabled for QRW