Skip to Content
Author's profile photo Leon Shen

Dump with error CO889 while creating production orders and a BOM checking tool

A dump below with error CO889 occurs if there are more than 99 phantom materials on one level of BOM when a production order is created.


The cause is that the length of the field keeping the number of phantoms is only 2 so it cannot hold the number greater than 99. The adjustment of BOM structure is necessary in order to avoid the dump, e.g. reduce the number of phantom materials on the same level of BOM, but it is sometimes difficult to find the phantoms if the BOM is very big. Thus, a report is developed to find them and show.

It’s source code can be found in the wiki below.

Here is the selection screen.

Selection screen.JPG

This can be used to check the material BOM, sales order BOM, WBS BOM, and the material number/plant/usage should be entered whichever BOM need to be checked.

1. ‘MAXLEVEL’ is for restricting the BOM explosion up to that level for better performance.
2. ORD_NUM and ORD_ITEM are for sales order number and its item.
3. WBS is for the WBS number.

If no sales order number or WBS number is entered, the material BOM is checked.

Here is the result.

Result 1.JPG

At the top, it shows the number of phantoms and the level where the phantoms are located. The column ‘Count Phantoms’ shows the number of of each phantom till the current one on the same level, so, scroll down to the last phantom can show the total number, the material number of phantoms and the numbers of phantoms therefore can be identified.

More information can be found in the result screen as following.

Result 2.JPG

Please feel free to let me know if this can help or any suggestions to make it easy to use.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Leon,

      It would be more helpful if you also mention the S-Note no. to use in this case to increase the field length of phantom from 2(99) digit to 3 digit(999). Also the impact of applying the note with respect to database structure.

      Best Regards


      Author's profile photo Rohit Singh
      Rohit Singh

      Hi Leon,

      I agree with Piyush, If would be great if relevant notes can be added, especially the one that corrects the this dump.