How do you create intersection table?
- 1 Answers
- 7487 Views
- Siebel Systems, I also Faced
- E-Mail Answers
Answer / rkreddy
we can create intersection tables through wizard
| Is This Answer Correct ? | 10 Yes | 1 No |
What does business component user mode indicate?
What is purging in siebel?
How is server monitoring managed using the load balancing concept?
What language you used to write bs?
why did use the siebel crm?
Where will you see the Customer/Order details in Siebel?
What difference between join specification and join definition?
Explain while importing product or account data why we are populating bu_id?
This is krishna, I created new Table,Bc,Link,Bo,view,screen TABLE : CX_ECB_S_TAT BC : ECB TAT BC Link : ECB TAT BC/Service Request Bo : ECB TAT BO View : ECB TAT View Screen : ECB TAT Screen and I created new "X_ECB_TAT_ID" Column for foregin key relation ship in "S_SRV_REQ" Table [in colum properties I specified Forieignkey Table-CX_ECB_S_TAT] and I created "TAT Id Ext" Field with "X_ECB_TAT_ID" Column in "Service Request" BC. I created Link"ECB TAT BC/Service Request". in this link I specified "Destination Field-TAT Id EXT".( Parent BC : ECB TAT BC, Child BC : Service Request) --------------------------------------------------- There is two Screens 1)ECB TAT Screen 2)Service Request Screen in First Screen : ECB TAT Screen Parent BC : ECB TAT BC Fields : Type,Area,Sub Area,TAT I given the field values to Type,Area,Sub Area and based on field values I given "TAT" field value. now we will go to Second Screen : Service Request Screen Child BC : Service Request Fields : INS Product,INS Area,INS Sub-Area,TAT I given same values(Parent bc Field Values) to INS Product,INS Area,INS Sub-Area then should be update "TAT" Field value (I mean Parent BC same "TAT" Field vaue should be update in "TAT" Field in Child BC) I wrote script for above requirement in "SetFieldValue" Event in "ECB TAT BC" function BusComp_PreSetFieldValue (FieldName, FieldValue) { if(FieldName == "TAT") { var Bo = TheApplication().GetBusObject("ECB TAT BO"); var Bc = Bo.GetBusComp("Service Request"); this.ActivateField("Type"); this.ActivateField("Area"); this.ActivateField("Sub Area"); this.ActivateField("TAT"); var sType = this.GetFieldValue("Type"); var sArea = this.GetFieldValue("Area"); var sSubArea = this.GetFieldValue("Sub Area"); var sTAT = FieldValue; //this.GetFieldValue("TAT"); var Bc1 = Bo.GetBusComp("Service Request") with(Bc1) { var exp = "[INS Product] = '" + sType + "' AND [INS Area] = '" + sArea + "' AND [INS Sub-Area] = '" + sSubArea + "'"; ActivateField("INS Product"); ActivateField("INS Area"); ActivateField("INS Sub-Area"); ClearToQuery(); SetViewMode(AllView); SetSearchExpr(exp); ExecuteQuery(ForwardOnly); var cnt = CountRecords(); ActivateField("TAT"); var fst = FirstRecord(); while(fst) { SetFieldValue("TAT",sTAT); fst = NextRecord(); } } } return(ContinueOperation); } but in "Service Request" BC "TAT" field value updating existing records,not updating creating new necords. I should update "TAT" field value to creating new records. where I have to write script in which event in which BC for this. please post detail script for this. from last 15 days i'm working on this. please help me on this. thank you so much in advance.
Is there any 'user property' to make the whole field in a b.c read only, by some condition. e.g:- if priority=closed the whole record should be read only
I checked out one object from server to my local, after checking out my local Database and userid has been corrupted. now i want to release the lock. How can i do this, can any one help me regarding this?
By what way do you give Responsibilities to employees in Siebel ?
SAP 
