Difference between Infotype and Transparent Table

[Former Member]

Hi,

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

Best Regards

Renjan

[anversha_s]

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

<b>Transparent Table</b>

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

psl refer the below link .

<b>

hope u got an idea.

pls mark points if hlped.

rgds

anver

Message was edited by: Anversha s

[Former Member]

Hai renjan,

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.