on 09-18-2014 2:09 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.