topic Decode SDOKCONT1.CLUSTD in Application Development and Automation Discussions

Decode SDOKCONT1.CLUSTD

Former Member — Sun, 04 Apr 2010 13:52:10 GMT

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

Re: Decode SDOKCONT1.CLUSTD

Sandra_Rossi — Sun, 04 Apr 2010 21:00:15 GMT

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.

Re: Decode SDOKCONT1.CLUSTD

Former Member — Mon, 05 Apr 2010 06:24:14 GMT

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

Re: Decode SDOKCONT1.CLUSTD

Sandra_Rossi — Mon, 05 Apr 2010 08:36:13 GMT

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.

Re: Decode SDOKCONT1.CLUSTD

Former Member — Mon, 05 Apr 2010 10:48:57 GMT

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