Diff between Infotype and Transparent Table

[Former Member]

Hi,

Can anyone tell me the difference between the infotype and the transparent table?

[Former Member]

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 .

[Former Member]

same thread.

[Former Member]

HI,

A transparent table is created automatically on the database when it is activated in the ABAP Dictionary. At this time, the database-independent description of the table in the ABAP Dictionary is translated into the language of the database system used.The database table has the same name as the table in the ABAP Dictionary. The fields also have the same names in both the database and the ABAP Dictionary. The data types in the ABAP Dictionary are converted to the corresponding data types of the database system.

The order of the fields in the ABAP Dictionary can differ from that of the fields on the database. This permits you to insert new fields without having to convert the table. When you add a new field, adjust the order of the fields by changing the database catalog (ALTER TABLE). The new field is added to the database table.

ABAP programs can access a transparent table in two ways. One way is to access the data contained in the table with OPEN SQL (or EXEC SQL). With the other method, the table defines a structured type that is accessed when variables (or more complex types) are defined.

You can also create structured types in the ABAP Dictionary for which there are no corresponding objects in the database. These types are called structures. Structures can also be used to define the types of variables.

Regards,

balaji

[Former Member]

Hi

Raju

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.

-charitha