Transaction MB5L

[Former Member]

Hi everyone,

My Department offent use transaction MB5L to check the Stock. Now at the end of this year they want to make a report on Stock over the year 2015(from January to this December). It looks like this:

Materialgroup    Material      Stock      Value      Deliver      Processed/unprocess Material

XX                         xx              xx            xx           xx                       Processed

So i would like to have some ask you some question:

1. Base of the transaction MB5L, How can i extract the report for Stocklist over the year 2015? (i am new with SAP so its very nice of you if you can show me step by step) i mean which table in SAP ERP can i extract this Information?

2. In the Stocklist made by transaction MB5L the Information: "Materialgroup" and " Processed/unprocess Material" arre not available. How can i find this Information?

Thank you very much and wisch you a good day!

[JL23 · Accepted solution]

Are you an ABAPer? Just asking as I wonder how you want create a report if you are not even able to read the source code or debug MB5L to know from where the values are fetched.

Asking for tables is basic, if you are so new to SAP that even F1 and technical field help is unknown then please start reading this:

And you have to ask your requesters what Processed/unprocess Material  means for them and how this value shall be determined

[Former Member · Accepted solution]

Thank Jurge for quick reply. In my Department we use SSIS to extract the table from SAP to SQL Server . So i need to know which table have Information i needed. I am Reading your link and try to find the table name but it s complicated