Skip to Content
0

Required specific data given a list of material numbers

Dec 01, 2016 at 01:09 PM

47

avatar image

Hello everyone:

I need to get the following information, and be able to tabulate it in an Excel table format. Given a list a material numbers, I need to get at least the stock qty., cost/unit and Bin Location. I already got other information as well, like material number, description, F/L associated to the F/L, but the additional information aforementioned is not available from the transaction code I'm using..

Thank you for your help on this matter.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Peter Atkin Dec 01, 2016 at 02:15 PM
0

Edgar,

Which transaction code are you using?

You should be able to get the required material data from tables MARA, MARC, MARD and MBEW.

PeteA

Share
10 |10000 characters needed characters left characters exceeded
Edgar Agront Dec 01, 2016 at 03:05 PM
0

I'm using MB51. For the transactions you mentioned I got a message the transaction does not exist.

Thank you.

Share
10 |10000 characters needed characters left characters exceeded
Peter Atkin Dec 01, 2016 at 04:22 PM
0

Edgar,

MARA, MARC, MARD and MBEW are tables which you can view via SE16.

If you want this data in MB51 (or a Z copy of this transaction), then you will need to discuss this with your ABAP Team.

You could also look at creating a query (SQVI or SQ01/02) and link MSEG with MARA, MARC, MARD and MBEW.

PeteA

Share
10 |10000 characters needed characters left characters exceeded
Edgar Agront Dec 01, 2016 at 07:47 PM
0

OK, yes I got the info I wanted but using a combination of two tables.

Thank you for your help.

Share
10 |10000 characters needed characters left characters exceeded
Edgar Agront Dec 02, 2016 at 03:01 PM
0

Pete:

Could it be possible to modify a table to only show the following information:

Functional Location

Material associated w/F/L

Stock Level

Price, ea

Total cost

Bin Location

Thank you.

Share
10 |10000 characters needed characters left characters exceeded
Peter Atkin Dec 06, 2016 at 07:50 AM
0

Edgar,

This should really be a separate post.

Please create a new post and I'll try to give answers..

PeteA

Share
10 |10000 characters needed characters left characters exceeded
Edgar Agront Dec 06, 2016 at 02:35 PM
0

Pete:

No problem, I'll post a new question.

Thank you

Share
10 |10000 characters needed characters left characters exceeded