topic Re: Problem with At New in Application Development and Automation Discussions

Problem with At New

Former Member — Thu, 23 Nov 2006 12:08:42 GMT

Please check the following code and tell me why At new statement is not working, but i did the same coding for Sflight table it is working very much fine. It is not grouping the fields.

Could you please tell me where the problem is :

Tables lfa1.

Data itab like lfa1 occurs 0 with header line.

Start-Of-Selection.

Select * from lfa1 into table itab.

End-Of-Selection.

sort itab by land1.

loop at itab.

At First.

write:/50 'Vendor Details' color 6.

Endat.

at new land1.

write:/5 'Vendor Number' color col_heading, 27 'Name' color

col_heading, 50 'Country' color col_heading.

uline.

endat.

write:/5 itab-lifnr, 27 itab-name1,50 itab-land1.

At Last.

uline.

write:/55 'Total Number Of Vendors', sy-tfill color col_total.

uline.

Endat.

endloop.

Regards

Haritha.

Re: Problem with At New

Former Member — Thu, 23 Nov 2006 12:11:58 GMT

At New event will fire, whenever the value change and laso whenever their left filedsvalue changes. please chek the left column of land1.

- saru

Re: Problem with At New

Former Member — Thu, 23 Nov 2006 12:12:44 GMT

The first field in LFA1 is lifnr. So whenever the value of lifnr changes the AT NEW will be triggered.

If u want on land1. then Declare internal table and the first field in that internal table should be land1.

and try as usual.

Re: Problem with At New

Former Member — Thu, 23 Nov 2006 12:12:50 GMT

After at new if you want to group integer fields you have to use SUM.

AT NEW.

SUM.

*DO something

only then grouping will happen

Re: Problem with At New

Former Member — Thu, 23 Nov 2006 12:12:59 GMT

Hi,

after AT NEW u have to read the table or use a workarea,

check the 2nd line

at new land1.
read table itab index sy-tabix.
write:/5 'Vendor Number' color col_heading, 27 'Name' color
col_heading, 50 'Country' color col_heading.
uline.
endat.
write:/5 itab-lifnr, 27 itab-name1,50 itab-land1.

Message was edited by:

chandrasekhar jagarlamudi

Re: Problem with At New

anversha_s — Thu, 23 Nov 2006 12:14:30 GMT

hi,

simply declare land1 as the first variable inside the internal table.

the same problem i faced last day. so i created an internal tabel with land1 as first variable inside that.

the issue solved.

rgds

anver

Re: Problem with At New

Former Member — Thu, 23 Nov 2006 12:17:56 GMT

Please check my comments below in bold.

loop at itab.

At First.

write:/50 'Vendor Details' color 6.

Endat.

<b>It would trigger at new land1 even on change of either vendor number or country. Also please note that the name field would be asterix as it falls on the right of the land1 field. </b>

at new land1.

write:/5 'Vendor Number' color col_heading, 27 'Name' color

col_heading, 50 'Country' color col_heading.

uline.

endat.

write:/5 itab-lifnr, 27 itab-name1,50 itab-land1.

At Last.

uline.

write:/55 'Total Number Of Vendors', sy-tfill color col_total.

uline.

Endat.

endloop.

<b>If you wish to group on country it is better to define itab with country as the first field.</b>

Re: Problem with At New

Former Member — Thu, 23 Nov 2006 12:19:29 GMT

Hi haritha,

If you want to use at new for "land1", land1 should be your first field in the internal table.

Othervise if any field value ex LIFNR is changed AT NEW will be triggered.

So your itab structure should contain LAND1 as first field .

I think this will solve your problem

Thanks and Regards

Antony Thomas

*Reward if solve your problem**