cancel
Showing results for 
Search instead for 
Did you mean: 

Where in the database can I find the Product Layout Tab and Rank per attribute?

Sergey_L
Participant
0 Kudos
182

I made some progress, but I'm missing something...

Findings:
The [PRODUCT_ATTRIBUTES] database table contains columns "ATT_RANK" (which seems to correspond to TAB*) and "ATT_SUBRANK" (which seems to correspond to the rank on that tab).
*Tab name can be determined by connecting to table TAB_PRODUCTS and then to table TAB_DEFN.

Problem:
The attributes which I know are on the layout seem to have the right values in the ATT_RANK and ATT_SUBRANK columns.
HOWEVER, there are other attributes which are NOT on the layout, which ALSO have the same combinations of ATT_RANK and ATT_SUBRANK values.

Conclusion:
► Either the columns PRODUCT_ATTRIBUTES.ATT_RANK and PRODUCT_ATTRIBUTES.ATT_SUBRANK are not actually applicable to Configuration Layout (maybe deprecated?);
► Or there is some other column (maybe even in another table) to differentiate which attributes are valid and which to ignore with respect to PRODUCT_ATTRIBUTES.ATT_RANK and PRODUCT_ATTRIBUTES.ATT_SUBRANK.

Which conclusion is right? And what database table and column am I looking for?
Thank you very much.

Accepted Solutions (0)

Answers (0)