export/import to/from database

[Former Member]

hi,

i do not know what is this for. i read the help but still no idea.

i know to use export/import to/from memory id and also set/get but not export/import to/from database.

1) what help says it stores data cluster? what is data cluster

2) can have example of export/import to/from database?

3) what is the different for export/import to/from memory id and database?

thanks

[seshatalpasai_madala]

Hi,

1) A data cluster is a set of data objects grouped together for the purpose of storage in a storage medium(Like database, local memory or shared meomory etc), which can only be edited using ABAP statements like EXPORT, IMPORT and DELETE.

2) Suppose you want to export the data in a internal table to database.

Here TABLE_ID is the identifer of your data cluster. You are exporting your data to a SAP table INDX and giving it an ID (TABLE_ID in this case and this ID you are giving it an area by name XY where your data will be stored). EXPORT tab = itab

TO DATABASE indx(XY)

CLIENT '000'

ID 'TABLE_ID'.

You can get this data as follows.

IMPORT tab = itab

FROM DATABASE indx(xy)

CLIENT '000'

ID 'TABLE_ID'.

3) The difference is simple when you use MEMORY ID the data you export is stored in the application server MEMORY where as in the case of DATABASE it is stored in the database.

Regards,

Sesh