topic Re: Difference between tables and infotypes in Application Development and Automation Discussions

Difference between tables and infotypes

Former Member — Mon, 16 Apr 2007 05:23:34 GMT

Hi friends,

can u explain .. Differnece between the infotypes and dbase tables???

why infotypes are in HRabap programming??

thnaks and regards,

vijay.

Re: Difference between tables and infotypes

Former Member — Mon, 16 Apr 2007 05:26:39 GMT

Hi,

Infotype(s) are used in the Personnel Management (PA) module primarily. This is where personnel master data is stored. Data is grouped according to subject matter. The Human Resources component aims to enable the user to process employee data in an effective structure in accordance with business requirements. The data structure of infotypes mirrors a logical set of data records. Infotypes can be identified by their four-digit keys, for example, the Addresses infotype (0006). To facilitate reporting on past employee data, infotypes can be saved for specific periods.

Some people use the term HR ABAP to describe the method of managing the infotype data. Typically HR logical databases are used which offers more secure methods of accessing the infotype data. Once the infotypes are declared, you can use standard macros to access the data. Table TRMAC holds the macro name and the code behind it. This makes developing HR programs much quicker and easy to turn around.

rgd,

bharat.

Re: Difference between tables and infotypes

Former Member — Mon, 16 Apr 2007 05:46:57 GMT

Hi,

Tables means contaning rows&coloumns i.e 2D matrix.Infotype means Information container and which is bounded my time constraint.

The main diff is to retrive th data very fast becoz infotypes contain subtypes are there.Suppose 0006 is there in that temporary(01),permenant(02) means we can find directly.

eg: 0006 02.

HR data is very sensitive& based on dates only.Thats why we are using the infotypes and LDB's.

That is the diff b/w infotype and table

THanks

P.SRIKANTH

Re: Difference between tables and infotypes

Former Member — Mon, 16 Apr 2007 05:58:53 GMT

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.

Re: Difference between tables and infotypes

Former Member — Mon, 16 Apr 2007 06:06:37 GMT

Hi Amit,

Thanks for ur valuble Information regarding Infotypes and Dbase Tables.

THANKS AND REGARDS,

Vijay.

Re: Difference between tables and infotypes

Former Member — Mon, 16 Apr 2007 06:11:09 GMT

Hi Amit,

can u clarify one more doubt..

why we are using LDBS AND MACROS IN HR ABAP???

THANKS AND REGARDS,

Vijay.

Re: Difference between tables and infotypes

Former Member — Mon, 16 Apr 2007 06:20:09 GMT

Hi again,

1. why we are using LDBS AND MACROS IN HR ABAP???

In HR many different tables and various kind

of logics are used, to fetch simple/complicated data.

So instead of writing the same logic/code again & again,

SAP has provided LDB and macros concept.

2. If we use these things, then the coding becomes very very small.

3. Thats the only reason. We can do hr program,

even without ldb and macros. No problem in that.

regards,

amit m.