cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to get spare part list assigned to equipment BOM

Badalsatyam
Explorer
0 Likes
576

hello everyone,

how to write logic to get spare part list which is assigned in equipment BOM.

Accepted Solutions (0)

Answers (1)

Answers (1)

Vaibhav-Mishra
Contributor

hello @Badalsatyam ,

Here you go:

Step 1: get EQUNR (Equipment) from table EQUI and Pass EQUNR to table EQST. EQST will give you the link between Equipment and BoM.

Step 2: Pass the EQUNR, WERKS = Plant, STLAN = '4' and fetch the value of STLNR and STLAL from EQST.

Step 3: Pass the values of STLNR, STLAL and STLTY = 'E' in table STAS and fetch the value of STLKN.

Step 4: Pass the values of STLTY = 'E', STLNR, STLKN in table STPO and fetch the value of IDNRK. This IDNRK is the BoM material assigned to the EQUNR (Equipment).

Regards,

Vaibhav Mishra

 

Badalsatyam
Explorer
0 Likes
thank you Vaibhav