Table Definitions with Dimensions for Configured Tables
To create a configured table, you must define the table type and dimensions. The dimensions refer to the number of segments that are used as keys to the table and the number of values that the table returns to the configured item. The maximum number of keys to the table is 20. The maximum number of return values is 99,999.
Tables can have these dimensions:
One segment and one return.
One segment and multiple returns.
Multiple segments and one return.
Multiple segments and multiple returns.
You should have an idea of what you want the table to do prior to defining its dimensions. A one-segment, one-return table is particularly helpful when you want to define price, cost, hot spot values, or other specific information.
You might create a one-segment, multiple return table when one segment can return multiple information consistently. Many component item numbers might be related to a specific segment answer. For example, a paper manufacturer might configure a certain size of letterhead to return a correspondingly sized envelope and response card.
You might create a multiple-segment, multiple return table when using P or Q tables. P and Q tables are based on P and Q assembly inclusion rules, which return parts to the sales or work order.