Dumping data into tables directly

[Former Member]

Hi there,

Is it possible to just dump data into tables directly (matching file structures)?

Or do we need to use GUI_UPLOAD and then insert them via ABAP statements?

Thanks,

Muji

[Former Member]

Hi,

what is ur requirement exactly.

There are ways to upload data into database table.

u can use XI to uplaod data to SAP.

if it is user data creation, u can create a maintenance dialog and create data thru SE30.

But if u want to insert volumes of data and need them to be validated as well, u post them thru transactions. this is bDC.

If u want to upload master data, u use LSMW or direct input.

If u want to just do direct insert u need to do coding and map the data and insert intot he database,

but for all these u need abap coding which involves uploading and downloading.

[Former Member]

I'm just doing some quick evaluation to use SAP ECC instance as a staging area for data migration.

A seperate sandbox instance of SAP ECC is set up, and the data team will just use this to transform / convert all the incoming source file into the require file format.

1) Set up the Z-tables

2) Upload the data

3) Write programs to manipulate the data into the desired file

4) Use LSMW to migrate.

So I'm assessing if it's easy to just dump data into Z tables from the source files. Any discussion is much appreciated, or other ways of doing it.

Thanks!

Muji

[christian_wohlfahrt]

Hi!

As I understand your question: you search a fast, easy way for 4).

You could make a system copy -> as good as go live with sandbox (on different hardware).

As you don't want to have an exact copy, you think of building up the data (sandbox is more training) -> no direct copy of tables, just think about number ranges of documents (and not only the obvious, but also change documents and so on).

So use standard input methods (BAPI, IDOC,...) of LSMW.

Regards,

Christian

[Former Member]

Hi Christian,

There is no intention of dumping LIVE data into SAP. Maybe I haven't been clear. When I say dumping data into tables direclty, I don't mean copy and paste table MARA. But Z tables that we created for staging area purposes. These have no role in the live business but merely a place where we can transform legacy data, and map them into the required file format for LSMW.

I know we can do mapping directly in LSMW, but the scale of this project requires us to be move the transformation into a new layer.

[christian_wohlfahrt]

Oh sorry, must have stopped reading at point 4) - but you can easily hold all Z-data consistent.

Have a look at FM RFC_READ_TABLE. With this it's possible to read table data from remote systems. Afterwards an insert should be pretty easy. With a little bit effort even a dynamic use might be possible (no fixed structure definitions per table needed).

[Former Member]

Muji,

Unless you load them into internal tables you cannot update the database tables. And you will have to load into internal tables from the file you will have to use GUI_UPLOAD.

No other go.

Regards,

Ravi

Note : Please reward the posts that help you.

[Former Member]

Hi,

Transactional data cannot be done directly. you need to use BAPI/BDC/LSMW.

If it is normal program then you can upload the data using gui_upload and use update/insert statements you can upload,

regards

vijay

[Former Member]

If it is normal table then you can upload the data using gui_upload and use update/insert statements from itab you can save to Table,

VIjay

[christian_wohlfahrt]

Hi Muji!

It's possible to restore a backup, make a client copy or a system copy - but otherwise transaction logic should be used. Some one tables can be filled directly (after GUI_UPLOAD), but for the rest it's normally a bad idea.

Regards,

Christian

[Former Member]

Hi Muji,

1. Is it possible to just dump data into tables directly ?

INTERNAL TABLE IS A MUST.

2. INTERNAL TABLE ---> DATABASE TABLE

3. This internal table

can be populated using GUI UPLOAD, Selct query, FM

etc.

4. But please do not Dump any

data directly into SAP tables.

SAP may stop support

regards,

amit m.