avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 01, 2016 at 08:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content