Skip to Content

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

Which is the best way to get data from user difine tables with condition

Hi everyone,

I would like using SBO DIAPI to get UDT data rows, there is a method of UserTable.getbykey can get one row information, but I like to get a list of rows from UDT, and the get list have its condition such as: field1="Type_A" ect.

also I want to avoid using doquery get data from DB, because there is direct access DB potential Suspect.

I am using SBO 2005 PL09 & visual studio(VB.net) 2005 and I only using DIAPI do not using UIAPI.

Thanks for any advice.

Kathy

replied

Hi Kathy,

Unfortunately SBObob.GetObjectKeyBySingleValue only works for the B1 business objects as listed in the documentation.

So, when you don't know the keys (= Code) of the records you want to get from your UDT - there's no way around using Recordset object's DoQuery method!

Sorry,

Frank

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