0 Value for Numc

[Former Member]

Hello,

I have created a characteristic, flag, of type NUMC.

As a transformation rule, i have to set the value of flag to 1/0.

So, i put an if condition as below -

IF(FIELD > Value, 1, 0)

Now for all FIELD > Value , Flag sets to 1.

But for 0 , the flag value is blank when displayed.

When i check the possible values it shows 1 and 0; and for 0 it says not assigned.

I want it to display 0 instead of blank.

Please help!

Thanks and Regards,

Radhika

[former_member942456]

Hi Radhika,

One tricky solution of this can be the below:

1. Check 'With Texts' option for that info-object and in the Business Explorer Tab change the Display to text. Activate the same.

2. Now open the info-object content by maintaing that info-object. You will have a record with blank key. Maintain 0 for that record in Text section.

If this info-object is used in any query, change the local setting for this info-object as 'Display as Text'

Now, as it will display text, you will see 0 for your desired record.

[Former Member]

In the formula.. did you type 1 and 0 as Number or string?

Please use string

[Former Member]

i used number.

Shouldn't it be number itself? will there not be a type-match error?

[Former Member]

I think should not be..

NUMC is Character string with only digits

[Former Member]

oh..okay.. so, i used string for 1 and 0 instead of number, it still doesnot display 0.

instead it is like before, blank and valid values are 0-not assigned and 1.

could there be any other problem?

[Former Member]

Hi,

This is how NUMC info objects behave. They show 0 as blank. Check if the below link helps to show 0 in query.

http://sap.ittoolbox.com/groups/technical-functional/sap-bw/display-0-with-a-numc-infoobject-1263242

Best Wishes,

Mayank

[Former Member]

Sorry.. I thought it should have worked