Query for list of specifications

Hi Experts,

We need to execute query which should contain list of specifications with and without material assignments.Selection criteria is based on generation variant.

Please let us know from which tables we can get the above list.

Thanks for your help!!

Regards,

Sivasankar

Message was edited by: Sivasankar P

Message was edited by: Sivasankar P