Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to total accoring to document and docu date..

Hi All,

i want to to do the sum for every month for same Document.

i.e: tables itab contians the data as:

docmnet number date currency

D102345 10.10.2007 2000

D102345 12.10.2007 3000

D203023 08.11.2007 500

D203023 20.11.2007 7000

Requiremnt: have to get

Documet month currency

D102345 10.2007 5000

D203023 11.2007 7500

thanks,

srii..

Tags:
Former Member
Former Member replied

Hi

Create one more internal table

itab2 with following fields

month(7),docmnet number date currency

assuming data is already there in itab

loop at itab.

itab2-month = itab-date+4(7).

itab2-docmnet = itab-docmnet.

itab2-currency = itab-currency.

collect itab2.

endloop.

Regards

Madhan

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question