Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

UDO Updating

Hi All,

I am using UDOu2019s. How to do Adding and Updating in single operation. When form is loading the records are filled in the matrix and by adding empty row at last. If I enter the value in empty row it has to be added, if I changed any value it has to be updated how to do it?

Thanks in Advance

Regards

SAI.K

replied

hi,

for eg:

create Table of type Master Data with necessary fields(eg:TableXYZ)

create UDO for the table @TableXYZ as UDOXYZ

write the code in the usermenu click to open the form

Rs = OCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

Rs.DoQuery("SELECT Code FROM oudo where candefform='Y' order by code")

For i = 1 To Rs.RecordCount

If Rs.EoF = False Then

If Rs.Fields.Item("Code").Value = "UDOXYZ" Then

menuuid = i + 47616

Exit For

End If

Rs.MoveNext()

End If

Next

SBO_Application.ActivateMenuItem(menuuid)

oForm = SBO_Application.Forms.ActiveForm

oForm.Visible = True

regards,

varma

Edited by: Varma on Oct 16, 2008 5:33 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question