Skip to Content
avatar image
Former Member

Required specific data given a list of material numbers

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Dec 01, 2016 at 02:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 01, 2016 at 03:05 PM

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

    Thank you.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 01, 2016 at 04:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 01, 2016 at 07:47 PM

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

    Thank you for your help.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2016 at 03:01 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2016 at 07:50 AM

    Edgar,

    This should really be a separate post.

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

    PeteA

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2016 at 02:35 PM

    Pete:

    No problem, I'll post a new question.

    Thank you

    Add comment
    10|10000 characters needed characters exceeded