Stock-Urgent

[Former Member]

Dear All,

Is there any atandard transaction code thru which we can get the list of material having zero stock and zero stock value?????

Regards,

Indranil

[Former Member]

Hi Indranil,

Goto MB5W/MB5L. You will get your report for Materials with Zero Stock

Hope this helps.

Cheers.

Keshav

[Former Member]

Thanx for the reply.

I have already gone thru this.But this willnot help me since my requirement is i dont know the material codes (zero stock).In these reports with the inputs as valuation area,scope of list (Material with zero stock) and run we will get the stock value balances per g/l account.

My requirement is i need the material codes which will have zero stock.

regards,

indranil

[Former Member]

In the selection screen select the checkbox "Display Indl. Matl Lines"

[Former Member]

Yes,I have see it.But r u sure that this report is giving stock quantity and not values?

regards,

indranil

[Former Member]

It gives both stock and valuation as well.

[Former Member]

let me check it out and return.

regarda,

indranil

[Former Member]

Hi

I am not sure of any transaction , but you can get the list of materials from table MBEW.

In SE16 ,for table MBEW you can put values of zero to fields

LBKUM - Total Valuated Stock

SALK3 - Value of Total Valuated Stock

VERPR - Moving Average Price/Periodic Unit Price

STPRS - Standard price

Thanks & Regards

Kishore

[Former Member]

Thanx for the reply.

Actually i want t/code since it willbe used by the user.They arenot provided with the authorisation for running any table.

regards,

indranil

[Former Member]

Hi

You can create a query using SQ01 , And attach the query Program to a Transaction code in SE93 & provide the authorisation to the user for executing the report.

Thanks & Regards

Kishore

[Former Member]

Yeah,that i can do.But does that mean that there is no standard report?

regards,

indranil