Function Module for listing Equipment based on Material

[Former Member]

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.

[jogeswararao_kavala]

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

[satyabrata_sahoo3]

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

[Former Member]

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.

[satyabrata_sahoo3]

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

[Former Member]

Why do you need a function module?

[Former Member]

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.

[Former Member]

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