Question:
Hi All,
We do not want to see "#" for blank data for the charcteristics in the workbook.
Any thoughts please?
Thanks
- Gary
Answer:
You could fool around with the SID tables... it's not recommended but it works
El Belgio
Answer:
check data quality
communication structures and mapping .. note down where are you getting that # and which field and attribute it is find whether it is brought from r3 or not ? etc .. need a bit a r3 search and mappings..some times packages if divided in to diff selctiions and that selection not picking up the data then also the u may get problem .. and finly how the infoobject is defined (?)
Kumar Vuppala
Answer:
gary
you can put an 'ickle bit of VBA code in the BEx user exit to return '#' as a space or 0.
Answer:
Hi All,
Thanks for your inputs. I am good at VB. I will try to code in VBA and see if I can solve this problem. I will update the forum about it.
Meanwhile, I checked some things here. In R/3, in the transaction data, for some G/L accounts, the characteristic, Cost Center is blank(null). It is carried exactly the same way into ODS and into the InfoCube. It is the BEX which is doing this. So, I think there will be some setting I can do to to leave the blank data intact, instead of being replaced by "#".
- Gary
Answer:
I had the same problem before and I believe the # character gets put in the SID tables (as I stated before). Check it out!
cheers,
El Belgio
Answer:
Hi El,
Can you elaborate on howto fool with SID tables.
Thanks
- Jim
Answer:
Euh... you need to change the entries, but this is VERY tricky. Ask a developer to have a look at it...
Answer:
@belgio
Did you mean to loop over the sid tables and fill up '#' with ' ' ?!
I think VBA will work easier. (But I'm not good at VBA...)
_________________
Juergen Limbach
Answer:
in case anybody is interested here is the code I use in the SAPBEx exit to remove the '#' symbol.
****
For Each c In resultArea
If c.Value = "#" Then
c.Value = " "
End If
Next
****
Answer:
There should only be one entry in the SID table with value "#" as it would be the key of that table...
Only change that entry and the problem is solved
Answer:
I don't know where to find this user-exit for Bex...
(Extras --> makros --> visual-basic editor?! but there the system wants to have a password??)
_________________
Juergen Limbach
Answer:
Hi Juergen
 Open your workbook in the usual way.
 Go to the VB Editor – Tools -> Macro -> Visual Basic Editor (Alt-F11)
 Expand VBAProject, then Modules and double click on SAPBEX – this will bring up the User Exit.
 Enter any code between the ‘Sub SAPBEXonRefresh…….’ and ‘End Sub’ statements.
 Close down the VB Editor (the code will be saved when you resave your workbook).
 Refresh the query to see the results.
Resave your workbook
Answer:
it seems to work different in version 3.0B, I also can't get in (password required) ?????
Answer:
Now I do understand, I have to do this for every query...
Seems to work now.
Thanks a lot
_________________
Juergen Limbach