I have a list of 1000 Functional Locations. How do I filter to determine which ones have a BOM?

[Former Member]

I have a list of 1000 functional locations in SAP and I want to determine which ones need a BOM. (i.e., I want to be able to say "out of 1000 functional locations, we have 489 BOM's that still need to be created").

One solution is to go through each functional location one by one to look for BOM, but that would take forever.

Thanks

[peter_atkin]

Bob,

Create a query (SQVI or SQ01/2) and join table IFLOS and TPST using the TPLNR field. Make sure you use an "outer join" btween the two tables.

PeteA