Skip to Content

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

Oct 10, 2017 at 09:50 PM


avatar image

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) ..


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?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nic Teunckens 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 Maricela Valenzuela Gómez 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.

10 |10000 characters needed characters left characters exceeded