topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Fri, 18 May 2007 06:50:17 GMT

i am trying to create table .i have entered the field name and i have two check boxes ie

1.key.

2.initial.

I will check 'key' so that i can maintain uniqueness then what is the purpose of initial check box if i kept it blank what will happen.plz explain me.

Thanks in advance.

Re: tables

Former Member — Fri, 18 May 2007 06:52:30 GMT

Hi,

If you check the INITIAL check box, then it will take the INITIAL VALUE for that data type. Lets say it is Charecter data type, and you haave not entered anyh thing in the table field then it will take SPACE in it, and lets say it is a DATE type and you have not entered any thing, then it will take 00000000 in it.

Hope you understand this

Regards

Sudheer

Re: tables

Former Member — Fri, 18 May 2007 06:52:51 GMT

Indicator that NOT NULL is forced for this field

Use

Select this flag if a field to be inserted in the database is to be

filled with initial values. The initial value used depends on the data

type of the field.

Please note that fields in the database for which the this flag is not

set can also be filled with initial values.

When you create a table, all fields of the table can be defined as NOT

NULL and filled with an initial value. The same applies when converting

the table. Only when new fields are added or inserted, are these filled

with initial values. An exception is key fields. These are always filled

automatically with initial values.

Restrictions and notes:

o The initial value cannot be set for fields of data types LCHR, LR

and RAW. If the field length is greater than 32, the initial flag

cannot be set for fields of data type NUMC.

o If a new field is inserted in the table and the initial flag is s

the complete table is scanned on activation and an UPDATE is made

the new field. This can be very time-consuming.

o If the initial flag is set for an included structure, this means

that the attributes from the structure are transferred. That is,

exactly those fields which are marked as initial in the definitio

have this attribute in the table as well.

Re: tables

Former Member — Fri, 18 May 2007 06:52:57 GMT

See this doc for that check box INITIAL

Indicator that NOT NULL is forced for this field

Use

Select this flag if a field to be inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field.

Please note that fields in the database for which the this flag is not set can also be filled with initial values.

When you create a table, all fields of the table can be defined as NOT NULL and filled with an initial value. The same applies when converting the table. Only when new fields are added or inserted, are these filled with initial values. An exception is key fields. These are always filled automatically with initial values.

Restrictions and notes:

The initial value cannot be set for fields of data types LCHR, LRAW, and RAW. If the field length is greater than 32, the initial flag cannot be set for fields of data type NUMC.

If a new field is inserted in the table and the initial flag is set, the complete table is scanned on activation and an UPDATE is made to the new field. This can be very time-consuming.

If the initial flag is set for an included structure, this means that the attributes from the structure are transferred. That is, exactly those fields which are marked as initial in the definition have this attribute in the table as well.

Reward points if useful

Regards

Anji

Re: tables

Former Member — Fri, 18 May 2007 06:53:55 GMT

Hi Manjula,

Initial Check box is the indicator that NOT NULL is forced for this field.

Select this flag if a field to be inserted in the database is to be

filled with initial values. The initial value used depends on the data

type of the field.

Please note that fields in the database for which the this flag is not

set can also be filled with initial values.

When you create a table, all fields of the table can be defined as NOT

NULL and filled with an initial value. The same applies when converting

the table. Only when new fields are added or inserted, are these filled

with initial values. An exception is key fields. These are always filled

automatically with initial values.

Restrictions and notes:

o The initial value cannot be set for fields of data types LCHR, LRAW,

and RAW. If the field length is greater than 32, the initial flag

cannot be set for fields of data type NUMC.

o If a new field is inserted in the table and the initial flag is set,

the complete table is scanned on activation and an UPDATE is made to

the new field. This can be very time-consuming.

o If the initial flag is set for an included structure, this means

that the attributes from the structure are transferred. That is,

exactly those fields which are marked as initial in the definition

have this attribute in the table as well.

Re: tables

Former Member — Fri, 18 May 2007 06:55:23 GMT

Manjula,

SAP Documentation States the Following...

Indicator that NOT NULL is forced for this field

Use

Select this flag if a field to be inserted in the database is to be

filled with initial values. The initial value used depends on the data

type of the field.

Please note that fields in the database for which the this flag is not

set can also be filled with initial values.

When you create a table, all fields of the table can be defined as NOT

NULL and filled with an initial value. The same applies when converting

the table. Only when new fields are added or inserted, are these filled

with initial values. An exception is key fields. These are always filled

automatically with initial values.

Restrictions and notes:

o The initial value cannot be set for fields of data types LCHR, LRAW,

and RAW. If the field length is greater than 32, the initial flag

cannot be set for fields of data type NUMC.

o If a new field is inserted in the table and the initial flag is set,

the complete table is scanned on activation and an UPDATE is made to

the new field. This can be very time-consuming.

o If the initial flag is set for an included structure, this means

that the attributes from the structure are transferred. That is,

exactly those fields which are marked as initial in the definition

have this attribute in the table as well.

Regards

Vijay