topic Re: EHS Report Management Document Key in Application Development and Automation Discussions

EHS Report Management Document Key

Former Member — Wed, 19 Mar 2014 15:19:38 GMT

I am working in the EHS module. In ABAP I am using the FM BAPI_BUS1077_GETDETAIL and have tried a number of different VATS to retrieve the Document Key for the reports attached to the specifications without success. In SAP, using transaction CG02BD, enter a specification number. Then from the top menu follow Specification -> Reports -> Report Management. Highlight a released report. Press Utilities -> Administration Information and the Document Key is listed there. Does anyone know how to retrieve this same information in ABAP? That is what I need to complete my program. I appreciate your help experts!!

Re: EHS Report Management Document Key

Former Member — Sun, 20 Apr 2014 08:04:37 GMT

Hi Sue Thorson,

You can query the table 'ESTDH' based on the specification (SUBID) in your program to get the document key (DMSKEY). This table lists all the reports attached to a specification. If you are looking only for released reports, you can refer the field REPSTATUS in ESTDH table. W7 refers Released status.

When you are referring EH&S tables in your program, you should always check if DELFLG is empty. Because when you delete EH&S data, it is only marked for deletion (DELFLG = 'X') and it is not permanently removed from EH&S tables. RC1PHDEL program is executed to delete the entries permanently.

Thanks and Regards,

Kannan Veerapandian.

Re: EHS Report Management Document Key

Former Member — Mon, 28 Apr 2014 15:54:11 GMT

Thank you very much!! This is EXACTLY what I was looking for!