Skip to Content

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

selected values in report

Hi,

We have  Material hierarchy variable (PRO_VAR) in BEx query I want to display selected product key values in report.

Below is the product data

Product

Key

Biscuits

XYBISCUITS

Diary Milk

XYDIARYMIL

Choc

XYCHOC

I am using below formula to display its key values (in single cell)

=Replace("XY"+upper(UserResponse("PRO_VAR"));";";";XY")


It is displaying XYBISCUITS;XYDIARYMILK;XYCHOC


But i am expecting all key values like below (nospaces and restrict to 8 chars)


XYBISCUITS;XYDIARYMIL;XYCHOC


Could you please help me on this logic please..!!

Thank you,

suri

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