Application Development and Automation 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: 
Read only

What does different colors in a database table signify?

Former Member
0 Likes
6,773

Hi Experts?

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

Regards

Mani

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
3,736

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

6 REPLIES 6
Read only

Former Member
0 Likes
3,737

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

Read only

0 Likes
3,736

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

Read only

0 Likes
3,736

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

Read only

0 Likes
3,736

Thanks,

Have a great day.

Read only

Former Member
0 Likes
3,736

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,

Read only

Former Member
0 Likes
3,736

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