topic Re: diff b/n database table and structure in Application Development and Automation Discussions

diff b/n database table and structure

Former Member — Wed, 29 Aug 2007 08:33:24 GMT

can u help me for this

Re: diff b/n database table and structure

former_member386202 — Wed, 29 Aug 2007 08:37:12 GMT

A table is a table that has been created in the database.

A structure is just a list of fields defined under a name. Structures are useful for painting screen fields, and for manipulating data that has a consistent format defined by a discrete number of fields.

There is no content to view in a structure. You can, however, view the definition of a structure in SE11.

Regards,

Prashant

Re: diff b/n database table and structure

Former Member — Wed, 29 Aug 2007 08:42:43 GMT

Hi,

Go through a similar forum:

*Reward with points for helpful answers

Regards,

Amit

Re: diff b/n database table and structure

paruchuri_nagesh — Wed, 29 Aug 2007 08:44:45 GMT

database table have underlieng data but structure doent have underlieng data.

there are no techinical settings for structures but database table it have

structure can be used to modify database tables means u can add fields to existing pedefined database tables

reward if u find use ful

regards

Nagesh.Paruchuri

Re: diff b/n database table and structure

Former Member — Wed, 29 Aug 2007 08:55:21 GMT

Hi,

Table will store data in database but structure will not store data, it looks like a skleton.

Hope the Info will help you.

With Regards,

K K V

Re: diff b/n database table and structure

Former Member — Wed, 29 Aug 2007 09:12:06 GMT

Hi,

U have data in Database table.

Structure cant hold data. It is only list of fields and u can declare internal table lilke structure.

Hope it will helpful to u.....

Re: diff b/n database table and structure

Former Member — Wed, 29 Aug 2007 09:16:00 GMT

A table is a table that has been created in the database.

There is no content to view in a structure. You can, however, view the definition of a structure in SE11.

regards,

srinivas

<b>*reward for useful answers*</b>

Re: diff b/n database table and structure

Former Member — Wed, 29 Aug 2007 10:55:55 GMT

tables contain data

structure is just body

Re: diff b/n database table and structure

Former Member — Wed, 29 Aug 2007 11:27:34 GMT

Hi,

Database, it contains many fields with some mandatory fields. It also contains the data in the table. We can access the data only by using the key fields. only with the mandatory fields we can able to join one or more database table (to get the data).

Structure is just a body for the table which doesn’t have any data in it.

We can create our own database table with SE11. We have many standard database tables like MARA. Customize stable should start with Z or Y. To create a field inside the database we need to create the domain and the data fields which get assign with the particular table field.

With the help of the structure we can create the internal table and then we can feed the data inside the internal table.

Select statement is used to read the data from the database table, read command is used to read the data from the internal table

Reward points if its useful.

Regards,

Vijay