simple answer: using CG36 you import reports (documents like pdf file word files) in relation to specification master in EHS of any kind. PLease refer to oniline help. The import process is explained very well
RegardinG: Also, would there be a need to maintain spec. database when we are only importing MSDSs
Answer is: may be: you need to have a specification to make the upload. If you would like to distrbute the MSDS within SAP you have interface to SAP MM and SAP SD (in most cases).
You could the document without use of a material number; but the whole topic need to be checked in a project
Re: Do you have to use the specification database?
It depends on what you intend to do with the imported data.
If it is for internal use, such as hazard communication for workers, then you will be interested to know about component extension 4.0 for SAP EHS Management which is planned for release July 29, 2013. It has significant new functionality with respect to managing chemical data for health and safety processes. What does this mean? It means that the chemical data from the SDS can be entered into a new chemical object directly without using the specification database. For customers who are not already using the specification database, this could provide a significantly less costly project. The use of the data is for health and safety processes in operations (manufacturing), for example hazard communication to workers, hazardous substance inventories, risk assessments of chemicals, controls for risks such as personal protective equipment, and so forth. It does not relate to shipping of dangerous goods or outbound SDS. For users of the specification database, there will be data transfer to EHSM 4.0, so that you will not have to create a duplicate process.