topic Re: insert data from internal tables into structure table. in Application Development and Automation Discussions

insert data from internal tables into structure table.

Former Member — Mon, 13 Aug 2012 19:25:52 GMT

Hi good day, i have a question about report, I have 2 structure table, so these have differents fields and information, i need to get the information and save it into new structure table.

How can i do it? I .

I already created the structure with all fields from two tables and the same data types.

Table 1 has 5 records, Table 2 has 50 records,

I have tryed with Loop:

Loop at Table1

move Table1-field1 to New_structure-Field1

move Table1-field1 to New_structure-Field1.

.........................

ENDLOOP.

LOOP AT TABLE2

move Table2-field2 to New_structure-Field2.

.............................

ENDLOOP.

It works, and retrieve records from both tables, but result set is according to first table, i mean, total rows are 5.

Thank you for all your advices!.

Re: insert data from internal tables into structure table.

Former Member — Tue, 14 Aug 2012 06:06:21 GMT

maintain the structurefields as body like [ ]

Re: insert data from internal tables into structure table.

Former Member — Tue, 14 Aug 2012 06:30:37 GMT

Hi Saul,

What you are trying to do ? From internal tabel you want to update the structure table (SE11)?

For Ex:

If you have the 2 internal tables and 2 DB tables.

1. Fetch the records from SE11 2 DB table and populate the 2 internal tables.

2. Create the SE11 structure and an internal table(FINAL) .

3. Loop the 2 internal tables and move to the final internal table(FINAL).

4. Use INSERT statement with FINAL internal table and update the structure you want to update .

INSERT Structure from FINAL(Internal table).

Thanks,

Pradeep.

Re: insert data from internal tables into structure table.

Former Member — Tue, 14 Aug 2012 06:48:07 GMT

Hi,

If the table1 have header data and Tbale2 have the Item level data. Means the bussines should be Header level data(Comman for all items) and Item related data.

Ex : A single user bye the 10 no of items. So these 10 number of items have the byer details should be same (Header details).

If your bussiness requriment is like above.

there Table1 and Table2 have some relation field.

So you can Achive your requriment like below.

Loop the Item table (Table2 - 50 records)

move the fields values to final internal table.

Read the Table1 with respect to relation fields of Table2.

move the filed values of work area of Table1 to Final internal table.

Endloop.

Re: insert data from internal tables into structure table.

Former Member — Tue, 14 Aug 2012 07:28:17 GMT

Hi Saul,

Can you please paste the code for the two loop statements you are using?

Regards,

Gautam

Re: insert data from internal tables into structure table.

Former Member — Tue, 14 Aug 2012 09:47:37 GMT

Hi,

Looping Table 1 separately and Table 2 separately will not work in your scenarios.

That’s obvious if you are looping both tables separately then you will get only 1 tables data in your 'New_structure'.

So solution for this is if your two tables having some relation (Common key field/s) then you can loop one(Header) table and Read another(Item level).

If No relation in two tables means you can loop in side loop, But for performance constraints we should not loop in side loop.

Re: insert data from internal tables into structure table.

yogendra_bhaskar — Tue, 14 Aug 2012 10:39:27 GMT

hi saul ,

First find out the link in table1 and table2 , as you have to join them .

after finding the link surely they are the common fields in table1 & table2 :

loop at table1 / table2 .

move the field value of table1 / table2 into new structure.

read table2 / table1 with key .

move the field value of table1 / table2 into new structure.

append the new structure into new table.

endloop.

new table will contain the required data you need.

Regards ,

Yogendra Bhaskar

Re: insert data from internal tables into structure table.

Former Member — Tue, 14 Aug 2012 16:45:53 GMT

Hi Gautam, this is the code of loop:

LOOP AT it1 into wa1.
clear: wa3, wa2.
move-corresponding wa1 to wa3.
read table it2 into wa2 with key BAPINOTE_elem_no = wa1-elem_no.
IF sy-subrc eq 0 .
move-corresponding wa2 to wa3.
ENDIF.
append wa3 to it_data.
ENDLOOP.

LOOP AT IT_DATA ASSIGNING <STRUCT>.
MOVE-CORRESPONDING <STRUCT> TO zstuct_ftnbapi.
ENDLOOP.

it works, but just with key tables. So the tables does not have relationship. So result set just retrieve records according the condition statement and not show all records from second table

Re: insert data from internal tables into structure table.

Former Member — Tue, 14 Aug 2012 16:51:22 GMT

Hi Yogendra, the tables does not have relationship, the result is from a function, and i need to save it into a new structure.

I have did with key, but not show all records from second table, I have posted code from the loop to Gautam.

Re: insert data from internal tables into structure table.

yogendra_bhaskar — Thu, 16 Aug 2012 04:41:01 GMT

hi saul ,

did you mean for wa1-elem_no you have multiple values in it2 .

In that case , you must loop at it2 and append , rather than the read statement.

Regards ,

Yogendra Bhaskar