/scripts/ahub.form.attachments.js
0

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

Nov 30, 2016 at 09:12 PM

42

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Peter Atkin Dec 01, 2016 at 08:10 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content