cancel
Showing results for 
Search instead for 
Did you mean: 

Show blank texts instead of key or 'not assigned' in query-result

0 Kudos

Hi,

is there a way / workaround to

1. suppress # / 'not assigned' in query results?

or

2. show blank texts (if maintained) instead of the key

(when showing texts for a characteristic in a query all characteristics with blank texts - none or ' ' -

will show the key instead of the blan text) ?

Thanks,

Christoph

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Christoph,

there have been several posts concerning this topic. As Saad told there is no direct way within SAP standard to reach this aim.

Depending on the Front-End Tools you are using these posts may help:

Brgds,

Marcel

0 Kudos

Excluding or suppressing those rows is not an option as they are needed in the report.

There are a couple of characteristics and key figures in the query.

Let's say characeteric a has a value and b hasn't (or a has a text and b hasn't) and there are key figures assigned.

The result line should look like this <value_a> <blank> <kf1 to kfn>

Christoph

Former Member
0 Kudos

By direct ways , its not possible..

By indirect ways, you can try using a Exit variable for the characteristic and code it so as to replace # with blank exclusively for the text coulmn..

I think this should work..

SM

Former Member
0 Kudos

Hi Christoph,

You can select the # value in the characteristic selection and set it as "Exclude (shown as Red "=")

May be then you will not see the # in your report result.

Since # is treated as a master data value for Blank, any values assigned to it will be displayed into reports..

Hope this helps..

SM