CRM Table containing IBase GUID and Product GUID

[Former Member]

Hi experts,

Could you please give me the table containing IBase GUID and Product GUID.

My requirement is to bring the Warranties in the Ibase relationship tab in IB52 transaction. Warranties should be corresponding

to product(Material) corresponding to the IBase.

Regards,

Deepthi

[robert_kunstelj]

Check this relationships:

IBASE-IBASE = IBIN-IBASE

IBIN-INSTANCE = IBST-INSTANCE.

IBST-ROOT = IBINOWN-INSTANCE.

IBINOWN-OBJKEY = COMM_PRODUCT-PRODUCT_GUID

You can also use fm CRM_IBASE_COMP_GET_DETAIL in which you pass the instance from (IBIN) to structure i_comp-INSTANCE. In the return structure E_COMP_DET-OBJNR you will get the GUID which is in same format as in table COMM_PRODUCT that stores products.

Regards.

[Former Member]

Hi ,

My problem is resolved by using COM_TA_R3_ID table.

Here R3IDENT field will give the product_id of the IBASE and R3MAT_ID will give the product id of the basic material.

By using FM CRM_IBASE_COMP_GET_DETAIL in the field obect_id we will get product id of IBASE .

Then passing that to R3IDENT field we will get basic product guid from R3MAT_ID field.

then from comm_product table we will get GUID of basic material

Regards,

Deepthi