delete settype

[Former Member]

Dear Friends,

Is there any process to delete settype from category if already some products are created using the settype .

Regards,

Ravikumar

[ashish_nagpal]

hi

always remember that a set type which has been assigned a

value in the product master cannot be deleted from the product

category. This is because whenever u put an attribute value to

the settype in the product master, two database tables always

get updated.

so it will be like at program level that you got to delete the two entries manually from the table if you want that szet type to get deleted.

like you have created an object using Z entry and ther will be another entry for the assigned attributes,just delete it using the program

you will have ur purpose sorted

best regards

ashish

[Former Member]

Hi Ravi,

A settype which has been assigned a value in the product master cannot be deleted from the product category. This is because whenever u put an attribute value to the settype in the product master, 2 database tables get updated.

A settype results in the creation of many tables and function modules in the background. The main tables are

1. Name is same as that of the settype - It holds the value u have assigned to the Product Master.

2. Name of settype+H i.e. if ur settype is say ZSETTYPE, the second table's name will be ZSETTYPEH.

This table holds the history of changes done to the attribute value. If you delete the value assignement from the product master, this table will be updated.

In order to delete a settype, you will have to develop a program which removes the entry from the above to tables, and only then it will be possible to remove the settype.

Wish the information is helpful.

Regards,

Shalini Chauhan

[srikantan_j]

Hi Ravikumar,

Only those set types can be deleted that are not assigned to a product category (any more).

Regards

Srikantan