Skip to main content
Question

SQL to list all materials from MBOM

  • February 28, 2022
  • 1 reply
  • 178 views
R
Hero (Customer)
Forum|alt.badge.img+16
  • ronhu
  • Hero (Customer)
  • 620 replies

Hi,

 

I need a SQL statement, using MANUF_STRUCRE view, this SQL can be drilled down to the bottom of the MBOM, and have all the materials listed?  The layout will be like the contents in the window Product Structure Tab Multilevel Structure. is it possible to have this SQL statement?

 

Thank you.

Ron
    This topic has been closed for comments

    1 reply

    S
    Superhero (Customer)
    Forum|alt.badge.img+28
    • ShawnBerk
    • Superhero (Customer)
    • 1482 replies
    • February 28, 2022

    Does this forum post get you in the direction you are trying to go?

     

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings