Product Extension (PX#)
The PX table holds values of product attributes which:
either did not fit into the Product table
or whose values also depend on some other dimension, like time.
There are several sizes of PX tables – PX3, PX5, etc. Use the smallest one which will be able to hold your values, so that you do not waste space in the database.
Fields
name – Unique name of the Product Extension table. Every record keeps a back-reference (name of the table) to which is belongs.
sku – ID of the product for which this record keeps data.
attribute1..# – Values of product attributes. Some of the attributes can be used as a part of the business key, e.g. validity of this record or for which sales organization this record is valid, etc.
Business Key
The PX# table does not have a database unique constraints because you can use also some attributeX fields as a part of the unique key.
So you can define a business key which tells the system which fields form a unique key from business perspective.
Found an issue in documentation? Write to us.