Skip to Content
author's profile photo
Former Member

Report - Urgent

Hi All,

I would like to know is there a transaction, where i can enter a material & find out how much quantity of it is used in the main assembly?

Eg: I should be able to enter

Material = Bearing-A

Main assembly = Car

& the output should show me 50

If no standard transaction or report exists, can i know which tables i need to join to extract this information?

Hope my problem is clear, await inputs.

Vivek

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:43 AM

    Check CS15 - Where used list.

    Regards

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:46 AM

    Hi

    Try CS15

    Vishal...

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:45 AM

    hi Vivek,

    To post the Stock for the Material is MB1C

    To check the Material list MB51

    To check the Stcok MMBE

    Assign the points if it is usefull ......

    Ranjit

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 11:00 AM

    Hi All,

    Wish to inform you, i have tried CS15, but it does not serve my requirement. I am looking for a specific tool / transaction where i can get the info as explained in my example. If no standard transaction exists, then i would need to make a custom report using table join, so let me know which tables should i join.

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 11:07 AM

    Dear Vivek

    Try in T.code CS11 giving ur Finished Product, BOM usage, Plant, PP01

    and enter the required quantity

    or

    U can try with tables

    MAST - Material BOM

    STKO - BOM Header

    STPO - BOM Item Details

    With regards,

    B.Ravindranath

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 11:21 AM

    I will try creating a custom query, using the tables mentioned by you, also would like to know if any of you have an idea about S026? Can i use this in my table join?

    Vivek

    Add comment
    10|10000 characters needed characters exceeded