Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

EHS Report Management Document Key

Go to solution
Former Member

‎2014 Mar 19 3:19 PM

0 Likes
1,446


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!!

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2014 Apr 20 9:04 AM

0 Likes
1,041

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.

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.

Reply
2 REPLIES 2
Read only

Go to solution
Former Member

‎2014 Apr 20 9:04 AM

0 Likes
1,042

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.

Read only

Go to solution
Former Member
In response to Former Member

‎2014 Apr 28 4:54 PM

0 Likes
1,041

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