Database Download

[Former Member]

Hi,

I wanted to download all the data from database table to file with field name.

Anybody will suggest me the code.

[Former Member]

Hi,

I wanted to download all the data from database table to file with field name.

Anybody will suggest me the code.

[Former Member]

Hi neha,

Use Extract the data into some internal table with all the required fields then use GUI_DOWNLOAD Function module if u want to download into presentation server , if u want to download in appl server then use open dataset, transfer and close dataset.

Regards,

Shafi

[Former Member]

hi

i given this syntax check this

OPEN DATASET [DATASET NAME] FOR [OUTPUT / INPUT / APPENDING]

IN [BINARY / TEXT] MODE

AT POSITION [POSITION]

MESSAGE [FIELD]

READ DATASET [DATASET NAME] INTO [FIELD]

DELETE DATASET [DATASET NAME]

CLOSE DATASET [DATASET NAME]

TRANSFER [FIELD] TO [DATASET NAME]

regards

praveen

[Former Member]

Hai,

Follow these steps:

<b>Step 1:</b>First declare an internal table of Database table type like:

Data:

begin of itab occurs 0.

include structure database_tabe_name.

data:

end of itab.

<b>Step2:</b>

Write a select query to retrive all dbtable data into otab.

Select *

from db_table

into table itab.

<b>Step 3:</b>

Call FM GUI_DOWNLOAD by passing itab and mensioning the FILE PATH and FILE NAME.

Hope now you can get all the data into your file.

<b>Reward points if it helps you.</b>

Regds,

Rama chary.Pammi