topic Re: Function Module for listing Equipment based on Material in Application Development and Automation Discussions

Function Module for listing Equipment based on Material

Former Member — Thu, 15 May 2014 14:56:03 GMT

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.

Re: Function Module for listing Equipment based on Material

jogeswararao_kavala — Thu, 15 May 2014 15:22:50 GMT

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

Re: Function Module for listing Equipment based on Material

satyabrata_sahoo3 — Thu, 15 May 2014 15:40:51 GMT

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

Re: Function Module for listing Equipment based on Material

Former Member — Fri, 16 May 2014 05:16:38 GMT

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.

Re: Function Module for listing Equipment based on Material

satyabrata_sahoo3 — Fri, 16 May 2014 14:15:58 GMT

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

Re: Function Module for listing Equipment based on Material

Former Member — Fri, 16 May 2014 15:19:40 GMT

Why do you need a function module?

Re: Function Module for listing Equipment based on Material

Former Member — Fri, 16 May 2014 18:15:56 GMT

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.

Re: Function Module for listing Equipment based on Material

Former Member — Fri, 20 Jun 2014 05:52:21 GMT

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