ABAP - CRM Tables & Fields

[Former Member]

Hello all,

I am working on something related to CRM IBASE- IBASE COMPONENTS and  COMPONENT DETAILS-  precisely the ADDRESS DETAILS.  say I have an INSTALLED BASE - hospital and its COMPONENT - BUILDING - Which has an address - a further component to the BUILDING - SAY ROOF.

Now the I am trying to find a way using which I can fetch the ADDRESS DATA from ADRC table by passing ADDRNUMBER.

Here is what I found.

PRODUCT_ID/OBJECT_ID of the Component entered in COMM_PRODUCT helps me with PRODUCT GUID.

PRODUCT_GUID if entered in COMM_PR_FRG_REL -> FRG_GUID

FRG_GUID if entered in COM_LOCAT_ADDR -> ADDRNUMBER

ADDRNUMBER in ADRC -> Result

I need to find a table that has the combination of PRODUCT_ID/OBJECT_ID of an IBASE COMPONENT and its Instance number. This further links IBASE Number to the Component For example : COMPONENT- BUILDING is linked to IBASE HOSPITAL based on INSTANCE & IBASE NUMBER.

appreciate your help!

Karthik

[former_member223917]

Hi Karthik,

       Here are some hint may help you. You can refer to table IBIN, IBST, IBADDR and ADRC.

==> IBIN-INSTANCE = IBST-PARENT

==> IBIN-IN_GUID

==> IBADDR-SEGMENT_RECNO = IBIN-IN_GUID

==> IBADDR-ADRNO => Address number

==> ADRC-ADDRNUMBER = IBADDR-ADRNO

Thanks

Hock Lin

[Former Member]

Hello Hock,

The table IBADDR only has relevant address number information regarding the IBASE. Not the component related to IBASE under it.

In this scenario, The address block of information is attached to the Component as a component detail. The address is not attached to the IBASE. So IBADDR is not working for me.

is there any other way ?

Appreciate your help

thanks,

Karthik