Images in database

[Former Member]

Hi all,

I have a requirement where i want to upload images into a database table and then retrive it back in a pop-up window.

This is to be attained using a report.

Can anyone give me an idea how can i achieve it, any function modules available for this

Should the data type of the table field be RAW string.Certain tables which has this datatype gives a raw converted format how can this be converted back into an image

[Former Member]

Hi all,

I have a requirement where i want to upload images into a database table and then retrive it back in a pop-up window.

This is to be attained using a report.

Can anyone give me an idea how can i achieve it, any function modules available for this

Should the data type of the table field be RAW string.Certain tables which has this datatype gives a raw converted format how can this be converted back into an image

[anversha_s]

HI,

it is alwys better to store the image path. it is more memory saving and fast.

for that u need only a string to save the image path and save it in DB

so not the image is directly saved.

Rgds

Anver

<b><i>if hlped kindly mark pionts</i></b>

[Former Member]

Hi Anversha,

Can you please help me out how images can be saved into database and how it can be accessed using the path

[anversha_s]

hi,

if your requiremnt is to use an image in ur program, then no need to store by urself.

SAP will do it by itself. look this

Steps for uploading IMAGE :-:

1. Goto the transaction OAER

2. Enter the class name as 'PICTURES'

3. Enter the class type as 'OT'

4. Enter the object key as the name of the logo you wish to give

5. Execute

6. Then in the new screen select Standard doc. types in bottom window

Click on the Screen icon

Now, it will ask for the file path where you have to upload the logo

7. Now you can use this picture in REUSE_ALV_COMMENTARY_WRITE

Here you go !!

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
EXPORTING
IT_LIST_COMMENTARY = IT_LISTHEADER
i_logo = 'LOGO_NAME'   "just give that picture name
* I_END_OF_LIST_GRID =
.

rgds

Anver

if hlped pls mark points

[Former Member]

<b>Please check this link which discusses all solution for your problem,</b>

Regards

Kathirvel