Decode SDOKCONT1.CLUSTD

[Former Member]

Hi All,

I wish to know is there any Function Module which will help decode the field SDOKCONT1.CLUSTD

This is the field where the employee pic is stored in LRAW (hexadecimal) format.

e.g. we used READ_TEXT to decode STXL.CLUSTD

Thanks!!

[Sandra_Rossi]

You don't need to decode, you must use SAP APIs to read it: SDOK* function modules. See [SAP Library - DMS programming interface|http://help.sap.com/saphelp_nw2004s/helpdata/en/3c/4d26696ab411d3aece0000e82deb58/frameset.htm] and forum for further information. People also use ARCHIVOBJECT_GET_TABLE.

[Former Member]

Hi Sandra,

So many function modules in SDOK series.

I am in kind of a fix. I actually want to display employee photos along with their other details in crystal reports. I am working on SAP ECC6.

I actually dont know for sure how and where the employee pics are stored in the SAP database.

Currently i assume that the employee pics are in location SDOKCONT1.CLUSTD.

Contents of this field are Hexadecimal and the type LRAW (String 64000).

Can u please confirm that i am looking at the right place? and if not thn where i would find the employee pics?

and if this is the right field then i assume that there must be some specific Function Module to convert these Hexadecimal contents into a jpeg?

Can u help.

Thanks a lot already

[Sandra_Rossi]

Could you tell more about the values of keys you have to access SDOKCONT1 (object id + class?), how pictures were stored in your SAP system (GOS, BDS, Mime repository, name of external software...), etc.?

If you have object id and a class of type PH(ysical), you may extract the image using SDOK_PHIO_LOAD_CONTENT only.

[Former Member]

Ummmm...

What i want is to display some employee details along with their photographs; in a report developed in Crystal Reports.

Rest of the data i can get from usual HR tables, but i am unable to find their pics. I have employee PERNR to locate their pics.

How can i do it