Item category based on Plant

[Former Member]

Dear Experts,

I have a scenario where the same material can have different item categoies like TAN, TAS or MTO etc based on plant.

for example material A can have item category as TAN in plant1, and MTO in plant2.

requirement is to automate the item category determination logic based on the plant, is there a way to acheive this?

as for as I know, we may have to do the custom development in the user exit MOVE_FIELDS_TO_VBAP.

but my question is

1. How do I link the plant to the item category?

2. is there a way to acheive this with SAP standard techniques(may be some thing like CMIR or usage etc)?

Thanks in advance for your help.

Regards,

Venkatesh.

[Former Member]

Hi Venkatesh,

As per my knowledge this is not possible through standard,you need to go for enhancement,maintain Z table based on the plant,

material and item category combination.When for the particular material and plant comes in to the sale order relevant item

category will be picked by the system.

Regards

Ram

[former_member209761]

Dear Venkatesh,

Can you please tell us whats the reason behind such a requirement?

As per my knowledge there is no standard way for trigerring the item category based on plant.

But you can use some exits in item level and manipulate the item category.

You will have to maintain an Ztable where you will have the PLANT-ITEM CATEGORY already defined.

System should check the plant in the sales order, and then go to this Ztable and fetch the ITEM CATEGORY and replace the

default one appearing due to item category determination.

Thanks & Regards,

Hegal K Charles

[Former Member]

Thanks CHarles,

The reason behind the requirment is that we have a bussiness case where multiple Plants belonging to same sales area (Sales organization and Distribution Channel). and have for E.g. in one Plant, a material is stocked as MTS product, however, same material in another plant will be treated as PTO material.

so in this case, the current option is to change th itemcategory manually during sales document creation. but this needs to be automatic.

1. Maintaining a custome table with material, plant and item category combination is ruled out by the bussiness as there are huge number of materials to be maintained which will worsen the performance when fetching such table in the user userexit

Regards,

Venkatesh.

[Lakshmipathi]

there are huge number of materials to be maintained

In that case, you can consolidate materials to material groups. So in zee table, have the combination of plant, item category and material group. By this, you can minimise the data.

G. Lakshmipathi

[former_member209761]

Dear Venkatesh,

I strongly feel that there is no alternative solution for your requirement.

You will have to make the system read your criteria for ITEM CATEGORY and for that maintain the Ztable as specified by

Lakshmipathi.

If there is any issue after maintaining so, kindly revert back.

Thanks & Regards,

Hegal K Charles