How to upload images into database.

[Former Member]

I have a employee table. I want to upload the image of the corresponding employee. How can we achieve this ??

Edited by: Manjunath CN on Oct 14, 2008 2:15 PM

[GauthamV]

hi,

you can upload images using SE78 or SMW0 transactions.

[Former Member]

Go to OAER Transaction and provide

CLASS NAME: PICTURES

CLASS TYPE: OT

OBJECT KEY: IMAGES (Could be any name)

and execute.. you will be directed into business document navigator.

now, you can find left down corner you can find standard document types. There you expand the node and select 'Screen' node. Right click on node and click on upload button. Now, your impage will be uploaded. Like that you can add number of images.

I hope it will be useful.

[Former Member]

Hi Karthik,

I have done the same. But How can we relate the image to the employee number.

[Former Member]

Hi Manjunath,

Please check Sikindar post in this link

Tcode OAAD. 
Click on the Create button. Business object PREL and Docyment type HRICOLFOTO. Click on create (fill in the right personnel number in the pop up and click Continue).
Choose the photo (as a JPG file) from the place where it is saved (e.g. hard disk). SAP will notify that the Stored Document was created succesfully.
Photo is visible via PA10, PA20, PA30, PA40. Double-click to magnify photo.

Best regards,

raam

[Former Member]

Check this link

http://www.sd-solutions.com/documents/SDS_Employee_Photos_v4.6.html

[Former Member]

Hi Kodand,

I have done as per yur post in OAAD. But i am getting the error as "Repository A2 not accessible by HTTP"

[Former Member]

Hi,

Use OAOH tcode...

check this link for step by step..

http://it.toolbox.com/wiki/index.php/Upload_a_photo_in_SAP_HR

Regards,

Omkaram.