cancel
Showing results for 
Search instead for 
Did you mean: 

User Table Key set up in User defined field management

Former Member
0 Kudos

Dear Expert,

what is use of User Table Key set up in User defined field management in SAP B1.

Thanks.

Sridharan.R

Edited by: Sridharan.R on Oct 4, 2011 8:26 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Sridharan,

The key is for the index of the table. There is default primary key Code for every UDT. You can add you own key by this selection to improve the table performance.

Thanks,

Gordon

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Once a UDF is created and a value is entered in it, the same cannot be retrieved in any of the layouts and reports unless a Key is generated for that UDF. By assigning a Key to that UDF, the same UDF can be used in Crystal Reports or any other Reporting tool to extract its values from SAP. These reporting tools searches the Uniqueness of the UDF Values with this Keys only.

For eg.: When you develop a report and select a table from which you need the fields to be shown in the layout. In that, the only fields whose keys are generated are only available to use in the report.

Hope its clear to you.

Regards,

Papil