Query BOM

[antonio_bruno]

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]

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]

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]

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]

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