Simple Look-Up Method

The Simple Look-Up method looks up each input row in a business component using a simple search expression. For example, it could be used to look up list price or exclusive eligibility.

Arguments

Input Argument	Description
Context	Optional. Property set of variables shared across all rows.
Row Set	The set of rows to process.
Output Row Set	Optional. The property set used for output.
Process Condition	A Boolean condition that is evaluated to determine whether to process each row.
Business Object	The business object to query.
Business Component	The business component to query.
Search Specification	A search expression comprised of business component fields, literals, and variable values from {Context} and {Row}. For example: [Price List Id] = {Row.Price List Id} AND [Product Id] = {Row.Product Id}
In Memory Search Specification	Optional. Additional terms that are ANDed with the Search Specification. The In Memory Search Specification is executed in memory. This can be used only if Cache Enabled is Y.
Cache Search Specification	Optional. Additional terms that define the key values for the Level 1 cache; for example: [Price List Id] = {Row.Price List Id}) For more information, see About PSP Cache Performance Statistics.
Sort Specification	Optional. A comma-separated list of business component fields used to sort the query result.
Cache Enabled	Optional. Specifies whether to cache query results. Y or N. The default is N.
On First Match [1..20]	Actions to perform on the first query result for each input row.
On Match [1..20]	Actions to perform on every query result for each input row.
On Last Match [1..20]	Actions to perform on the last query result for each input row.
On No Match [1..20]	Actions to perform if there are no query results for an input row.

Example

The following figure shows an example of arguments for a PSP procedure step named In Price List, which uses the Simple Look-Up method.