values missing in MB52

[Former Member]

Dear Experts,

  While displaying the warehouse stock of a material, for some the items values it is not showing what could be the problem. can someone explain me clearly about MB52.  in what cases it wil show the values and in what case it wont ?

Thanks & regards,

Gowrishankar R

[Former Member · Accepted solution]

dear all,

  the values of the special stock wont appear in MB52 right ? for ex. sales order stock .

quantity it s showing but not the values . is it possible to show the values of the special stocks too ??

Thanks & regards

Gowrishankar R

[Former Member · Accepted solution]

Hi,

Check OSS: Note 407812 - MB52 with value display. What needs to be taken into account. Also check transaction MBBS.

http://scn.sap.com/message/7763410

Regards,

[Former Member · Accepted solution]

Hi,

Values of the special stock will come in MB52.

Check the Layout settings.

Regards

Ravi

[Former Member · Accepted solution]

Hi,

Attaching screenshot files fyi.

Ravi

[Former Member · Accepted solution]

dear Ravi,

  i have selected " also select special stock " and mentioned the stock indicator also only the quantity it s showing but the value s 0.

[Former Member · Accepted solution]

Dear ravi,

which one exactly i should copy, bcoz i dont find any values in special stock there. kindly guide me plz

[Former Member · Accepted solution]

Hi,

What kind of special stock you have?

O is for subcontracting stock. value will come in unrestricted stock value field only.

Can you give me screen shot for understanding.

Regards

Ravi

[Former Member · Accepted solution]

sales order stock stock type E

MATERIAL  PLANT   SLOC   S     SPCL STOCK NO.  BATCH  UNREST.   VALUE UNRS

123             plant1     chn      E     123456/30               abcde    100              0.00

123             plant2     ban                                            pqrst     155            152000.00

123             plant2     ban                                            lmnop    500            8000000.00

here for stock type E i need value quantity is 100.. in MMBE for that it s showing as sales order stock.

is it possible to bring the value of that 100 quantities ?

[Former Member · Accepted solution]

Hi,

For special stock " sales order stock" Consumption accounting entry will be booked at the time of transfer, that's why system will not show the value in MB52.

I mean System will passes the entry Credit to stock  A/C and debit to COGS A/C.

The above accounting entry means stock is no longer valuated at your place, costs to COGS is already booked.

This entry is similar to PGI, So No value for this special stock.

For other special stocks, stock is valuated at our place. for example Stock lying at subcontractor, physically stock is not in our plant/premises still stock is valuated as our stock.

Hope this answers your query.

Regards

Ravi

[Former Member · Accepted solution]

Hi,

Check and tell me what kind of mvt type was used to transfer that Qty and what was the accounting entry?

Regards

Ravi

[Former Member · Accepted solution]

Hi,

Check this for extra info.

http://help.sap.com/saphelp_erp2004/helpdata/en/4d/2b92b743ad11d189410000e829fbbd/content.htm

Regards

Ravi

[Former Member · Accepted solution]

while doin GRN it was received wit 101 E  400qty   and 601 E has been done for 300qty

so remainig 100 it s showing as sales order stock and for that values s showing as 0 in MB52

[Former Member · Accepted solution]

Hi,

you can share the screenshots by converting them to jpg files.

Share the screenshot of accounting entry at the time of GR-101 E and sale 601 E.

Regards

Ravi

[JL23 · Accepted solution]

there is a field called valuation among the field list in MB52.

get this into your display and tell me the character displayed in that field. is it a A or a M or just blank ?

then put the cursor into this column and press F1.

SAP will explain you the difference between valuated and non-valuated special stock.

[Former Member · Accepted solution]

Dear Jürgen L

It s blank.. so it is non valuated rite ..?  is there anyway to change that into valuated ?

[JL23 · Accepted solution]

Not possible for the existing sales order stock,

This is actually customizing made by CO folks:so you better get in touch with them

SPRO > Controling > Product Cost Controlling > Cost Object Controlling > Product Cost By Sales Order > Control of Sales Order Related Production

In  Check Requirement Classes you define how he sales order stock will be handled from valuation point of view.

[Former Member · Accepted solution]

Thank u Jurgen L

Regards,

Gowrishankar

[Former Member]

Thank u everyone !!!

Regards,

Gowrishankar

[Former Member]

Dear Jurgen L,

   I have checked for few material codes for all the codes in MB52 it is just blank and for those the values are 0.

Is there any way we can get the values or any other report or T CODE where we can see the values of those stocks.

Regards,

Gowrishankar R

[JL23]

I have never worked with non-valuated sales order stock, so I am not sure here and can just repeat what the SAP help is saying, that the costs are posted to a cost collector and cannot be seen until a settlement is made at the end of the month. But these costs can certainly not be seen in MB52 after this settlement.

Please get in touch with your CO team colleague who is in charge for product costing. He can eventually tell you some CO reports where you can see those costs.

[Former Member]

transfer postings have been done for that material so that the values r not showing in MB52.

[Former Member]

Hi,

Select no Zero stock lines in Mb52 input screen.

MB52 shows lines items without stock also.

As there is no stock qty, system is showing zero value.

Regards

Ravi

[former_member218071]

hi,

please check if you have ticked check box "Do Not Display Values" in selection screen

Regards, Rakesh

[Former Member]

hello everyone my case is

material ex. 12345

plant : chennai

s.loc : chn1

batches: abc, xyz, rst

for this in mb52 report

MATERIAL     PLANT        S LOC       BATCHES        VALUES   

12345            chennai          chn1          abc                10000

12345            chennai          chn1          xyz                  0

12345            chennai          chn1          rst                  5000

only in some case like batch xyz value s missing wat could be the reason. ??

please explain me in detail

[Former Member]

Are these all material batches belongs to same PO document and its one line item? If not check the PO which has line item checked Free Item (UMSON).

[Former Member]

It is not an free item. is it the case like this.  if the material is used for transfer postings it wont show values..??? i hav another material in which two s.loc has the material one has 4 batches and other has 6 batches. transfrer postings has been done between two sloc's.   IN MB52 report it shows bothe the sloc and the total quantity not the batches and similarly it s not showing the values for both.

[Former Member]

Hi,

Please check MB52 & MMBE tcode in that xyz batch material stock is avilable or not.

if stock is not there that batch value also show 0.

[former_member192897]

Do you see the stock against XYZ batch in MB52 output? You mean it has stock but doesnot show the value. Can you check and let us know.

[Former Member]

Case 1: If transfer posting is in between two storage locations for one material then system will not update accounting document.

Case 2: If transfer posting between two materials having different storage locations(mvt 309) then system will generate accounting document.Here if price changes in this posting system will give your warning message "Price change amount XX% for the month XX/2012'

For above cases check tables MCHB, MCHBH, MCHA, MARD, MARDH, MARC, MARCH. You may find differences in these tables. And also check your selection criteria in report MB52. 

[Former Member]

another possibility may be : You meight have activated batch specific valuation in configure split valuation. In this case, system shows bacth specific values. Batch xyz meight be procured as FOC (Free Of Cost) so value is not updated for xyx batch.

Hope, it will help you.

Regds,

Nilesh

[Former Member]

Value of the stock is determined from prices maintained/updated in MMR whatever may be price control.

If that price is zero, then stock value will be zero.

Example will be of FOC Materials.(Free Of Cost).

Regds,

Nilesh

[former_member242092]

Hi,

Please check accounting view of those materials whom value are missing in MB52. Standard or moving price should be maintained for the subjected material otherwise it will be 0 in MB52.

warehouse stock = moving/standard price * total qty

100 = 5*20

Regards,

RP Jaiswal

[Former Member]

Hi,

Please check as found information about MB52.

You use this report to display the total stock of a material (quantity and value) at plant and storage location level. If transit stocks or stock transfer stocks exist at plant level, the system totals these stocks and displays them in the column <ZH>In Stock Transfer</> in a stock line without a storage location.

Note that in this report, the stock value of the warehouse stock is calculated using the following simplified formula:

Stock value = quantity x value/valuated stock 
Therefore the stock value specified here only has informal characters

and does not represent the actual stock value.

Also check transaction code: J3RFLVMOBVED. May be helpful.

Regard,s