Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

PROBLEM IN CLUBBING DATA

Former Member
0 Likes
794

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

6 REPLIES 6
Read only

Former Member
0 Likes
755

Please try coding this yourself and get back to the forum with specific problems.

Rob

Read only

0 Likes
755

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

Read only

Former Member
0 Likes
755

hint,

loop at final table

use at new and at end of evetns.

Read only

Clemenss
Active Contributor
0 Likes
755

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

Read only

faisalatsap
Active Contributor
0 Likes
755

Hi, Sahoo

Please don't use ALL CAPS it is against the Forum Rules

Faisal

Read only

Former Member
0 Likes
755

hi,

it may help to new developers.

dks