Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ABAP - CRM Tables & Fields

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 Member
Not what you were looking for? View more on this topic or Ask a question