topic How to find opening quantity and value while debugging MB5B tcode in Application Development and Automation Discussions

How to find opening quantity and value while debugging MB5B tcode

Former Member — Fri, 13 Sep 2013 11:49:18 GMT

Hi,

I want to find opening quantity and value for a material with given date while debugging MB5B tcode.Can anyone tell me.

Thanks

Re: How to find opening quantity and value while debugging MB5B tcode

Former Member — Fri, 13 Sep 2013 13:11:10 GMT

Hi Ganesh,

1.Copy mb5b program (RM07MLBD) to z program .

2.Submit to this copied Z program from your Z program by passing parameters.

3.Export g_t_totals_flat it table from copied Z program to memory id..

4 import it table from memory id after your submit statement in your z program.

5 Fields ANFMENGE and ENDMENGE of g_t_totals_flat will give you the OPENING and CLOSING quantities repectively.

Rest of the material movement quantities can be calculated and segregated By fetching data from MSEG and processing them using different Movement types.

you will get all the columns which is displayed in mb5b program.

Check these links it will help to you..

http://scn.sap.com/docs/DOC-33774

in above link they have made enhancement for mb5b. if you copied to z program as i told in above steps no need to enhance standard program.

Reward points if it is helpful.

let me know if you have any query

Thanks & Regards

Santosh

Re: How to find opening quantity and value while debugging MB5B tcode

Former Member — Sat, 14 Sep 2013 05:35:35 GMT

Hi Santosh,

Actually i have developed report on Price Stock Ledger with selection screen fields are Region,Date,Site,Material Number.Now calculated all quantities(Intransit,urchase,Sales) and Values.If i will give Date as 01.07.2013 to 31.07.2013,period is 3.So we fetch the data from MBEWH table.But in my Values some difference is coming for materials comparing MBEWH table value.I don't know where i went wrong.Please help me.If needed i will post my entire program.

Thanks

Re: How to find opening quantity and value while debugging MB5B tcode

Former Member — Mon, 16 Sep 2013 09:31:50 GMT

Hi Ganesh,

My above solution is to get opening and closing stock values of materials as MB5B output.

But as per your reply it is fully customized report..by debugging only we can found solution.