We have created MSDS report from Specification Management and after creation of MSDS, one document entry getting created in DMS. now based on document number, i want to get the information about Generaion Vaiant and Specification from which MSDS dcument got created.
I am unable to find out table name to get information about Generaion Vaiant and Specification which was used to create MSDS report.
I am not sure If I really understood the question correct. This is my intepretation and my answer:
a.) If you have created a WWI document in the specification management system using the standard WWI setup with suitable generation variant (at least the status should be ready as the final status) etc. and this is of type "MSDS" and you are using SAP standard or something similar normally you will get a report/WWI document which you can search for using the report information management (if report is released) or "edit report management" transaction if report not yet released) with the following informations
a.) specifcation key
d.) status of document
e.) (e.g. status net)...
The main information regarding a WWI report created by "create report" is stored in table ESTDH. Using this table you will find the link to DMS (not to archive if you use an archive) because the WWI document generated receives an unique key in the DMS (normally regarding WWI documents this is a document of type SBR and key something like "WWI-....".
Using this key you can search for any WWI report very "easy" in DMS management using SAP Standard transaction to find the corresponding report/document. You can if necessary then download the report if necessary.
Keep in mind that if you use an "archive" that the information given above is not "sufficient" but you need to ask some "archive" expert to get the link to the "real" document
With best Regards
PS: it might be of interest to all that using some EH&S version it is possible to "zip" documents of type WWI. So you can reduce the amount of space needed either in DMS or in achive. It is clear that this technique does have "pros" and "cons". Furthermore there are techniques available to really "archive" existing document (e.g. if they might be "historic" and old enough to be archived; keep im mind, that some legal interpretaiotn is "specifiying" that you need access to such document which might be older than 15 or more years).
PPS: if the question deals with documents which you can upload as user defined text with higher EH&S releases my intepretation is wrong but the basics are still true; in this case you will not ! find an entry in ESTDH. Here you need really ESTVH; ESTVA etc. to get the link to the document
Further addon: the same is true if you are using "inbound" documents. These are link to the specification key by using a generation variant; with SAP Standard the document type "IBD" is shipped. In this case the key to search in DMS is different but the process is the same
As per my understanding, this information is not directly possible to get in any table or structure. You will have to understand that only MSDS template is fixed here, while specifications and generation variant are variables. Specifications are serving for the purpose of converting symbols into values & phrases, while generation variant is restricting the output of the report. Logically there can't be a connection here.
I suggest you to better insert a symbol for specification name as well in your MSDS template. So, everytime you generate MSDS report, you get specification name also in the report. Now for generation variant, you may include "validity area" (under status tab of specificayion) as another symbol, which may give you some help to find out the generation variant.
Another bold suggestion can be of changing the no. range assignment of EH&S document templates (doc. type SBV) to external assignment, where you make it a practice of writing specification name and gen. variant name in the doc. no. itself (alphanumeric) ; but, not sure of it's impact elsewhere.