table

[Former Member]

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

[h_senden2]

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

[Former Member]

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

VJ

[Former Member]

Hi,

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

Reward points if it is helpful.,

Regards,

Sangeetha.A

[hymavathi_oruganti]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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.