Difference between Info structure and Table

[former_member8655]

Hi Friends

I need to know difference between info structure and table (updating a table using a scheduled program),Which one of this is better and why?

Please help me to get the Pros and Cons of the two available approach.

Thanks

Mitesh

[Former Member]

Hi Mitesh,

<b>Information Structures</b>

In an information system, data aggregation is necessary in order to ensure that the user has a clear overview of key interrelationships. Since the requirements which need to be satisfied by data aggregation are determined by many different user groups, it is absolutely vital that aggregation functionality is flexible. Experience shows that various user groups need to view aggregated data from many different perspectives.

<b>Eg.SD Information Structure</b>

In the SAP standard info structure S012 is updated by the Purchase Order creation date, not the Goods Receipt date. e.g. a Purchase Order is created in January and good receipt is in February and March, S012 will shows the values in period January.

Transaction MC26

Info structure S012 Update group (stats) SAP

Double click on Goods received qty

In the section Date field for period determination

<b>Create an info strcture follow the steps</b>

1. Creation of infostructures - MC21

2. Creation of update rules - MC24

3. Activation (for SD)- OMO1

4. Populating data into info structure - MCSZ

<b>There are 3 types of database tables in SAP.</b>

<b>1. Transparent Table:</b>

Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.

<b>2. Pooled Table:</b>

Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be cominied in a table pool. The data of these pooled tables are then sorted in a common table in the database.

<b>3. Cluster Table:</b>

Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation.

<b>Reward Points if Useful</b>

Regards

Gokul

[Vijay]

hi

An infotype is a 'record' or a 'screen' which holds data against an employee or PD object such as a position, org.unit etc.

A table stores values about an infotype and the way it will function.

Main program generates internal tables for infotypes at runtime.

Infotypes have an associated database table and a structure .

plzz refer to this link

http://planetsap.com/hr_hrinfotypes.htm

http://www.planetsap.com/HR_ABAP_Infotypes.htm

http://72.14.203.104/search?q=cache:FfEG_19IAzoJ:www.planetsap.com/hr_abap_main_page.htminfotypeshr++ABAP&hl=en&gl=in&ct=clnk&cd=1

Transparent Table

Is the same data base table., to store data.

psl refer the below link .

regards

vijay

<b>reward points if helpful </b>