Skip to Content

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

prompt values

Hi,

We have  Material hierarchy variable (MAT_VAR) in BEx query I want to display selected material key value in report.

Below is the material data

MatKey
MatAXYMatA
MatBXYMatB

I am using below formula to display its key values and it is working fine if user selects single value

="XY"+Userresponse("MAT_VAR")

When user selects multiple values then it is displaying like below:

XYMatA;MatB

But I am expecting XYMatA;XYMatB (in single cell)

Thank you,

suri

Former Member
replied

Hi,

use this.

=Replace("XY"+UserResponse("MAT_VAR");";";";XY")

Amit

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