on 09-02-2009 11:20 PM
Hi,
we would like to know which tables are used to retrieve the position ID of a material in a BOM product.
Unfortunately structures and FM don't help us because we would have to replicate these tables to CRM and/or to Mobile Sales.
Thanks a lot for any useful hint!
Regards,
Wolfhard
Hi,
BOM header is STKO, BOM item is STPO.
And MAST is the material BOM link.
To check BOM you should look for STLNR in MAST first then use this BOM number to find the item no in STPO-POSNR.
-
for example logic
select STLNR (bom number) from MAST where matnr = material and werks = plant.
then
select POSNR (item no) from STPO where stlnr = bomnumber in first step.
Best regards,
Edited by: Chupong Uthayanwuthikul on Sep 3, 2009 7:47 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.