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:
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?
Message was edited by: Kevin Smith