2009 Oct 02 1:44 PM
Hi,
Data is like below in a final internal table :
DATE INVNO QTY1 QTY2
01.10.09 INV 10 20 30
01.10.09 INV 15 30 40
02.10.09 INV 16 40 50
Now i want to display like below :
For same date it should add the numeric value for QTY1 and QTY2 and also concatenate for INVNO Fitst no and Last no.
like below :
DATE INVNO QTY1 QTY2
01.10.09 INV 10-15 50 70
02.10.09 INV 16 40 50
Hi,
Data is like below in a final internal table :
DATE INVNO QTY1 QTY2
01.10.09 INV 10 20 30
01.10.09 INV 15 30 40
02.10.09 INV 16 40 50
Now i want to display like below :
For same date it should add the numeric value for QTY1 and QTY2 and also concatenate for INVNO Fitst no and Last no.
like below :
DATE INVNO QTY1 QTY2
01.10.09 INV 10-15 50 70
02.10.09 INV 16 40 50
2009 Oct 02 1:54 PM
Please try coding this yourself and get back to the forum with specific problems.
Rob
2009 Oct 05 2:18 PM
Hi experts,
i solved the problem by myself.
some hints of solution:
2 internal tables of same type. itab1, itab2
loop at source_itab.
at new date.
l_invno1 = source_itab-invno.
endat.
at end of date.
l_invno2 = source_itab-invno.
if l_invno1 ne l_invno2.
concatenate l_invno1 l_invno2.
else.
concatenate invno1.
endif.
endat.
in itab1 , collect the data by date, but dont update invno.
in itab2, append date and invno.
endloop.
sort itab1 by date.
sort itab2 by date invno.
delete itab2 where invno eq space.
loop at itab1.
read itab2 with key date = itab1-date.
itab1-invno = itab2-invno.
modify itab1 transporting invno.
endloop.
very very sorry by putting this type of question in sdn.
regards
dks
2009 Oct 02 1:57 PM
2009 Oct 02 2:51 PM
Hi Debendra,
this tries to be a developer network, not a developer school for non-developers.
Show us what you tried wnd where you got stuck, tnx.
Regards,
Clemens
2009 Oct 02 2:52 PM
Hi, Sahoo
Please don't use ALL CAPS it is against the Forum Rules
Faisal
2009 Oct 05 2:19 PM