Skip to Content

SAP CRM - FM/Tables to fetch Service Contracts associated with equipment ID - Custom Report Query

Hi Guys,

I've to create a custom report where user enter equipment ID as input and output should be all the Service Contracts where the input equipment id is there. In other words read/get all the 'Service Contracts' based on product ID (equipment) ..

Example:

Input field equipment = ABX001

Output = All the contracts where Item has 'ABX001' assigned to.

I've tried checking comm_product but it has only the guid for equipment. How could this be achieved?

Thanks,

Dj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 14, 2017 at 10:52 PM

    SAP-Help states that Equipments are Stored as Objects in IBASE (Installed Base). You should be able to verify this provided you can see some of the data using trx."IB53" ... And there is a useful SAP-Wiki on the linking of Equipment and Service Contract in CRM via GUIDs and the Data retrieval via Function Modules.

    This Blog by Former Member provides a good screenshot of the Links between the different tables in CRM (such as "COMM_PRODUCT" entries for an Equipment and "IBIB" and "IBIN" of the InstalledBase) ...


    Hope this helps

    Nic T.

    Add comment
    10|10000 characters needed characters exceeded