05-15-2014 3:56 PM
Hi Team,
Anybody guide me through a function module that works in the similar way as Transaction "IH08" with Material number passed as selection parameter.
My requirement is, if i pass a material number, i need a list of equipment that uses the given material as like in Transaction "IH08".
Any suggestion would be helpful for me, Thank you.
06-20-2014 6:52 AM
Hi Team,
We found a Function module that suits my requirement.
We can use
1) CS_WHERE_USED_MAT
2) CS_WHERE_USED_MAT_ANY
Both will get in the Material Number and returns the list of Equipment that uses this material and the sub Materials too.
~Yuvi
05-15-2014 4:22 PM
Because it is based on a simple Select statement, using table EQUI, you can develop a Z function module, with Import field MATNR and Export field EQUNR.
Jogeswara Rao K
05-15-2014 4:40 PM
You can have your own custom FM to get this selecting data from EQUI.
SELECT equnr matnr sernr FROM equi INTO CORRESPONDING FIELDS OF TABLE <Int Table>
WHERE matnr IN im_matnr.
-SS
05-16-2014 6:16 AM
Thank you for your response.
This is the simplest way to achieve my requirement.
I'm Keen in knowing is there any standard function module that can be used for this purpose?
If so i can use that or i will create my own.
Thank You.
05-16-2014 3:15 PM
BAPI_EQMT_DETAIL is there but it did not work fine for me. I am afraid, no such FM available to achieve this.. I had similar situation where I used this logic finally.
-SS
05-16-2014 4:19 PM
05-16-2014 7:15 PM
hi frnd,
Give function group name.description…ok
import : --matnr type equi-matnr
export:-equnr type equi-equnr
Table : - itab like equi
IN THE SOURCE CODE TAB.-----------------------
SELECT EQUNR FROM EQUI INTO CORRESPONDING FIELDS OF TABLE ITAB WHERE MATNR
EQ MATNR.
Fm is ready for input..you can easily check by execute and give matnr value ,get output.
06-20-2014 6:52 AM
Hi Team,
We found a Function module that suits my requirement.
We can use
1) CS_WHERE_USED_MAT
2) CS_WHERE_USED_MAT_ANY
Both will get in the Material Number and returns the list of Equipment that uses this material and the sub Materials too.
~Yuvi