Sequencing Parent Business Component

This post has been contributed by Sapna a reader of Siebel Unleashed. Explaining the procedure to create a sequence on Master BC.

---

I was going through the Bookshelf for Creating Sequence Fields. Generally we create sequence field in the Child BC where a Master –Detail relationship already exists for example: Service Request -> Activities(child BC)

What if you want to sequence the Parent (Master) BC itself (Service Request)?

Here is what I tried. Following the Same stepsas in bookshelf with slight change.

Scenario : Sequencing Service Request.

1. Verify that the class of the BC is CSSBCBase or a sub-class of CSSBCBase.
2. Add a Field in the Service Request Bc
   1. Name: Line Number
   2. Type : DTYPE_NUMBER
   3. Column : ATTRIB_14
   4. Join: S_SRV_REQ_X
3. Add a Business Component User property to Service Request BC
   1. Name: Sequence Field
   2. Value : Line Number
4. Create a new Business Component
   1. Name: Service Request.Line Number (Sequence)
   2. Class : CSSSequence
   3. Sort Spec: Sequence (DESCENDING)
   4. Table: S_SRV_REQ
5. Add a field in BC created step 4
   1. Name : Sequence
   2. Join : S_SRV_REQ_X
   3. Column : ATTRIB_14
6. Add the Business Object Component under Business Object à Service Request
   1. Bus Comp : Service Request.Line Number (Sequence)
   2. Link : < blank> do not specify anything.
7. Expose the Field “Line Number” in the Applet.
8. Compile and you are set to go.

Every time you create a New Service Request the “Line Number” will be incremented by 1

---

Please do provide your feedback through comments and ratings if you like the article. Your encouragement is really important in keeping this community going. Looking forward to your contribution.