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.

Answer Posted / krishna

ple send me detail script

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is detailed category?

548


Explain the restrictions in siebel that comes while planning the networking topology.

529


What is the use of item identifier.

610


What is siebel?

613


Explain how would you delete or merge rows that have the same primary user key and different conflict ids using eim?

540






Explain whats the difference between siebel 7.5 and 7.8? If we upgarde the application to 7.8 from 7.5 what are the areas we need to give importance from qa(testing) point of view?

513


How would you delete or merge rows that have the same primary user key and different conflict ids using eim?

574


Explain how to import list of values?

546


whats the difference between siebel 7.5 and 7.8?

596


Explain what is s_party table?

567


i need to invoke an external web service from siebel CRM using as input to the web service a value in business component field, i need to display the results in another applet asociated with a virtual business component, does anyone know how to do this? thanks

2124


In a flow, when a Customer has called for enquiring about some product. He does not have any Service tag, Order # or SR#. In this case what kind of Activity will be created and how will the agent proceed with the Activity.

1505


What is the use of virtual bc?

542


Explain where does the primary field of an mvg stored?

483


Explain in brief about siebmtsh.exe.

555