Skip to Content

Table to link Equipment/Serial No to Install Base No.

Hello,

I can find the link to my serial no/equipment and material through the table COM_TA_R3_ID however in which table should I pass either the equipment/serial no to get my install base no?

I have tried checking tables IBIB and IBIN however for both of these tables the output is only seen after I enter the install base no, however I need to input my serial no/equipment no to get my IB No, please advice in which table will I find this link.

Kind Regards

Atul

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2013 at 04:16 AM

    Hi,


    Have a look at the following links.

    http://scn.sap.com/thread/3262568

    http://scn.sap.com/thread/1108681

    Hope this helps.

    Regards,

    Naresh

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Nareshkumar,

      You are right the following function module mentioned below is of great help and helps to resolve the issue.

      CRM_IBASE_COMP_INDOBJ_SEARCH in se 37 and click on execute.

      Here you need to pass the equipment no in the iv_object_id= 10004304

      and iv_object_family= 0401 as shown below in the e.x.

      Also attaching install base screen shot.

      Click on 1 entry as per the first screen shot, you will get the install base no 7831

      Now I am removing Equipment 10004304 from Install Base No 7831 and linking the same to install base 7833.

      Again when I execute the same function module with the equipment 10004304, I get the install base no 7833 this time.

      Kind Regards

      Atul

      Untitled.png.1.png (106.7 kB)
      Untitled.png.2.png (144.3 kB)
      Untitled.png.3.png (106.7 kB)
      Untitled.png.4.png (158.4 kB)
      Untitled.png.5.png (107.1 kB)
  • author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2013 at 09:25 PM

    Hello Atul

    i don't think there is any direct table to link equipment no and ibase.

    but you cna try this function module CRM_IBASE_COMP_FIND_MULTI.

    Regards

    Naresh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.