topic Re: dbTab and itab in Application Development and Automation Discussions

dbTab and itab

Former Member — Mon, 28 Apr 2008 07:20:40 GMT

Hi Experts!

I have created a customer specific table with about 80

fields.

On the other hand I have four various internal tables

with data in it. These internal tables must be inserted

into above mentioned db table.

These internal tables must be inserted into db "Z_Customertab"

itab1

itab2

itab3

itab4

Please notice itabs have a different structure than

db table.

How is the easiest way to achieve this implementation?

Reagards

ilhan

Re: dbTab and itab

Former Member — Mon, 28 Apr 2008 07:25:35 GMT

Hello-

I dont think you can achieve your requirement in runtime.In runtime the structure should be the same.

In data dictionary you achieve this by append structure.

Cheers,

~Srini....

Re: dbTab and itab

Former Member — Mon, 28 Apr 2008 07:28:54 GMT

Hi,

Here what you can do is Create 2-3 Loops on these Internal Tables and APPEND or INSERTInsert the Records in the Database Table accordingly, or

another easier way is to create an Internal Table with the Similar Structure of your Database Table then Move the Contents of these Internal Tables into that Internal Table and then Loop this Internal Table and APPEND the contents into the Database Table.

pls write ur code then we may help you better by understanding the Code.

Regards,

Sunil

Re: dbTab and itab

Former Member — Mon, 28 Apr 2008 07:29:00 GMT

Hi,

Create the internal table with reference to ZTABLE

and pass the data of all internal table data to that internal tabel and append to the same.

and go for the inset of the record into ZTABLE.

Hope this will help you.

Regards,

Madan Mohan.

Re: dbTab and itab

Former Member — Mon, 28 Apr 2008 07:29:30 GMT

Hi IIhan,

Create a Final internal table and populate the final internal table with the other internal tables. Now u try to upload data into ur database table

reward if helpful

raam.

Re: dbTab and itab

Former Member — Mon, 28 Apr 2008 07:39:14 GMT

Hi,

I thank you for all these hints.

Sorry I'm not as familiar within the db table insertion and prior looping at itabs.

Can you pls. illustrate that through a little coding

Regards

ertas

Re: dbTab and itab

Former Member — Mon, 28 Apr 2008 08:10:30 GMT

pls. give me a little coding example.

Regards

ertas