cancel
Showing results for 
Search instead for 
Did you mean: 

How do I concatenate multiple row column values into single row in sapafs?

0 Kudos

Hey everyone I need some help



Anyone knows how to do this?

0 Kudos

Forgot to mention that I only have 3 months of experience in this work-area

srikanthnalluri
Active Participant
0 Kudos

Try with LOOP AT ...GROUP BY

Accepted Solutions (1)

Accepted Solutions (1)

ArthurParisius
Contributor
0 Kudos

Try looking at the COLLECT statement, just make sure of the type definition of the other fields since it will do the adding for all numeric components that aren't part of the key.

0 Kudos

Tried without luck, I mean, it works but not fully, you see I have a field shkzg that when = S -> give and when H -> Have, using collects just sum all the fields without considering shkzg

ArthurParisius
Contributor

How is your internal table defined, what's the key?

If you have a key defined and your SHKZG field is not part of it than that would be the reason.

If your internal table is a standard table without a defined key, than collect will treat all non numeric fields as the key and the collect should work.

So check your key definition for the table, if necessary add the extra field to the key.

0 Kudos

Now that explains it

Answers (0)