CRM Technical - ABAP - Tables linkage.

[Former Member]

I wonder how is the CRMD_ORDERADM_H table linked to IBIB via CRMD_LINK ?

or is there any other table via which both CRMD_ORDERADM_H and IBIB are linked?

Thanks

Karthik

[Former Member]

In this link you can find the relationship between IBIB and COMM_PRODUCT. COMM_PRODUCT to CRMD_ORDERADM_H is not so dificult.

Regards,

Felipe

[Former Member]

Definitely CRMD_ORDERADM_H with COMM_PRODUCT and then IBIB did not help me.

Here is the situation I need to fetch the I base number based on the order number.

So I ve got the order number and I need to establish a link between the order header table and IB header table.

@Frederic Girod

Well I tried to use the FM CRM*_ORDER*_READ*. but I am not really sure on how to use that FM.

Let me know if you ve got any steps for this FM using which I could solve this problem?

Thanks,

Karthik.

[Former Member]

Well I saw that link you ve given me. As mentioned before, I am a newbie here.

I am not so well versed with using Function Modules. I tried goin there to use that.

It would be great if you can help me with some steps that ll help me get to the answer.

Thanks,

Karthik

[Former Member]

I can this example

Also, here is a code snippet from IBIB to CRMD_LINK you can do the inverse way:

"---------------------------------------------------------------------- *"

   "Local Interface: *"  IMPORTING *"     REFERENCE(IV_IBASE) TYPE  IB_IBASE

   "  EXPORTING *"     REFERENCE(ET_GUID_LIST) TYPE  CRMT_OBJECT_GUID_TAB *

   "----------------------------------------------------------------------

   TYPES: BEGIN OF ty_ibase,

     guid TYPE crmt_object_guid,

     END OF ty_ibase.

   DATA: lv_ibguid   TYPE guid_16,

         lt_guid_ref TYPE STANDARD TABLE OF ty_ibase,

         lt_guid_set TYPE STANDARD TABLE OF ty_ibase,

         lt_guid     TYPE crmt_object_guid_tab.

   CHECK iv_ibase IS NOT INITIAL.

   SELECT SINGLE ib_guid_16

     FROM ibib INTO lv_ibguid

     WHERE ibase = iv_ibase.

   CHECK sy-subrc EQ 0.

   SELECT guid_ref

     FROM crmd_srv_refobj

     INTO TABLE lt_guid_ref

     WHERE ib_comp_ref_guid = lv_ibguid.

   CHECK sy-subrc EQ 0.

   SELECT guid_set

     FROM crmd_srv_osset

     INTO TABLE lt_guid_set

     FOR ALL ENTRIES IN lt_guid_ref

     WHERE guid = lt_guid_ref-guid.

   CHECK sy-subrc EQ 0.

   SELECT guid_hi FROM crmd_link

     INTO TABLE lt_guid

     FOR ALL ENTRIES IN lt_guid_set

     WHERE guid_set = lt_guid_set-guid.

   et_guid_list = lt_guid.

[FredericGirod]

Hi,

I didn't have my notes here, but there are some functions module for CRM starting with CRM*_ORDER*_READ* ..  you could test it with a program that have the exact same name.

Maybe in this programs/functions you will find all your answers

regards

Fred