topic Re: Copy one Internal table data to another without loop in Application Development and Automation Discussions

Copy one Internal table data to another without loop

former_member710665 — Thu, 04 Feb 2021 11:30:10 GMT

HI Experts,

I have some data it_tab1(with 3 columns A,B and C) and want to update this data into it_tab2(with 4 columns A,X,Y,Z) as below.

A= A

X = A+B

Y = "Hello"

Z = First 4 characters of C

We are using advanced ABAP and want to update it_tab2 without loop. Could you please help with the logic?

Re: Copy one Internal table data to another without loop

joltdx — Thu, 04 Feb 2021 11:51:35 GMT

Hi!

At first I was thinking about the CORRESPONDING operator with the mapping addition. But I'm not aware of any option of doing for instance A+B or First 4 Characters of C in it. I don't think so, based on the nature of that operator, but somebody might have an idea... 🙂

So then it depends on your definition of "without loop". I mean, technically, this is a looping technique, but it's not a LOOP statement in ABAP:

it_tab2 = VALUE #( FOR tab1 IN it_tab1
                   ( a = tab1-a
                     x = |{ tab1-a }{ tab1-b }|
                     y = 'Hello'
                     z = substring( val = tab1-c off = 0 len = 4 ) ) ).

🙂

Re: Copy one Internal table data to another without loop

former_member710665 — Thu, 04 Feb 2021 12:26:17 GMT

Thanks Jorgen, I am trying to improve performance so looking for any alternate solution which improves performance.

Re: Copy one Internal table data to another without loop

joltdx — Thu, 04 Feb 2021 12:37:13 GMT

Got it. That would depend mainly on what you do INSIDE of the loop, I would say...Not the loop itself...

For instance, SELECT SINGLE inside a loop is bad. SELECT everything first and then READing internal table (with a proper key) inside the loop will be better.

Also proper table types are increasingly more important for performance when the tables grow in size.

If you're willing to share the code for your loop, we might be able to help you more... And also the sizes of your tables and the performance requirements. Or is what you shared exactly your business requirement?

Re: Copy one Internal table data to another without loop

Sandra_Rossi — Thu, 04 Feb 2021 12:38:13 GMT

Anyway, it doesn't make much sense to use CORRESPONDING when it's about only one common component. I don't think CORRESPONDING is for making calculations, VALUE is the only appropriate solution.

Re: Copy one Internal table data to another without loop

Patrick_vN — Thu, 04 Feb 2021 12:44:04 GMT

Is it an option to move these calculations to the SQL statement that fills your [it_tab1]?

And anyway, the question you need to ask as well is if the LOOP statement is really less performant as the VALUE one. If you have a million lines in your internal table, there are a million records to deal with.

Re: Copy one Internal table data to another without loop

former_member710665 — Mon, 08 Feb 2021 07:15:08 GMT

Thanks all for your inputs!!!

Re: Copy one Internal table data to another without loop

Jelena_Perfiljeva — Mon, 08 Feb 2021 17:21:45 GMT

If your question is answered then please accept the answer (see this blog). Thanks!