on 08-21-2007 11:00 AM
Hi
I was wondering if anyone could tell me a way to get (without a custom report) the following info? Its just a one off request so we dont want to build a report. I tried manually with se16 but I have not found the right tables yet.
I would like ultimately to be able to see for any POs created which BOMs were missing (eg not set up) when the PO was created.
I tried this through various tables but it hard to find a set of tables which gives you the info that you need. We need to know the PO no and any components BOMs on the order. This usually means that you also need to know the parent no, component no and BOM no.
I am proficient with databases and can pull these files together afterwards.
Any ideas?
Hi,
you can separte the PO document by item category
make a query with required inputs.
regards,
mbkm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In what table can I see what BOMs were linked to the PO (not in theory) but which ones were actually picked up on the PO either through Po create or through the user re-exploding the BOM? When you click on the component info in me23n, how can I see that info in a table?
I really only need to know which components are on this screen/were recognised against the parent no but this is a structure and I am looking for this info in a table as it is one request and i plan to pull manually.
Help rewarded
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.