I would like to get a list of categories and catalogs for which user criteria have been set.

[M_Tomy]

Dear Experts.

For research purposes, I would like to get a list of categories and catalogs for which user criteria have been set.
Which table should I look at?

Best regards

[Mark C_]

Hey M_Tomy, try:

sc_cat_item_user_criteria_mtom
sc_cat_item_user_criteria_no_mtom

 

[Harish KM · Accepted solution]

Hi @M_Tomy for catalogs there are no user criteria defined,

For categories, user criteria are defined in this table sc_category_user_criteria_mtom ( available for)

                                                                                           sc_category_user_criteria_no_mtom(not available for)

for catalog item user criteria are defined in this table sc_cat_item_user_criteria_mtom ( available for)

                                                                                            sc_cat_item_user_criteria_no_mtom (Not available for)

[M_Tomy]

Thank you for your prompt response.
It was very helpful.