Skip to Content

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

How to make string


I have a file that contains: Supplier #, Stock # and other details.

In most cases, the original component is processed into different variants.

e.g. Steel Widget (p/n # 123) is painted in three different colours, and sold as Red Widget (p/n 123R), Blue Widget (p/n 123B) and Green Widget (p/n 123G)

So in my original file looks like;

Supplier # Stock# Description

123 123R Red Widg

123 123B Blue Widg

123 123G Green Widg

What I would like my report to look like:

Supplier# Stock#

123 123R, 123B, 123G

Seperating each Stock# with a comma is not essential, but may come in hand.

I am pretty sure this is possible, but I'm not sure how to approach it, let alone giving a usefull description for the Subject post. I think concatenate might be the word

Thanks in advance,


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