How to create a Primary foriegn key because there is no PFK
in account for Opprtunity ,it is 1:M relationship
- 2 Answers
- 7310 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 |
What is symbolic url in siebel?
difference between lov and picklist??
Explain how would you delete or merge rows that have the same primary user key and different conflict ids using eim?
If a team is handled by one manager, he will be able to see his team’s activities. And suddenly if the manager is changed, will the new manager be able to see the team members activities or not.
What is the significance of eapps.cfg file?
Explain if gateway server is not present cant we do load balancing?
Hirarchical pick is there in one applet, parent is "country" in this field "IND, USA" r there and child field "City" in this Hyd,Delhi, Bang for india and Newyork, washington for usa .Now if i select ind then Hyd... shown in child field then i select suppose hyd, now come parent field if i select usa & tabout the field still i see "Hyd" in child field unless i select the one of the city related to usa even though i check the immidiate postchange property in field level then how to i see it is Blank or related values
Explain when do we go for dynamic picklist and for pick applet?
Please tell me about the eim tables and base tables are required to your entities?
Explain what is an extension table and how is it related to base table?
In an order screen if the Status value changes from Inprogess to Pending all the line items must become read only
How extension table is related to base table?
SAP 
