cancel
Showing results for 
Search instead for 
Did you mean: 

Link between CRM tables IBIB (IBase Component) and COMM_PRODUCT (Object Id)

Former Member
0 Kudos

I am trying to arrive at the Object ID for an IBase from CRM tables. The IBIN table stores the component of the IBase in the Objnr field - however the GUID for the Object id available in this table is in a format which is different from the GUID format stored in COMM_PRODUCT which stores the Object ID. Is there any other table to establish the link between the tables IBIN and COMM_PRODUCT ? The idea is to arrive at the Object Id details for the IBase in the staging area - where it would not be possible to convert the GUID corresponding to the Object Id using SAP Function Modules.

Thanks,

Ipshita

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

1 ,  COMM_PRODUCT link IBIN

COMM_PRODUCT-PRODUCT_GUID = IBIN-OBJNR

use FM: GUID_CONVERT       convert COMM_PRODUCT-PRODUCT_GUID to IBIN-OBJNR

2, IBIN link IBIB

IBIN-IBASE = IBIB-IBASE .

Former Member
0 Kudos

Pls use the function module

CALL FUNCTION 'CRM_IBASE_COMP_GET_HIERARCHY'

EXPORTING

I_COMP = LIT_COMP

  • I_LEVEL_UP =

I_LEVEL_DOWN = '01'

  • I_LEVEL_UP_ALL =

  • I_LEVEL_DOWN_ALL =

  • I_DATE =

  • I_TIME =

IMPORTING

E_STRUC_IBASE_TAB = IT_IBASE_TABT

EXCEPTIONS

NOT_SPECIFIED = 1

DOESNT_EXIST = 2

OTHERS = 3

.

To LIT_COMP pass the instance and GUID_COMPC. This you can get it from the function moudle CRM_IBASE_COMP_FIND by passing IBIN-IBASE and IBIN-INSTANCE.

Former Member
0 Kudos

HI,

IBASE-IBASE = IBIN-IBASE

IBIN-INSTANCE = IBST-INSTANCE.

IBST-ROOT = IBINOWN-INSTANCE.

IBINOWN-OBJKEY = COMM_PRODUCT-PRODUCT_GUID

Regards

Srinu

Former Member
0 Kudos

Ipshita,

Use FM CRM_IBASE_COMP_GET_DETAIL. Here u have to pass the instance from (IBIN) to structure i_comp-INSTANCE. In the return structure E_COMP_DET-OBJNR u will get the GUID which is in same format as in COMM_PRODUCT. Then u can proceed as per ur requirement.

Thanks

RR