topic Re: table in Application Development and Automation Discussions

table

Former Member — Sat, 05 May 2007 15:18:44 GMT

what r the advantages of creating table?culd u plzzz tell me

Re: table

h_senden2 — Sat, 05 May 2007 15:30:23 GMT

if you want data to store permanently you have to do it in a DB table.

If you only want to have them temporarily, you can use a internal table in the abap program.

regards,

Hans

please give reward points for useful answers

Re: table

Former Member — Sat, 05 May 2007 16:21:30 GMT

Hi,

The advantages of creating a table depends on what kind of requirment you have. If the requirement is to store the data for history purpose or store the data for anlsysis purpose or you want to store the data to be used in further processing then you go for creating tables in the system.

Simple example is if a company wants to know how many sales they have done for a month , they can find the details by querying the data stored in the table. So for such reasons we need to store the data in the table.

Cheers

Re: table

Former Member — Mon, 07 May 2007 10:04:59 GMT

Hi,

Main advantage is to store the data permanently for your future reference.

Reward points if it is helpful.,

Regards,

Sangeetha.A

Re: table

hymavathi_oruganti — Mon, 07 May 2007 10:10:33 GMT

table means u mean internal table or database table?

advantage of creating database table is in its name itself. it stores a permanant database.

coming to internal table, it will be like a snapshot of database table.

for our manipulation always intervening the database table is not a good practise so for our manipulation we use internal table and the final data if needed will be finally updated in database table only.

Re: table

Former Member — Mon, 07 May 2007 10:15:59 GMT

hi,

Advantages of creating Database Table :

1 we can store our data permanently.

2 Duplicates are avoided

3 Is to Maintain the data

Advantages of creating Internal Table :

1 we can manipulate the database table temporarily

2 we can retrieve data from database table

Re: table

Former Member — Mon, 07 May 2007 10:17:21 GMT

A data base table can store related data permenenlty.

it helps to retrieve a large amount of related data by giving few conditions.

An internal table is a portion of ABAP memory where the data fetched from the database table is stored temporarily for:

1. faster acces to the data &

2. processing of the data

using the processed data we can either modify the database table data or add rows into the database table.

Re: table

Former Member — Mon, 07 May 2007 12:14:49 GMT

hi,

creating a table will increase the performence.like if we create an internal table It acts as a temperory storage area where in we can do update,delete,insert operations without affecting the master database which holds the data permanently.

reward with points if helpful.