Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

dbTab and itab

Former Member
0 Likes
984

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
921

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.

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

6 REPLIES 6
Read only

Former Member
0 Likes
921

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

Read only

Former Member
0 Likes
921

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

Read only

Former Member
0 Likes
922

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.

Read only

Former Member
0 Likes
921

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.

Read only

Former Member
0 Likes
921

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

Read only

Former Member
0 Likes
921

pls. give me a little coding example.

Regards

ertas