How to create a Primary foriegn key because there is no PFK
in account for Opprtunity ,it is 1:M relationship
- 2 Answers
- 7170 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhuri motwani
Hello,
I assume that 1: M in this case is 1 account linked to many
opptys. and the reason you would be need a PRIMARY pty
becuase opportunity would be an MVG on Account applets
You can use any column to create a PFK column. Use any
unused field in S_ORG_EXT or S_ORG_EXT_X to create a
field "Primary Opportunity Id"
On the table level, on S_ORG_EXT, set the Foreign Key Table
as S_OPTY for the chosen field
On the BC,
1. Create a new field "primary Oppty id"
2. create a link between the two BCs and set the Primary Id
field as above
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / shankar
it is not possible to create in account for opty. the reason
is you were not aware of the entities (say what is contact,
opty,account,activity) Opty is a lead through which we
generate income. account is an organization it can be
internal or external. You are trying reversal that is not
possible
| Is This Answer Correct ? | 1 Yes | 0 No |
plz send me if any body has study material for seibel testing plz can any body say is there any website for seibel testing (interview questions)& correct answer site this is my emailid renu.devendra@yahoo.com plz plz plz
What is difference between lov and picklist??
How is server monitoring managed using the load balancing concept?
when will raise hand held errors?
Name the databases you have worked on?
Why do you need to create employees at the database in Siebel?
what is implied join. Where do we find it ?
What is eapps.cfg file. and what is its significance?
What is the difference between pick applet and dynamic picklist?
Explain how to import list of values?
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.
In hierarchial picklist if we select Country as "USA" then we get state & City Values constrained to USA. If we Select Country Other Than USA, We should get state ans city values Empty How do we do this For 1 reccord of Country we can do this using OnFieldUpdateSet Bc UserProperties but if we want to do this for 50 records how to do this
SAP 
