difference between infotypes and dbase tables

[Former Member]

Hi All,

any one explain difference between infotypes and dbase tables.

rgds,

[suresh_datti]

Infotype is to maintian/display HR data.. every Infotype is in fact tied to an underlying database table.. the PA infotypes have the PAnnnn tables & PD infotypes have HRPnnnn tables..

~Suresh

[Former Member]

Each infotype has a database table and a structure associated with it. As HR is related to time , we require old data as well as new data. The data we enter into the infotypes are automatically checked for accuracy and against the table entries.

In simple, HR data is huge and to access data easily we require infotype. It is easy to group huge data using Infotypes.

[Former Member]

Hi vijay,

An Infotype is just another way to handle/store data.

HR Data is huge and time dependent . The history of

the employee is maintained .

To enable logical storage of data and to facilitate easy

and faster data entry /retrieval , concept of Infotype

Came into existence .

1. Why SAP introduced Infotypes

Bcos : to divide lot of master data related to

an employee into groups called as INFOTYPE

dividing in such group makes it logically

distributed so that authorisation rights

can be distributed accordingly. (which practically

happens in most companies where HR is not centralised)

2.why SAP HR module using infotypes mostly

BCos : All its data (master data related to emplyee)

is found in infotypes only. (all kind of master data

is put in some or other infotype )

3 Any drawbacks using transparent tables

SAP suggests that to read infotype information,

use their STANDARD function modules only.

BCOS :

a. it will be fast

b. those FMs will automatically check authorisations

c. any change in these FM's by SAP, will automatically

effect Z Programs (if perfomance, data etc is improved)

4. Ht diff. bw Infotypes n transparent tables

Infotype is the FUNCTIONAL WORD

Table is the TECHNICAL WORD

Infotype means logical set of information.

Table means actual physical database table.

Each infotype has a corresponding transparent table.

regards,

amit m.

[ferry_lianto]

Hi Vijay,

Info Types:

Definition

Allow you to enter and store object characteristics that are thematically linked.

Use

You use infotypes to define additional object attributes or characteristics. You edit infotypes in Detail Maintenance. You can create, change, display, delete and delimit infotypes.

Each infotype enables you to define particular characteristics for an object. In the Relationships infotype, you can, for example, define how two objects are related to one another. In the Work Schedule infotype, you can define working time for a position, organizational unit or a work center.

Some infotypes are only relevant for certain object types. The Vacancy infotype is, for example, only relevant for positions and the Character infotype only for tasks. Some infotypes can be edited for all object types, the Object and Relationships infotypes, for example.

Structure

Each time you create an infotype for an object, you create an infotype record. Once you have created infotype records, you can change, display, list, copy, delimit or delete them.

You can create any number of infotypes for an object. You can also create several infotype records for the same infotype for an object. An object can, for example, have several relationship infotype records that define the object’s links with other objects in the organizational structure.

The data in an information type can be divided into various other information categories. These categories are called subtypes. In the Health Examinations infotype, for example, you can define two categories or subtypes of health information for a work center.

Database Tables:

There are 3 types of database tables in SAP.

1. Transparent Table:

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

2. Pooled Table:

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.

3. Cluster Table:

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.

Regards,

Ferry Lianto