SAP/Plant Maintenance

Functional Location From Equipment

그녀는애교쟁이 2013. 9. 13. 15:26
반응형

아래 내용은 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

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.
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
Contributors:



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