SAP B1 V9PL8 Item Master Data update with DTW

[former_member217682]

Hi,

I would like to update few items in Item Master Data to Sales Item.

The problem when i try to update, i got error of :-

Cannot change code of an item that is a component of another item. [Message 150-12]

I believe this is due to item has a linkage to BOM.

Is there any alternate ways to update it using DTW without interfering the BOM structure?

Thank you in advance.

[Former Member · Accepted solution]

Hi

Goto the BOM and delete the item for which you wish to change the master data, click update. Now update item master through (DTW or manual) and then add it again to the BOM.

No other way without interfering to BOM.

Thanks

Mohammad Imran

[former_member217682 · Accepted solution]

Hi Guys,

i've found a workaround.

What if i change the value using SQL management?

update oitm
set sellitem = 'y'
where sellitem = 'n'

I've checked in SAP and items are reflected as sales item.

But what's the impact?

It seems that this only links to BOM.

Are there any other tables involve?

Thank you in advance.


[kothandaraman_nagarajan · Accepted solution]

Hi,

This is against SAP support policy. SAP will not support, if any inconsistency due to insert/update/delete SAP tables.

Please do not try.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi

Don't use back end  solution otherwise SAP will not support.

Thanks

Mohammad Imran

[former_member217682 · Accepted solution]

Hi Guys,

Noted. Will proceed to manually remove bom and re-add those items.

Thank you very much.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Are you sure my first reply is not correct answer?

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Without removing BOM for an item master, you can not add as sales item.

1. To remove BOM, right click choose Bill of materials---> Right click and remove.

2. Again add BOM for that item master.

Thanks & Regards,

Nagarajan