There is a requirement for 6 decimal places on quantity in BOM.
Stand. domain is tiqbm2 with numeric data:
digits before decimal 15
digits after decimal 4
and display format of
Q04, which is ZZZZZZZ9VD9999
If I now change the display format to ZZZZZ9VD999999, I can now insert my 5th and 6th decimal value on the LN session, despite the domain still having 15/4 as its numeric data. For example, my value inserted on LN session is:
If I now check with gen. table maintenance in BW I can still only see the 4 decimal places (3.0000) but in the database (direct query on the DB), there are values stored on the 5th and 6th decimal place (3.000003). I can also see the 3.000003 value displayed on the LN session.
My understanding was that display format only serves for the definition of display on form and report, while numeric data serves for the actual structure of data in the DB. But it seems this is not true.
In my case, I can override my domain structure with a display format. This to me seems like a dirty override. Is this a suitable workaround for enabling 6 decimal places on BOM quantity?
Can anyone share any experiences with this?
Why can I save 6 decimal (defined in display format) places in the DB on a domain that has structure of 4 decimal places?
Thank you for any help.