This is very common and basic question comes in our mind while we are working as a siebel developer. Through this post i am going to explain you how we can able to find the relationship between the two entities with the help of siebel Tools.
Ex: If we want to find the relationship between "Account" & "Contact" how we know that the relationship between "Account & Contact" are either 1:M or M:M or in other relation.
Is Guessing is the right approach?? or any other method is there to find the relationship of two entities in siebel??
Well... Now we are going to have a look about the following
1. Navigate to Link object definition and query on below fields with
Parent Business Component: Account
Child Business Component: Contact
It returns few records, It indicates Account & Contact is having either 1:M or M:M, till this point we are not sure whether "Account & Contact" or in 1:M or M:M realtionship.
2. To find out the exact relation, check the "Inter Table" Column in Link object definition.
If Inter Table column is specified with any value indicates means two entities are having M: M relationship with each other. If record is present and "Inter Table" property is blank it indicates those two entities are in 1:M relationship.
3. In Link Object definition there is no query results found then the relationship between those two entities are not in 1:M or M:M relationship.
Example: Now we are going to check the relationship between "Service Request & Quote"
we will check based on above approach only
Navigate to Link Object definition in Object Explorer --> Query with "Parent BC & Child BC" fields
with "Service Request & Quote"
Link Object Definition: --> click on Query button, and enter "Parent Business Component: Service Request and Child Business component: Quote" click on enter button
we got a record entry in Link Object definition with "Inter Table" property as blank. It represents "Service Request and Quote is having a 1: M relationship.
In Revers there is a M:1 relationship between "Quote and Service Request".
Now we will check the same relationship in reverse manner to confirm the relationship in Siebel Tools. For that in Parent Business Component Property enter "Quote" and in Child Business component property enter "Service Request", Now we are not got any records in the Link Object definition, that means Quote to Service Request is M:1 in this case Join Object definition should be present.
(This is the one of the approach siebel developers using to find out the relationship between the entities)
Ex: If we want to find the relationship between "Account" & "Contact" how we know that the relationship between "Account & Contact" are either 1:M or M:M or in other relation.
Is Guessing is the right approach?? or any other method is there to find the relationship of two entities in siebel??
Well... Now we are going to have a look about the following
1. Navigate to Link object definition and query on below fields with
Parent Business Component: Account
Child Business Component: Contact
It returns few records, It indicates Account & Contact is having either 1:M or M:M, till this point we are not sure whether "Account & Contact" or in 1:M or M:M realtionship.
2. To find out the exact relation, check the "Inter Table" Column in Link object definition.
If Inter Table column is specified with any value indicates means two entities are having M: M relationship with each other. If record is present and "Inter Table" property is blank it indicates those two entities are in 1:M relationship.
3. In Link Object definition there is no query results found then the relationship between those two entities are not in 1:M or M:M relationship.
Example: Now we are going to check the relationship between "Service Request & Quote"
we will check based on above approach only
Navigate to Link Object definition in Object Explorer --> Query with "Parent BC & Child BC" fields
with "Service Request & Quote"
Link Object Definition: --> click on Query button, and enter "Parent Business Component: Service Request and Child Business component: Quote" click on enter button
we got a record entry in Link Object definition with "Inter Table" property as blank. It represents "Service Request and Quote is having a 1: M relationship.
In Revers there is a M:1 relationship between "Quote and Service Request".
Now we will check the same relationship in reverse manner to confirm the relationship in Siebel Tools. For that in Parent Business Component Property enter "Quote" and in Child Business component property enter "Service Request", Now we are not got any records in the Link Object definition, that means Quote to Service Request is M:1 in this case Join Object definition should be present.
(This is the one of the approach siebel developers using to find out the relationship between the entities)
