Skip to Content
0
Former Member
Sep 12, 2007 at 09:56 AM

How to Perform Calculation Among Columns

22 Views

Hi All,

This is my first time developing UI addons. I have coded the following:

Private Sub SBO_Application_ItemEvent(ByVal FormUID As String, ByRef pVal As SAPbouiCOM.ItemEvent, ByRef BubbleEvent As Boolean) Handles SBO_Application.ItemEvent

Try

If pVal.FormTypeEx = "149" And pVal.EventType = SAPbouiCOM.BoEventTypes.et_FORM_DATA_UPDATE = False And _

pVal.ItemUID = "38" And pVal.ColUID = "U_CPinTon" And pVal.EventType = SAPbouiCOM.BoEventTypes.et_VALIDATE And _

pVal.ActionSuccess = True Then

SBO_Application.MessageBox("Hello!")

End If

Catch ex As Exception

SBO_Application.MessageBox(ex.Message)

End Try

End Sub

The above is to catch the change event of a specfic column (line data) in the standard Sales Quotation screen (Form=149 Item=38 Column=U_CPinTon).

Actually I want to get the value of that column and use the value to update another column. However, I don't know how to use or reference to a cell in the line data table.

Please kindly help. Many many thank in advance!!!

P.S. Formatted Search can help in this case. That's why I need to use UI API.

P.S.S. SBO version: 2005B PL27

Patrick