topic Re: Control loop statements in Application Development and Automation Discussions

Control loop statements

Former Member — Tue, 01 Aug 2006 23:09:34 GMT

Hello Gurus,

I always have the confusion while I am using the control loops statment with respective to fields I want to use control loops on.

data: begin of sample_tab occurs 0,

field1 like mara-matnr,

field2 like vbrp-vbeln,

field3 like maktx-maktl,

end of sample_tab.

Let's think that FIELD1 is the desired field that I want to apply the control loops statment logic on always. Please also let me know that what care that I have to take before the use of Control loop statement. Please explain following scenarios.

AT end of - field1 is first field in sample_tab?

- field2 is second field in sample_tab?

- field1 is first field in sample_tab and not

a key field of any db table.

- field1 is second field in sample_tab and not

a key field of any db table.

AT frist - field1 is first field in sample_tab?

- field2 is second field in sample_tab?

- field1 is first field in sample_tab and not

a key field of any db table?

- field1 is second field in sample_tab and not

a key field of any db table?

AT last - field1 is first field in sample_tab?

- field2 is second field in sample_tab?

- field1 is first field in sample_tab and not

a key field of any db table?

- field1 is second field in sample_tab and not

a key field of any db table?

on change of - field1 is first field in sample_tab?

- field2 is second field in sample_tab?

- field1 is first field in sample_tab and not

a key field of any db table?

- field1 is second field in sample_tab and not

a key field of any db table?

Thanks in advance.

SDN

Re: Control loop statements

Former Member — Tue, 01 Aug 2006 23:19:24 GMT

Hi,

Go through the link for control levels,

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb381a358411d1829f0000e829fbfe/content.htm

Regards,

Azaz Ali.

Re: Control loop statements

abdul_hakim — Tue, 01 Aug 2006 23:33:28 GMT

before using the control loop statements you should sort the internal table by control break.

In your case you should sort your itab as SORT SAMPLE_TAB BY FIELD1.

Cheers,

Abdul Hakim

Re: Control loop statements

aris_hidalgo — Wed, 02 Aug 2006 01:39:06 GMT

Hi,

In order to properly use those statements, you should first sort your itab by field1. For example:

sort sample_tab by field1.

loop at sample_tab.

at end of field1.

write: / 'END'.

endat.

at first.

write: / 'This is the first record'.

endat.

at last.

write: / 'This is the last record'.

endat.

endloop.

Hope this helps...

P.S. Please award points for useful answers.

Re: Control loop statements

former_member186741 — Wed, 02 Aug 2006 02:55:51 GMT

AT end of field1

- field1 is first field in sample_tab?

will be processed whenever field1 changes

AT end of field2

- field2 is second field in sample_tab?

will be processed whenever field1 or field2 changes

- field1 is first field in sample_tab and not

a key field of any db table.

will be processed whenever field1 changes

being a key field is not relevant

- field1 is second field in sample_tab and not

a key field of any db table.

will be processed whenever field1 OR the first field changes

being a key field is not relevant

AT frist - field1 is first field in sample_tab?

- field2 is second field in sample_tab?

- field1 is first field in sample_tab and not

a key field of any db table?

- field1 is second field in sample_tab and not

a key field of any db table?

regardless of field values this code will be exected on the very FIRST pass of the loop

AT last - field1 is first field in sample_tab?

- field2 is second field in sample_tab?

- field1 is first field in sample_tab and not

a key field of any db table?

- field1 is second field in sample_tab and not

a key field of any db table?

regardless of field values this code will be exected on the very LAST pass of the loop

on change of - field1 is first field in sample_tab?

- field2 is second field in sample_tab?

- field1 is first field in sample_tab and not

a key field of any db table?

- field1 is second field in sample_tab and not

a key field of any db table?

do not use 'on change' this it is intended for 'selects' not loops. Instead use 'at new ..'.

at new field1.

This will be executed whenever the field1 value differs from the previous pass (or on the first pass).

at new field2.

This will be executed whenever the field1 OR field2 values differ from the previous pass (or on the first pass).