cancel
Showing results for 
Search instead for 
Did you mean: 

EHS and DMS

Former Member
0 Kudos

Dear Experts,

In transaction EHSAMBTAET, "Documents" tab, I need to know where values in fields "Object type" and "Object" are coming from.

In other words, I need to know in which DB tables are stored the links between Documents and Medical Services/Persons.

I have tried to find the related DB tab in several ways but without any success.

Could you please help me?

Thank you very much

Regards

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Same requeriments here, at this server, the data (ehsambtaet, fill pernr and press enter, change to document tab) could be retrieved (copied from the standard) this way:

  DATA lt_estdf TYPE TABLE OF estdf.
  DATA lv_person_id LIKE ehs00fbpersdat-person_id.
  DATA lv_intpernr TYPE ehs00fbpersdat-pernr.
  DATA lv_recnmst LIKE estdf-recnmst.
  DATA lt_drat TYPE TABLE OF drat.

          lv_person_id = pa0002-pernr.
          CLEAR lv_intpernr.
          CALL FUNCTION 'EHS00_CHECK_PERSONID'
            EXPORTING
              i_person_id       = lv_person_id
*             I_PERSON_FLAG     = ' '
              i_intpernr_create = 'X'
            IMPORTING
              e_intpernr        = lv_intpernr.
          IF lv_intpernr IS NOT INITIAL.
            lv_recnmst = lv_intpernr.
            REFRESH lt_estdf[].
            SELECT * FROM estdf INTO TABLE lt_estdf
              WHERE recnmst EQ lv_recnmst
                AND valfr LE sy-datum
                AND valto GE 2.
            IF lt_estdf[] IS NOT INITIAL.
              REFRESH lt_drat[].
              SELECT * FROM drat INTO TABLE lt_drat
                FOR ALL ENTRIES IN lt_estdf
                WHERE dokar EQ lt_estdf-dokar
                  AND doknr EQ lt_estdf-doknr
                  AND dokvr EQ lt_estdf-dokvr
                  AND doktl EQ lt_estdf-doktl
                  AND langu EQ sy-langu.
0 Kudos

Good day. Where can this code be found in the standard? In which function group/function module? Thank you.

Former Member
0 Kudos

Hi,

The document is in DRAW table, but it is not in DRAD. I think EHS does not use the standard DMS linking in this case, so the link can’t be found in any DMS table, and the link type cannot be found in TC dc10.

The system uses standard FMs ”EHS00_DMS_*” to open, close, and retrieve documents linked to medical services and persons. So at low level, these FMs must be accessing to the tables I’m looking for, but after several debugging hours and google search, I couldn’t find it and finally decided to post this message.

Thanks for your comments,

Kind regards,

former_member191252
Active Participant
0 Kudos

Jos,

DRAW is for Document and reason I mentioned about DRAD  is, DRAD is more about the Document-Object Link.

I think couple of days back, one of our Expert (RVN Prasad G) conformed that there is not "standard object link available for medical services".

--

former_member191252
Active Participant
0 Kudos

Hi Jos,

Did you check DRAD table ?

--

Former Member
0 Kudos

Hi Jos,

There is no standard object link available for Medical Service/Persons in OH of EHS. So you cannot find any standard linking between Medical Services/Person and DMS and it will not be available in DRAD table.

Thanks,
Prasad.

jagadeesh_gn
Employee
Employee
0 Kudos

Hi Prasad,

Please confirm you have configured doc and doc type in transaction dc10.

Usually the Type would be OHD

You can find docments uploaded in table DRAW with doc type OHD.

Thanks

Former Member
0 Kudos

Hello Mr.Jagadeesh,

I know which document type needs to be used in OH of EHS and just replied Jos query.

Thanks,

Prasad.