Documents may contain multi-valued items . Many times the values in the items are related (e.g. a document describing an invoice may contain multi-valued items for the purchased article codes, article titles, article price, ...)
Suppose we need to build a view that displays all invoice documents that have at least one article that costs more than 1000$. We need to list the article code, the article title and the prices
It is easy to build a selection formula.
We may display the article price for the article(s) costing more than 1000$ (could be on index 7 and 10 in the multivalued field). But there is no way to display only the 7th and 10th entry in the article code and article title column
What could be a solution:
- have a hidden column that calculates the indexes (7 and 10 in the example) and store the result in a temporary variable (this temp variable is a new concept to be implemented by IBM).
- the other view columns should be able to read this temp variable
Each row in the view has a dedicated set of temporary variables