Data upload in SAP

[Former Member]

Hi,

Im uploading an excel file in sap using gui_upload in binary format.In the internal table my data is stored in one column of char type.Now i want to store that internal table data into a single column in my Ztable.Pls tell me how to do that in such a way that i can retrieve that data back from ztable to internal table to the user as the original file.

thanks,

Nidhi.

[Former Member]

Hi,

Im uploading an excel file in sap using gui_upload in binary format.In the internal table my data is stored in one column of char type.Now i want to store that internal table data into a single column in my Ztable.Pls tell me how to do that in such a way that i can retrieve that data back from ztable to internal table to the user as the original file.

thanks,

Nidhi.

[Former Member]

Hi Nidhi,

Try to use the statement MODIFY ztable FROM TABLE internal_table.

or run a loop across internal_table and use the stmt : INSERT INTO ztable VALUES wa.

Thanks,

regards,

akshay ruia.

[former_member222709]

To retrieve the data from the Z Table, you need add a column in your Z Table which may the Username, Date, Time or any identifier to uniquely identify all the records for that particular file.

In the select query, the same identifier can be used to retrieve data successfully.

Regards,

Pranav.

[Former Member]

the internal table in which im getting data from user has one column which has datatype char(1000).So the filedata is stored in 12 rows in this internal table in binary format.while saving it in Ztable i concatenate all the rows and save in a single row in Ztable.But while retrieving data how do i split data and get it back in the internal table in 12 rows as the data is in binary format.

Nidhi.

[Former Member]

Hi,

you could add a column "row number" to the key. And then instead of concatenating the rows, save each row in a seperat db row.

Best regards,

Oliver