topic What does different colors in a database table signify? in Application Development and Automation Discussions

What does different colors in a database table signify?

Former Member — Wed, 23 Oct 2013 04:57:12 GMT

Hi Experts?

What does green color signifies in a database table? Blue is for primary keys.

Regards

Mani

Re: What does different colors in a database table signify?

Former Member — Wed, 23 Oct 2013 05:05:29 GMT

Blue indicates primary key, green indicates a check table exists for this key, ie, it is a foreign key.

Yellow color also signifies there is a foreign key relationship. White indicates a normal field.

These are the default color coding set.

http://help.sap.com/saphelp_nw04/Helpdata/EN/9f/dba1ae35c111d1829f0000e829fbfe/content.htm

OFF	or COL_BACKGROUND	0	depends on GUI	background
1	or COL_HEADING	1	gray-blue	headers
2	or COL_NORMAL	2	light gray	list bodies
3	or COL_TOTAL	3	yellow	totals
4	or COL_KEY	4	blue-green	key columns
5	or COL_POSITIVE	5	green	positive threshold value
6	or COL_NEGATIVE	6	red	negative threshold value
7	or COL_GROUP	7	violet	Control levels

Re: What does different colors in a database table signify?

Former Member — Wed, 23 Oct 2013 05:08:16 GMT

Mani,

Blue represents the primary Keys in the table.

White represent the fields having no search help attached to it or check table.

Green represents the feilds with check tables and the search help attached to it.

Regards,

Re: What does different colors in a database table signify?

Former Member — Wed, 23 Oct 2013 05:19:41 GMT

Hi mani,

in data base tables :

Blue color represent : Primary Keys in the table

Green color represents : it has value table and also it can have check tables

Regards

Divakar

Re: What does different colors in a database table signify?

Former Member — Wed, 23 Oct 2013 05:24:10 GMT

Hi Susmitha,

Thank you for the answer. Just wanted to confirm, if we ever want to change the field value (green) through debugging, can we do it by changing the value already there in the restrictions?

Regards

Mani

Re: What does different colors in a database table signify?

Former Member — Wed, 23 Oct 2013 05:39:04 GMT

You can change the green field value during debugging as long as it is consistent with the check table values.

Re: What does different colors in a database table signify?

Former Member — Wed, 23 Oct 2013 05:56:51 GMT

Thanks,

Have a great day.