on 03-02-2015 7:01 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jos,
Did you check DRAD table ?
--
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.