Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.