Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Table required

Former Member

‎2007 Dec 04 3:44 PM

0 Likes
537

Hi friends,

Could you please tell me the tables and transactions to see the equipments as I have a requirement where in I have to see all the materials that pass through a particular equipment. ( Didn't get the reply from MM forums).

Regards,

Vishnu.

3 REPLIES 3
Read only

Former Member

‎2007 Dec 04 3:51 PM

0 Likes
505

EQ* are the tables, and IE* are the transactions.

Albert

Read only

Former Member

‎2007 Dec 04 3:55 PM

0 Likes
505

Table: EQUI

T.cide : IE03

Read only

Former Member

‎2007 Dec 04 4:24 PM

0 Likes
505

When you are looking for all the materials that go use a particular equipment, you are actually looking at the equipment to BOM link. This is stored in the EQST table. Once you get the equipments from EQUI, go to this table to get the BOMs of products made on this equipment. Then go to the BOM information to get all the components of the BOM. Go to STKO to get the product and then for getting the BOM information, don't go to the rest of the tables directly, instead use CSAP_MAT_BOM_READ.

Depending on if the equipment is used in production or maintenance you may to look at some other tables as well.