topic Re: Internal table value comparison in Application Development and Automation Discussions

Internal table value comparison

Former Member — Thu, 29 Jan 2009 07:41:42 GMT

Hi ,

I have selected values from LIKPand LIPS by inner join and prepared one internal table ( which is suppose to be display in output also).

The table output comes as below :

VBELN POS LFART VKORG WADAT_IST WADAT MATNR VTWEG PRODH Total Line

80000093 10 ZLF 2000 0 20080609 GO1525 10 30

80000093 20 ZLF 2000 0 20080609 GO1525CTA 10 30

80000093 20 ZLF 2000 0 20080609 GO1525 10 90

Now we need to calculate Total line that a delivery which has similar product( prodh) it needs to add it

like in this case the output should be

VBELN POS LFART VKORG WADAT_IST WADAT MATNR VTWEG PRODH Total Line

80000093 10 ZLF 2000 0 20080609 GO1525 10 30 2

80000093 20 ZLF 2000 0 20080609 GO1525CTA 10 30 2

80000093 20 ZLF 2000 0 20080609 GO1525 10 90 1

Can you suggest how to calcuate the Total line value , how to do the comparison .

Re: Internal table value comparison

Former Member — Thu, 29 Jan 2009 07:51:35 GMT

HI Anindita,

Instead of using append use collect statement while loding output table.

hope it help you.

regards,

LOkesh

Re: Internal table value comparison

Former Member — Thu, 29 Jan 2009 09:02:20 GMT

This is not working.

Let me know some other way

Basically VBELN PRODH TOTAL LINES are important for total lines calculation

a 30 2

a 90 1

a 30 2

How do I compare the next row to the previous row in the internal table . Need some logic for that

Re: Internal table value comparison

SuhaSaha — Thu, 29 Jan 2009 09:15:06 GMT

Hello Anindita,

Plz change the structure of your internal table:


VBELN PRODH POS LFART VKORG WADAT_IST WADAT MATNR VTWEG Total Line
80000093 30 10 ZLF 2000 0 20080609 GO1525 10  
80000093 30 20 ZLF 2000 0 20080609 GO1525CTA 10  
80000093 90 20 ZLF 2000 0 20080609 GO1525 10

If this is possible then try the code below:


LOOP AT ITAB INTO WA.

V_CNT = V_CNT + 1.

AT END OF PRODH.
WA-TOTAL = V_CNT.
MODIFY ITAB FROM WA TRANSPORTING TOTAL 
WHERE VBELN  = WA-VBELN
AND       PRODH = WA-PRODH.
CLEAR V_CNT.
ENDAT.

ENDLOOP.

Hope this helps.

BR,

Suhas

Re: Internal table value comparison

Former Member — Thu, 29 Jan 2009 09:26:08 GMT

Sort the table by product.

Now rows having same product no will be adjacent to each other.

Now use AT...ENDAT stmt and SUM. Store these values .

Now you can use these values n update that many rows with that val.

For eg:

after sorting your data

prod

sum[] = 2 1.

so for first two rows set total line as 2. Do this using a temp var n decrementing.

Hope this helps

Regards,

Jayanthi.K

Re: Internal table value comparison

Former Member — Thu, 29 Jan 2009 10:14:28 GMT

Thank you all