Skip to Content

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

Prefix parameter field

I have been provided with a report that requires the parameter field to be populated with the word u2018Weeku2019 and followed by the week number i.e. Week 02

I have an automated system for exporting reports via email, and I can set the parameters to enter dates or part of dates, however I am at a loss of how to have the word u2018Week u2018 (with a space at the end, thus before the week number).

Is there anyway in which I can prefix a parameter field.....so for the parameter of u201840u2019 the Select Expert would actually be checking u2018Week 40u2019 against the database?

Former Member
Former Member replied

maybe pass the parameter field to a formula?

concatenate 'Week' and parameter, e.g.

"Week " + ?parameterfield

and then use the forumula field for your record selection.

Depending on whether your parameter field is a string or otherwise, use + or & as the concatenate operator.

Dom

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question