Hi every one,
i would like to create a user-defined table in SDK, but i've seen that when you create a UDT into the database the system will create by default two fields "Code" and "Name"; is there a way to create a table without these two fields and to define other fields and use them as keys?
thanks in advance
christian ponzoni replied
it's not possible to create a user defined table without those fields.
a user defined table is a particular table in SAP B1 that can be created not only using the sdk but also from the sap b1 client.
and more, the client can manage it with a auto created form, accessible from a menu item.
as far as i know if you want you can create a table inside sap b1 company database, but it will never be managed automatically by the client, you would have to manage it yourself writing code.
if you need to manage it inside other sap b1 forms i suggest to use a sap standard UDT.
if you need this table to support queries / views / expose data to other systems well the choice is your, create it as you wish ( but sap b1 client will never be able to manage it directly )