topic Re: compare 2 value in Application Development and Automation Discussions

compare 2 value

Former Member — Sun, 06 Dec 2009 05:12:55 GMT

Hi All,

I want to compare 2 values in same internal table.

like.

belnr qty qty1

1234 12 1

1234 12 2

I want to compare belnr value and put qty = 0 if belnr is duplicate.

belnr qty qty1

1234 12 1

1234 00 2

please help me.

thanks in advance.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 07:24:51 GMT

Hi,

You can sort the internal table by belnr, then loop the internal table, and compare the belnr, if identical, modify the internal table.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 07:30:04 GMT

Hi,

Please try this:-

sort t_belnr by belnr.

loop at t_belnr into wa_belnr.

v_temp = wa_belnr-qty.

at new belnr.

continue.

endat.

clear wa_belnr-qty.

modify t_belnr from wa_belnr index sy-tabix.

endloop.

Regards,

Subhashini

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 08:28:25 GMT

Hi shubhasini

It also gives same output...

please help me.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 08:37:46 GMT

HI all,

My actual problem is like :

40559178 110.000 40559178 138.000

40559178 004.000 40559178 138.000

40559178 024.000 40559178 138.000

here i want to put 0 on place of 138 in 2nd and 3rd row...

please help me...

Re: compare 2 value

kesavadas_thekkillath — Sun, 06 Dec 2009 09:51:16 GMT

sort itab by <field1>.


loop at itab into wa.
l_tabix = sy-tabix.
at new wa-<field1>.
continue.
endat.
clear wa-qty.
modify itab index l_tabix from wa transporting <field4>
clear wa.
endloop.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:00:26 GMT

Hi Ksd

Can u give me some hint by code...

Re: compare 2 value

kesavadas_thekkillath — Sun, 06 Dec 2009 10:08:59 GMT

What hint do you require ?

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:09:03 GMT

hI KDS,

IT GIVE SAME OUTPUT...

PLEASE HELP ME.

Re: compare 2 value

kesavadas_thekkillath — Sun, 06 Dec 2009 10:12:32 GMT

HI,

the code is written assuming that your itab sturcture is like

field1 field2 field3 field4

40559178 110.000 40559178 138.000

40559178 004.000 40559178 138.000

40559178 024.000 40559178 138.000

if there is any change in the structure the control break statement may not work.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:13:10 GMT

i AM USING FOLLOWING CODE..

ITAB , AND ITAB1 BOTH R INTERNAL TABLES

AND I AM APPENDING THEM IN ONE..

i AM GATING OUT PUT LIKE THIS:

40559178 110.000 138.000 701002 202630

40559178 4.000 138.000 701002 202630

40559178 24.000 138.000 701002 202630

I WANT OUTPUT LIKE :

40559178 110.000 138.000 701002 202630

40559178 4.000 000.000 701002 202630

40559178 24.000 000.000 701002 202630

FOR THIS OUTPUT I AM USING FOLLOWING CODE.

DATA : CHECK TYPE C.

LOOP AT ITAB.

LOOP AT ITAB1 WHERE MBLNR_REG = ITAB-MBLNR_SRP .

MOVE : ITAB-MBLNR_SRP TO ITAB3-MBLNR_SRP,

ITAB-MATNR_SRP TO ITAB3-MATNR_SRP,

ITAB-MENGE_SRP TO ITAB3-MENGE_SRP,

ITAB1-MENGE_REG TO ITAB3-MENGE_REG,

ITAB1-MATNR_REG TO ITAB3-MATNR_REG.

APPEND ITAB3.

CHECK = 'X'.

ENDLOOP.

IF CHECK = ' '.

ITAB3-MATNR_REG = SPACE.

ITAB3-MENGE_REG = SPACE.

APPEND ITAB3.

CLEAR CHECK.

ENDIF.

ENDLOOP.

IS IT RIGHT?

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:15:39 GMT

Try this :

Sort your table based on your field1 .

After this use below code :


loop at itab.
lv_tabix = sy-tabix. " Required to modify field
at new field1.
continue.
endat.
clear  field. " This will make the field blank
modify itab index lv_tabix  transporting  field
endloop.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:15:48 GMT

YES U R RIGHT.

BUT I WANT 0 ONPLACE OF 138 IN 2ND & 3RD ROW.

40559178 110.000 138.000

40559178 4.000 138.000

40559178 24.000 138.000

Re: compare 2 value

kesavadas_thekkillath — Sun, 06 Dec 2009 10:18:46 GMT

You code is a bit confusing

Consider this data

40559178 110.000 138.000 701002 202630

40559178 4.000 138.000 701002 202630

40559178 24.000 138.000 701002 202630

My previos code will work.

sort the itab based on field1.

loop at itab into wa.

at new wa-field1. "Gets triggered when a new belnr is found

continue.

endat.

wa-field4 = 0. "For other records make it 0

modify itab from wa.

endloop.

Please debug and find the solution.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:25:52 GMT

hI KSD

I AM USING SAME CODE

BUT OUTPUT IS SAME NO CHANGE..

MY CODE IS :

SORT ITAB BY MBLNR_SRP.

loop at itab3.

at new MBLNR_SRP.

continue.

endat.

ITAB3-MENGE_REG = 0 .

modify itab3 .

endloop.

Re: compare 2 value

kesavadas_thekkillath — Sun, 06 Dec 2009 10:37:40 GMT

is the field MBLNR_SRP the first field in your internal table ?

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:39:12 GMT

YES.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:41:37 GMT

my first field is mblnr_srp ,

2nd is menge_srp

3rd is menge_reg

4th is matnr_srp

5th is matnr_reg

Re: compare 2 value

kesavadas_thekkillath — Sun, 06 Dec 2009 10:44:33 GMT

Now debugging is the only solution.

Check whether its changing the value to zero or not.

Re: compare 2 value

Former Member — Sun, 06 Dec 2009 10:53:35 GMT

no changing value is not 0

it is same as before.