Skip to Content
0
Former Member
Apr 05, 2006 at 06:50 PM

How to hide a row characteristics in query if this char. value is # ?

29 Views

You guys maybe know that InfoObject 0REVERSEDOC is used in BW to indicate if the record is canceled or deleted in R3. We would like to include this InfoObject in one of our row characteristics in a query to tell us if the record was canceled or deleted already on R3. This InfoObject has got three values:

"#"

"R"

"X"

We know that the value "R" means the record has been deleted on R3, and guess "#" means null value, and "X" means what?

When we run the query, find that this row characteristic (show as a column when running query) all show "#" for non canceled/deleted records which are ugly that we decide to hide this column data if the record is neither canceled nor deleted. How to do this?

Thanks

Message was edited by: Kevin Smith