cancel
Showing results for 
Search instead for 
Did you mean: 

Differences in MARD and MBEW tables

Former Member
0 Kudos
1,418

Hi all,

For few of the materials in MBEW table there is showing negative stock value but for the same materials in MARD table its showing ZERO stock status.

Can any body explain what might be the reason?

Thanx

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Difference was stock quantity value in MARD AND MBEW.

can any one tell where can we check MARD is not allowing negative stocks?

Thanks

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

As you already checked and analyzed tables :MBEW and  MARD but also have a look for data in table MARDH and compare!

Regards,

Biju K

Former Member
0 Kudos

Hi,

can you please explain in brief?

JL23
Active Contributor
0 Kudos

some stocks are non-valuated

- like customer returns stock (becomes valuated after you do a transfer posting return to own stock with movement 453)

- like vendor consignment stock

Hence MARD has the full quantity which you have in your location, but MBEW has only the portion which is valuated.

that your valuated stock is negative is because you allowed negative stocks in your system, otherwise you  would receive an error message  when stock would become negative.

if you have no such unvaluated stock types, then you may have an inconsistency which  can result from wrong customizing of value update in OMS2 which got correct  after you had already stock. (SAP does not restrict a consultant in doing this change, because this change is made in developement system and then transported into production system where you have your stock - the consultant is required to think before such a change is carried out)

Former Member
0 Kudos

Hi,

at your valuated stock is negative is because you allowed negative stocks in your system, otherwise you  would receive an error message  when stock would become negative.

Can you please tell where is it maintained?

Former Member
0 Kudos

Hi,

  In material MM02 plant/stor.2 view negitive stock check box.

  OMJ1 tcode plant vies check check box

Former Member
0 Kudos

Hi,

  MARD : Storage Location Data for Material

  MBEW : Material Valuation

  MARD is the storage location vise material date see, MBEW is the material valution