topic Re: Query BOM in Application Development and Automation Discussions

Query BOM

antonio_bruno — Wed, 23 May 2012 12:57:53 GMT

Hi,

excuse me, i've problem to create an infoset (SQ02) with a left outer join between MVKE, MAST, STPO. It's possible only between MVKE and MAST.

Is there a solution to join the three table?

Thanks.

Best regards.

Antonio

Former Member — Wed, 23 May 2012 13:11:26 GMT

Hi you can join three table MVKE, MAST, STPO

MVKE and MAST can be join on the basis of field MATNR and WERKS with MTNR as primary Key

now for data in table MAST you can join table MAST and STPO on the basis of feild

STLNR ,

ANDAT

ANNAM

AEDAT

AENAM

antonio_bruno — Wed, 23 May 2012 13:31:15 GMT

Hi,

i've problem with an infoset, in particular:

1) i can't use a triple left outert join;

2) i can't use only the filed mast-stlnr when i added the STPO as addition table.

Thanks.

Antonio

Former Member — Thu, 24 May 2012 11:58:46 GMT

Dear Antonio,

what exectly information you want regarding BOM ???

Table MVKE link with MAST through matnr and werks,
link table mast and stpo through STLNR only.

Regards,
Ravi

antonio_bruno — Tue, 29 May 2012 13:33:13 GMT

Hi,

i want only join (outer join) MVKE, MAST, STPO to see the materials with/without BOM.

But in the infoset i can only use one left outer join.

Thanks and best regards.

Antonio