topic Re: Capturing Current stock from MB5B in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/capturing-current-stock-from-mb5b/m-p/6602209#M1437484 <HTML><HEAD></HEAD><BODY><P>NEW-PAGE PRINT ON PARAMETERS print_parameters </P><P> NO DIALOG. </P><P> SELECT * </P><P> FROM sflight </P><P> INTO sflight_wa </P><P> WHERE carrid = spfli_wa-carrid AND </P><P> connid = spfli_wa-connid. </P><P> WRITE: / sflight_wa-carrid, sflight_wa-connid, </P><P> sflight_wa-fldate ... </P><P> ENDSELECT. </P><P> NEW-PAGE PRINT OFF. </P><P></P><P>you will get the output in spool</P><P>pick the spool number and get those values into internal table</P><P>In the internal table read 5 to 9 lines you will get the values</P><P>this is a long procedure</P></BODY></HTML> Tue, 09 Feb 2010 07:30:40 GMT Former Member 2010-02-09T07:30:40Z Capturing Current stock from MB5B https://community.sap.com/t5/application-development-and-automation-discussions/capturing-current-stock-from-mb5b/m-p/6602208#M1437483 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Greetings.</P><P></P><P>I am developing a Classical report in which i want to perform some calculation upon the Current stock of material at any Depo.</P><P></P><P>The same is showing in the standard report through the transaction <STRONG>MB5B</STRONG> by running it for <STRONG>Storage Loc/ batch Stock</STRONG> option..</P><P></P><P>Eg.:</P><P></P><P>Plant 101 B DEPOT</P><P>Material 1001-00002</P><P>Description CEMENT</P><P></P><P>Stock on 17.01.2010 *<STRONG>1.500 TO</STRONG></P><P>Total Receipts <STRONG>310.000 TO</STRONG></P><P>Total Issues <STRONG>310.250- TO</STRONG></P><P>Stock on 23.01.2010 <STRONG>1.250 TO</STRONG></P><P></P><P></P><P>Can you please tell me how can I get the above highlighted values by direct calling the TCode MB5B &amp; then perform my calculation.</P><P></P><P>hope for your early response.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards</P><P></P><P>Ankur Gupta</P></BODY></HTML> Tue, 09 Feb 2010 07:23:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/capturing-current-stock-from-mb5b/m-p/6602208#M1437483 Former Member 2010-02-09T07:23:25Z Re: Capturing Current stock from MB5B https://community.sap.com/t5/application-development-and-automation-discussions/capturing-current-stock-from-mb5b/m-p/6602209#M1437484 <HTML><HEAD></HEAD><BODY><P>NEW-PAGE PRINT ON PARAMETERS print_parameters </P><P> NO DIALOG. </P><P> SELECT * </P><P> FROM sflight </P><P> INTO sflight_wa </P><P> WHERE carrid = spfli_wa-carrid AND </P><P> connid = spfli_wa-connid. </P><P> WRITE: / sflight_wa-carrid, sflight_wa-connid, </P><P> sflight_wa-fldate ... </P><P> ENDSELECT. </P><P> NEW-PAGE PRINT OFF. </P><P></P><P>you will get the output in spool</P><P>pick the spool number and get those values into internal table</P><P>In the internal table read 5 to 9 lines you will get the values</P><P>this is a long procedure</P></BODY></HTML> Tue, 09 Feb 2010 07:30:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/capturing-current-stock-from-mb5b/m-p/6602209#M1437484 Former Member 2010-02-09T07:30:40Z