topic Re: Dumping data into tables directly in Application Development and Automation Discussions

Dumping data into tables directly

Former Member — Tue, 10 Jan 2006 10:23:41 GMT

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

Re: Dumping data into tables directly

Former Member — Tue, 10 Jan 2006 10:27:12 GMT

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.

Re: Dumping data into tables directly

Former Member — Tue, 10 Jan 2006 10:27:36 GMT

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.

Re: Dumping data into tables directly

Former Member — Tue, 10 Jan 2006 10:29:52 GMT

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

Re: Dumping data into tables directly

christian_wohlfahrt — Tue, 10 Jan 2006 10:31:55 GMT

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

Re: Dumping data into tables directly

Former Member — Tue, 10 Jan 2006 10:32:52 GMT

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

Re: Dumping data into tables directly

Former Member — Tue, 10 Jan 2006 10:34:42 GMT

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.

Re: Dumping data into tables directly

Former Member — Tue, 10 Jan 2006 10:37:23 GMT

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

Re: Dumping data into tables directly

christian_wohlfahrt — Tue, 10 Jan 2006 10:57:31 GMT

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

Re: Dumping data into tables directly

Former Member — Tue, 10 Jan 2006 11:05:47 GMT

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.

Re: Dumping data into tables directly

christian_wohlfahrt — Tue, 10 Jan 2006 12:02:11 GMT

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).