Query to display BOMs Header and Item

[Former Member]

Hello SAP gurus

I am trying to create a query to display BOMs with header and item. For that I am using tables MAST, STKO and STPO.

The table join is:

MAST -> STKO -> STPO

MAST - WERKS, STLNR and STLAL

STKO - STLNR and STPOZ

The system dont show anything...

Can someone help me?

Thanks in advance.

Adelmo Silva

[Former Member · Accepted solution]

Hi Adelmo Silva,

Delete the link between Below table& fields at Table Join,

STKO-STKOZ->STPO-STPOZ

Pleas try and comeback

Regards

Pradeep

[Former Member · Accepted solution]

Yes, it works but...

If I have 2 alternatives, the system show everything even if i select alternative 1 or 2.

I am missing something... because system is showing all alternatives...

System is showing something like this:

Material BOM AltBOM BOM St Item ICt Component Valid from Quantity Un

726121012 00131075 1 01 0010 L 109219 17-12-2007 0,200 KG

726121012 00131075 1 01 0020 L 109230 17-12-2007 0,003 KG

726121012 00131075 1 01 0030 L 109232 17-12-2007 1,166 M2

726121012 00131075 1 01 0040 L 726004012 17-12-2007 0,120 M3

726121012 00131075 1 01 0010 L 109526 17-12-2007 0,200 KG

726121012 00131075 1 01 0020 L 109232 17-12-2007 1,166 M2

726121012 00131075 1 01 0030 L 726004012 17-12-2007 0,120 M3

Edited by: Adelmo Silva on Jan 9, 2008 9:07 AM

[Former Member · Accepted solution]

Hi Silva,

Insert the table STAS between STKO and STPO

Delete the Field link STKOZ-STASZ-STPOZ.

Plz Try, i hope this, will solve your problem, ifso please reward and close thet thread.

[Former Member · Accepted solution]

Yes!

Thank you very much Kumar.

Adelmo Silva