Question:
Hi,
I want to compress an internal table. It's a three column table with two character and one value column. I have to cumulate the values (sum) for all entries where the combination of the first two columns are the same.
I did think about collect, but this data is not collected from sap. It's data from a file from an external system. (sorry I forgot to mention that)
Doesn't matter when it is in SAP. Bring data into an internal table from external source, then COLLECT into another itab (if necessary for performance / memory reasons then FREE your original itab).
Job done
_________________
Kind Regards
Rosie Brent
Please remember to search the forum and check the FAQ before posting questions, thank you.
Tuly Idiot most of the time, part-time Guru
Answer:
Hi Ron,
Am not clear with your requirement are you planning to do something with that data within SAP or do you want to build a logic outside SAP?
in some third party tool?
I think if its outside SAP i think the steps you have mentioned is a good way to proceed.
Cheers
VJ
_________________
Dare to Share
Answer:
Hi all,
thanks for your speedy replies! I think the method Rosie Brent uses makes the most sense in my situation and I'll use that method.
and Vijayendra, FYI, it's a file I read into SAP, cumulate and post in SAP.
_________________
Cheers!
Ron.
Answer:
I think if its outside SAP i think the steps you have mentioned is a good way to proceed.
I think if it's outside SAP then this is the wrong place to ask!
Ronster: what made you think that the COLLECT statement would only work if the data is not 'from SAP', whatever that means?
_________________
First he pinches my sig, Now he's cribbing my posts too!
Answer:
I think if it's outside SAP then this is the wrong place to ask!
DOH! (_8(|) Ofcourse I know this communitay is SAP related, hehehe
Ronster: what made you think that the COLLECT statement would only work if the data is not 'from SAP', whatever that means?
Well the file with data is from another system and exported as an excel sheet. That system it self is NOT able to cumulate. (And no, the excel sheet cannot be cumulated too, easily, so it has to be done in SAP).
Ronster: what made you think that the COLLECT statement would only work if the data is not 'from SAP', whatever that means?
I'm afraid that's a misunderstanding, maybe it's because of my bad English. Sorry for that.
But it's working fine now, and if you have more questions or remarks I'll be @ yur services
_________________
Cheers!
Ron.