Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 31, 2008 at 08:29 AM

    HI,

    IBASE-IBASE = IBIN-IBASE

    IBIN-INSTANCE = IBST-INSTANCE.

    IBST-ROOT = IBINOWN-INSTANCE.

    IBINOWN-OBJKEY = COMM_PRODUCT-PRODUCT_GUID

    Regards

    Srinu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 24, 2013 at 01:43 AM

    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 .

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2008 at 05:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2008 at 09:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded