Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Urgernt : ABAP Query

Former Member

‎2008 Jan 27 6:48 AM

0 Likes
355

Dear Guru,

In Database table there are multiple rows against a Heat no. say 4 rows for different metals under one column for the same heat no., In my internal table i have taken separete coulum for separate metals and want to insert value of different metals into corresponding column in single row in the internal table.

Plz tell me the proper way.

Looking forward to your co-operation.

Thanks & Regards,

Gulrez Alam

Dear Guru,

In Database table there are multiple rows against a Heat no. say 4 rows for different metals under one column for the same heat no., In my internal table i have taken separete coulum for separate metals and want to insert value of different metals into corresponding column in single row in the internal table.

Plz tell me the proper way.

Looking forward to your co-operation.

Thanks & Regards,

Gulrez Alam

Reply
1 REPLY 1
Read only

aabhas_wilmar
Contributor

‎2008 Jan 27 8:30 AM

0 Likes
338

Dear Gulrez

Here is a hint for your requirement.

I can't provide you the exact code as I am away from SAP system.

You will have to use field-symbols concept.

Select from dbtab and use sy-dbcnt to know the no of rows fetched.

Do sy-dbcnt times.

cocatenate colno heat no. into l_str no-gaps.

assign l_str to itab-<fs>.

itab-<fs> = value...

append itab.

Enddo.

Hope it helps.

Regards,

Aabhas.