topic Re: Problem in At new in Application Development and Automation Discussions

Problem in At new

Former Member — Fri, 09 Apr 2010 11:17:26 GMT

i have written below code

CLEAR : wa_final.

LOOP AT it_final INTO wa1_final.

idx1 = sy-tabix.

at new LICNO.

CLEAR : vcount.

ENDAT.

vcount = vcount + 1.

wa1_final-NOM = wa_final-NOM.

modify it_final FROM wa1_final INDEX idx1.

ENDLOOP.

my requirement is

if i have 3 same "NICNO" then NOM should be displayed only once

EG :

NICNO          NOM
1               M1
1
1
2               M2
3               M3

what is wrong in my above code ?

Re: Problem in At new

Former Member — Fri, 09 Apr 2010 11:22:37 GMT

Hi,

Sort your table by LICNO first before looping into the table.

Regards,

Sunny Desai

Re: Problem in At new

Former Member — Fri, 09 Apr 2010 11:28:36 GMT

What does the work area wa_final contain? Also what is the use of the counter here? Does it have anything to do with the question here?

Re: Problem in At new

Former Member — Fri, 09 Apr 2010 11:33:09 GMT

hI,

Plse check by moving the MODIFY statement before ENDAT.

Regards,

Rajeswari

Re: Problem in At new

Former Member — Fri, 09 Apr 2010 11:34:53 GMT

Sorry

the code goes like this

CLEAR : wa_final.
      LOOP AT it_final INTO wa_final.
        idx1 = sy-tabix.
        at new LICNO.
          CLEAR : vcount.
          ENDAT.
       vcount = vcount + 1.
       wa1_final-NOM = wa_final-NOM.


 modify it_final FROM wa1_final INDEX idx1.

Re: Problem in At new

Former Member — Fri, 09 Apr 2010 11:36:00 GMT

Try Below code.

data : m_nom type nom.
CLEAR : wa_final.
m_nom = ' '.
LOOP AT it_final INTO wa1_final.
idx1 = sy-tabix.
move-corresponding wa1_final to wa_final.
if m_non = wa1_final-nom
 wa_final-nom = ' '.
 modify it_final from wa_final index idx1.
endif.
m_nom = wa1_final-nom.
endloop.

Regards

Vinod

Edited by: Vinod Kumar on Apr 9, 2010 5:06 PM

Re: Problem in At new

Former Member — Fri, 09 Apr 2010 11:39:52 GMT

CLEAR : wa_final.
 LOOP AT it_final INTO wa_final.
        idx1 = sy-tabix.
        at new LICNO.
          CLEAR : vcount.
        ENDAT.
        
       vcount = vcount + 1.
 
      if vcount gt 1
       clear wa_final-NOM.
      endif.
 
       modify it_final FROM wa_final INDEX idx1.
ENDLOOP.