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

At new Functionality

Former Member — Wed, 17 Jun 2009 12:31:06 GMT

At new is not functionig.

where i was wrong in this code.

LOOP AT itab WHERE zuonr+0(1) EQ 'S'.

AT NEW zuonr.

READ TABLE it_prin WITH KEY bukrs = itab-bukrs

gsber = itab-gsber

xref2 = itab-zuonr.

IF sy-subrc EQ 0.

itab-prdeb = it_prin-dmbtr.

MODIFY itab TRANSPORTING prdeb.

clear:itab,it_prin.

ENDIF.

ENDAT.

ENDLOOP.

Suggest me.

Re: At new Functionality

Former Member — Wed, 17 Jun 2009 12:34:28 GMT

Hi,

why are you clearing the 'itab' inside the loop? What is the required functionality?

Re: At new Functionality

Former Member — Wed, 17 Jun 2009 12:35:34 GMT

You cant use AT NEW with WHERE this way...

Re: At new Functionality

Former Member — Wed, 17 Jun 2009 12:36:03 GMT

Hi ,

Check that your internal table is sorted by zuonr , also check that this field (zuonr) should be top in the internal table.

Re: At new Functionality

former_member212005 — Wed, 17 Jun 2009 12:36:58 GMT

Nothing seems to be wrong with the code...

Put a break point at the read statement and check...also enusre that you are sorting the internal table before using proper field..

Debug and look for errors.

Edited by: Vin on Jun 17, 2009 2:37 PM

Re: At new Functionality

Former Member — Wed, 17 Jun 2009 12:39:57 GMT

Although that statement is omitted : the result is same.

whenever new zuonr comes then only i am assigning value.

but it is taking all posibilities.

Thanks,

Re: At new Functionality

Former Member — Wed, 17 Jun 2009 12:46:40 GMT

Hi Jitendra,

When you use AT NEW, then if anything change on left side of ZUONR, it will trigger. So my suggestion will be make ZUONR field as first fireld if possible.

Declare accordingly. If ZUONR has to be first field, then give complete structure instead of like ITAB.

data: itab1 like itab occurs 0 with header line,

wa_data like itab .

itab1[] = itab[].

delete itab1 where zuonr+0(1) ne 'S'.

sort itab1 by zuonr.

sort it_prin by bukrs gsber xref2.

LOOP AT itab1 .

move itab1 to wa_data.

AT NEW zuonr.

READ TABLE it_prin WITH KEY bukrs = wa_data-bukrs

gsber = wa_data-gsber

xref2 = wa_data-zuonr binary search.

IF sy-subrc EQ 0.

wa_data-prdeb = it_prin-dmbtr.

MODIFY itab1 from wa_data TRANSPORTING prdeb.

clear:itab1,

wa_data

it_prin.

ENDIF.

ENDAT.

ENDLOOP.

Regards,

Anil

Re: At new Functionality

Former Member — Wed, 17 Jun 2009 12:48:28 GMT

i have checked for lifnr.

it is working fine.

but when i use zuonr it not working properly

Re: At new Functionality

Former Member — Wed, 17 Jun 2009 12:52:56 GMT

HI,

If AT NEW need's to triggered only if any change in the ZUONR then this field should be the first Field of Internal table.

If it not the first field then any change in the fields before this ZUONR then AT NEW will get triggered.

Or You can use ON CHANGE OF ZUONR -- This trigger only if any change inthis field irrespective of any change in the previous fields.

Re: At new Functionality

tarangini_katta — Wed, 17 Jun 2009 12:55:25 GMT

Hi Jitendhar,

Then tyr to use 'on Change of'

Thanks,

Re: At new Functionality

Former Member — Wed, 17 Jun 2009 12:59:37 GMT

Thank you very much.