on 03-19-2015 6:00 AM
Hi SAP Gurus,
I need to get the BOM Component data Dump as per the alternative BOM Wise. For this i am facing the issue in stpo table. i am not able to get the Component dat alternative BOM Wise. Suppose i am having alternative BOMs 1,2,3,
1BOM is having components as line items x,y,z,w,r
BOM COMPONENTS item node
1 X,Y,Z,W,R 1,2,3,4
2 X,Y,Z,W,R,A 1,2,3,4,5
3 X,Y,Z,W,R,A,Q 1,2,3,4,5,6
while passing the data item node and BOM No into stpo table i am not getting the component data as per the alternative BOM Wise 1,2,3. I am not able to get the duplicate component line items as per the alternative BOM Wise. Only component line items showing as per the BOM No wise. But i need as per the alternative wise. please guide me the way forward to me.
Thanks,
Mastan.
Hi.
Try this join:
MAST > STKO > STAS > STPO
WHERE
MAST-STLAL = STKO-STLAL
MAST-STLNR = STKO-STLNR
STKO-STLAL = STAS-STLAL
STKO-STLNR = STAS-STLNR
STKO-STLTY = STAS-STLTY
STAS-STLTY = STPO-STLTY
STAS-STLKN = STPO-STLKN
STAS-STLNR = STPO-STLNR
Arturo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Mastan,
You need to check the field Counter STPOZ among STKO and STPO tables you find out the alternative item details.
BR
KK
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 | |
8 | |
7 | |
4 | |
4 | |
3 | |
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.