topic Quick append in Application Development and Automation Discussions

Quick append

Former Member — Fri, 18 Nov 2005 02:19:50 GMT

Hi,

I have one internal table to loop using 'WHERE' statement combined with 'AT NEW' selection. Result of extended-code check shows error in 'problematic statement'. So I now want to quick append that internal table lets say I_VBAK to I_MVBAK where VBTYP = 'H' (to move data for return order).

What is the quick way to do that? I dont want to do loop again in I_VBAK and then move to I_MVBAK.

Many thanks.

Alia

Re: Quick append

Former Member — Fri, 18 Nov 2005 02:55:40 GMT

Hi!

There is no other option to copy internal table extract by some condition to another internal table without using "LOOP AT itab1 WHERE condition/APPEND itab2".

You can improve "LOOP WHERE" performance by use of "ASSIGNING <fs>" construction.

Regards,

Maxim.

Re: Quick append

Former Member — Fri, 18 Nov 2005 03:21:52 GMT

Not one statement but may be two statements!!

I_MVBAK[] = I_VBAK[].

DELETE I_MVBAK WHERE VBTYP <> 'H'.

Re: Quick append

Former Member — Fri, 18 Nov 2005 03:22:21 GMT

assuming they have the same structure

Re: Quick append

jayanthi_jayaraman — Fri, 18 Nov 2005 04:59:13 GMT

Hi,

Append lines of i_vbak to i_mvbak.

Delete i_mvbak where vbtyp <> 'H'.

But both i_vbak and i_mvbak should have same struture.

Kindly reward points if it helps.