topic Re: What does AT END OF do in a loop in Application Development and Automation Discussions

What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 17:45:01 GMT

Hi all, can you please tell me what is the meaning of AT END of in this loop. I know it is calculating summation of a values in the structure XTAB4, but I am not able to understand why is CHARG specified.

Can anyone please help me.

LOOP AT XTAB4.

TEMP_MATNR = XTAB4-MATNR.

TEMP_WERKS = XTAB4-WERKS.

TEMP_LGORT = XTAB4-LGORT.

TEMP_CHARG = XTAB4-CHARG.

AT END OF CHARG.

SUM.

SCHD_STOCK = XTAB4-VBMNJ.

READ TABLE MCHB_INVT_BAL

WITH KEY MATNR = XTAB4-MATNR

WERKS = XTAB4-WERKS

LGORT = XTAB4-LGORT

CHARG = XTAB4-CHARG.

IF SY-SUBRC = 0.

MCHB_INVT_BAL-SDLVY = SCHD_STOCK.

MODIFY MCHB_INVT_BAL INDEX SY-TABIX.

CLEAR MCHB_INVT_BAL.

ENDIF.

ENDAT.

ENDLOOP.

the structure of

DATA : BEGIN OF XTAB4 OCCURS 0,

MATNR LIKE VBBE-MATNR,

WERKS LIKE VBBE-WERKS,

LGORT LIKE VBBE-LGORT,

CHARG LIKE VBBE-CHARG,

VBMNA LIKE VBBE-OMENG,

VBMNB LIKE VBBE-OMENG,

VBMNC LIKE VBBE-OMENG,

VBMNE LIKE VBBE-OMENG,

VBMNG LIKE VBBE-OMENG,

VBMNI LIKE VBBE-OMENG,

VBMNJ LIKE VBBE-OMENG,

VRKME LIKE VBEP-VRKME,

WMENG LIKE VBEP-WMENG,

END OF XTAB4.

thanks,

Sabrina.

Re: What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 17:49:56 GMT

Hi,

At end of <f> (F: Field in you internal table) between loop and end loop means :

End of a group of lines with the same contents in the field <f> and in the fields left of <f>.

Lanka

Re: What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 17:51:30 GMT

Hi,

YOu can specify any field in the statement at end.AT end will just add up all numerical fields in the internal table and stores them in the same internal table with the same name.

Regards,

Vijay

Re: What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 17:57:44 GMT

thanks murthy for getting back.

for example if i have the following internal table

matnr plant batch value1 value2

1 p1 x 10 12

1 p2 x 12 25

2 p1 x 24 34

2 p2 x 03 02

3 p2 y 02 10

in the above example is it that

AT END of batch

sum

calculates value1= 49 and not 51 because batch is y in the last line.

same with value2 too....

please let me know..

thanks,

Sabrina.

Re: What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 18:00:27 GMT

Hi Sabrina,

Charg field is specified here to trigger the moment of summing values. So this summation wil take place at the last record with charg number xxxx.

Kind regards,

Michel Jonker

Re: What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 18:53:58 GMT

Hi Sabrina ,

You are correct.But make sure you sort the table first.

Re: What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 18:54:46 GMT

Hi Sabrina,

Taking your example consider the following:

You will have to respect the values before CHARG to SUM:

MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) VBMNA(01)

MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) VBMNA(02)

MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) VBMNA(03)

MATNR (1) WERKS (1000) LGORT(p1) CHARG(y) VBMNA(04)

MATNR (1) WERKS (1000) LGORT(p1) CHARG(y) VBMNA(05)

SUM at this point by the field CHARG will be:

MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) = 06

MATNR (1) WERKS (1000) LGORT(p1) CHARG(y) = 09

But now consider this:

MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) VBMNA(01)

MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) VBMNA(02)

MATNR (1) WERKS (1000)

LGORT(p2)

CHARG(x) VBMNA(03)
MATNR (1) WERKS (1000) LGORT(p2)
CHARG(y) VBMNA(04)
MATNR (1) WERKS (1000) LGORT(p2)
CHARG(y) VBMNA(05)

SUM at this point by the field CHARG will be:
MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) = 03
MATNR (1) WERKS (1000) LGORT(p2) CHARG(x) = 03
MATNR (1) WERKS (1000) LGORT(p2) CHARG(y) = 09

And finaly ... changing also Material:
MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) VBMNA(01)
MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) VBMNA(02)
MATNR (1) WERKS (1000) LGORT(p2) CHARG(x) VBMNA(03)
MATNR (1) WERKS (1000) LGORT(p2) CHARG(y) VBMNA(04)
MATNR (2)
WERKS (1000) LGORT(p2) CHARG(y) VBMNA(05)

SUM at this point by the field CHARG will be:

MATNR (1) WERKS (1000) LGORT(p1) CHARG(x) = 03

MATNR (1) WERKS (1000) LGORT(p2) CHARG(x) = 03

MATNR (1) WERKS (1000) LGORT(p2) CHARG(y) = 04

MATNR (2) WERKS (1000) LGORT(p2) CHARG(y) = 05

The way you do the SORT of your table by the fields until field CHARG will change your final output.

Hope this helps you

Mário

Re: What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 19:08:18 GMT

Hi Sabarina,

Please sortn your internal table by matner plant batch.

matnr plant batch value1 value2

1 p1 x 10 12

1 p2 x 12 25

2 p1 x 24 34

2 p2 x 03 02

3 p2 y 02 10

sort itab by matnr plant batch.

Loop at itab.

at end of batch.

sum.

endat.

endloop.

in your example:

sort XTAB4 by matnr werks lgort charg.

Loop at XTAB4.

At end of Charg.

sum.

endloop.

This will work for you.

Lanka

Re: What does AT END OF do in a loop

Former Member — Thu, 19 Jan 2006 20:43:19 GMT

thanks all. I got it.

Re: What does AT END OF do in a loop

Clemenss — Thu, 19 Jan 2006 23:39:14 GMT

Hi,

everything is fine, but AT END OF works a little special in ABAP.

The Processing of Control Levels with AT NEW <f> or AT END OF <f> is done when a control break occurs. This is the case when the value of the field <f> or a superior field in the current record has a different value from the previous record (AT NEW) or the subsequent record (AT END).

For the sample table

matnr plant batch value1 value2

1 p1 x 10 12

1 p2 x 12 25

2 p1 x 24 34

2 p2 x 03 02

3 p2 y 02 10

it means, that AT END OF batch is processed for line 1, because the superior field plant (P1) is different from plant p2 in subsequent record 2.

Also processed for line 2 for the change of plant in record 3.

Processed again for line 3 for the plant change of line 4.

Also for record 4 due to change of batch (and material!) in record 5.

Processed in record 5, because it's at end of anything.

See a good description at

http://help.sap.com/saphelp_47x200/helpdata/en/9f/db9f1f35c111d1829f0000e829fbfe/frameset.htm

In our sample, the characteristics of material batches in plants would be determined. As we do have all different combinations of material, plant and batch, in this case the use of at end of and sum is useless.

The ABAP approach to control level looks strange at first but as soon as you got the concept can be extremely useful.

regards,

Clemens