ABAP - CRM Tables & Fields

243 Views

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