Negative Quantity Fields in SAP tables

[Former Member]

Let's say I have a brand new SAP ERP system. I have made no modifications. Standard ERP functions carried out. Will I ever have a negative value in any of the database quantity fields? LIke say: MSEG-MENGE or BSEG-MENGE. Does SAP generally use an indicator field for the sign?

I'm just looking for an experience answer. In your experience, do you ever encounter negative quantity values on the database tables.

thanks

thomas e hansen

[Former Member]

I second Rob, your answer is definitely wrong...

E.g. take for example inventory levels, i.e. look at MARD-LABST and similar fields. So with customizing transaction OMJ1 you can allow the inventory levels to go negative (you might argue if that's good or bad, but it's obvious that SAP allows it without doing any modifications).

[Former Member]

Hey,

Answered my own question. I drilled down the field to the domains and the sign box is not checked. So, negative values are not allowed.

Thanks for playing!

[Former Member]

Maybe those particular fields do not allow a sign, but other quantity fields do.

Rob

[Former Member]

I second Rob, your answer is definitely wrong...

E.g. take for example inventory levels, i.e. look at MARD-LABST and similar fields. So with customizing transaction OMJ1 you can allow the inventory levels to go negative (you might argue if that's good or bad, but it's obvious that SAP allows it without doing any modifications).

[Former Member]

It's probably a selection issue. There are about 78,000 quantity domains, but only 1,300 have th sign field ticked.

Rob

[subhadeep_das]

Hi,

just came across this thread and thought of sharing. My client has peculiar issue wherein the Mengr field (Qty Remaining) in table J_1IEXCDTL goes into negative  on execution of TC :J1IEX.  Basically when i try to capture the excise duty on any particular purchase order, my qty remaining field is going in negative and thereafter not allowing me to MIGO. I get an error message like this,

Error Message : “GR Qty for 1,908.000 is greater than Quantity remaining 362,557.000- in excise invoice 1002506"

Message no. 4F176.

User dont have any clue and neither I a able to trace the root cause of this error.

It will be so great if you can share any inputs on this.

best regds

Subha