ABAP - CRM Tables & Fields
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!