Functional Location From Equipment

아래 내용은 Equipment 에서 Structure Tab 에 Functional Location 을 가져오는 방법이다. 아래의 내용을 기준으로 쿼리를 작성해 보았습니다. * Equipment 를 조회 SELECT A~EQUNR D~EQKTX " Material Description B~GEWRK AS E_GEWRK C~ARBPL AS E_ARBPL " Equipment Main Work Center A~MATNR AS MATNR " Material I~TPLNR AS E_TPLNR " functional location APPENDING CORRESPONDING FIELDS OF TABLE GT_EQUI_LIST FROM EQUI AS A INNER JOIN EQUZ AS B ON A~EQUNR EQ B~EQUNR LEFT OUTER JOIN ILOA AS I ON B~ILOAN EQ I~ILOAN INNER JOIN CRHD AS C ON B~GEWRK EQ C~OBJID INNER JOIN EQKT AS D ON A~EQUNR EQ D~EQUNR AND D~SPRAS EQ SY-LANGU WHERE A~AEDAT IN SO_DATE AND B~DATBI EQ '99991231'. Functional Location Table Mauricio Gómez asked Oct 23, 2011 | Replies (6)

Hello there I'm making a PM orden functional specification and I'm not able to find out which is the table where I can find the functional location where is the equipment load. I find some views but I want to find the transparent table. 

Can someone please give me a hand? 

Thanks in advance.

Join this group

Best Answer

Updated Aug 14, 2012

The link is EQUI-EQUNR = EQUZ-EQUNR > EQUZ-ILOAN = ILOA-ILOAN > ILOA-TPLNR 
= IFLOT-TPLNR 


Siegfried (Sieg) F. Sanders 
Managing Consultant

Original answer by Sieg Sanders Nov 1, 2011

Improve this Answer

Contributors:

http://sap.ittoolbox.com/groups/technical-functional/sap-log-pm/functional-location-table-4479268