Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Using UUID istead of commoen fields

Former Member
0 Kudos

HI All

I Have two Z DB tables with almost the same fields and my question is if in table one table

instead the common fields I can use UUID .

1. what is the benefit of this

2. how i can read data from table one

This are the tables

Table one

mandt type sy-mandt "key
User type bname    "key 
hardware  type char30"key
application type char 30 "key
cdate 
ctime

Table 2

mandt type sy-mandt "key
User type bname    "key 
hardware  type char30"key
application type char30 "key
application_att type char30"key
application_ver type char30"key
application_value type char50 
cdate 
ctime

Best Regards

chris

1 ACCEPTED SOLUTION

Sandra_Rossi
Active Contributor
0 Kudos

UUID are to be used when some data is shared by multiple applications, and these applications have different keys to access this data (I'm not sure to be clear ).

The problem with UUIDs is that it makes the database a little bit abstract, and it's not easy to read via general tools like SE16, SM30.

I don't know how complex is your application, but I don't advise you to do so.

2 REPLIES 2

Sandra_Rossi
Active Contributor
0 Kudos

UUID are to be used when some data is shared by multiple applications, and these applications have different keys to access this data (I'm not sure to be clear ).

The problem with UUIDs is that it makes the database a little bit abstract, and it's not easy to read via general tools like SE16, SM30.

I don't know how complex is your application, but I don't advise you to do so.

0 Kudos

HI Sandra

Thanks!

Chris