How to create UDF via SDK ?

[former_member303406]

Hi all,

since there is not much information in the Carriers, manufacturers and other similar tables, we would like to create UDF in order to save more informations. But it seems it is not possible... ! Why are we unable to create UDF in all tables ... or almost all tables ? Is it planned for someday ?

I've been told that though all tables are not exposed through inteface for creating UDF, but it is possible to create UDF in all tables. We have to either use code (DI-API) or we can also compile and use a sample application provided with SDK. In this sample application, we directly enter the table name (like OCRD, OSHP etc) and create UDF.

But... if we add UDF to tables for which we can't add UDF via B1 interface... will we have access to those UDF in the appropriate forms in B1 interface ?? And how is it possible to do it via SDK ? Is it complicated ? Is there code sample somewhere ?

Thanks,

Luce

[Eneveux]

Luce,

The object needs to have the ability to allow the creation of user defined fields for a system object for you to be able to manage them through code. So you are correct ... it does depend on the object. Most objects do allow for user defined fields, but some do not. You can verify if the object allows for user defined fields using the SDK Help Documentation. If the object in question does allow for the creation of user defined fields then you can also manage these fields via code using the SDK. Please see the "UserFieldsMD Object" documentation in the SDK Help for more information and sample code.

SAP does not allow direct access to the database using SQL such as stored procedures etc. You can use the SDK RecordSet object to manipulate user data on user defined tables and fields as stated in the SDK documentation, not on system objects.

Hope that helps,

Eddy