What are the relation tables between IBASE and product?

[former_member299673]

Hi All,

My requirement is, I want to find the product for the given IBASE.

Im not able find the relation tables b/w ibase and  the product.

I want to do it through abap query only.

Please provide relationship tables.

Thanks.

[deepak_sharma_sap]

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

Hi,

Please check the link.

Thanks

Deepak Sharma

[former_member299673]

Hi Deepak,

In our system every ibase tables have data but ibinown has zero entries. Im not able to find the realation.

Thanks.

[deepak_sharma_sap]

Did you try:

Your Ibase = IBIN-IBASE.

COMM_PRODUCT-PRODUCT_GUID = IBIN-OBJNR

Thanks

Deepak Sharma

[former_member299673]

Hi Deppak,

we cannot directly pass objnr to product guid. i converted it to guid using 'convert_guid', Though i'm not able to find.

Thanks.

[deepak_sharma_sap]

Hi Narendra,

In the initial reply which contains the link to a thread , there is mention of 2 FMs.

  Also there are couple of other FMs that link Product and IBASE:

1. CRM_IBASE_COMP_FIND

2. CRM_IBASE_COMP_FIND_MULTI

pass the Product ID and GUid to get the IBASE.

I_COMP_DET-PRODUCT_ID    = PROD_ID

I_COMP_DET_OBJECT_GUID = PROD_GUID

If you debug them , I am sure you will get the linkage.

In my current Project we are not using IBASE or Product , else I would have debugged them to let you know the details.

Apologies.

Deepak