difference between Infotype and Database table

[Former Member]

Hi all,

in SAP ABAP-HR we have the concept of INFOTYPE. will anybpdy please tell me , in simple word, what exactly is it? and what are the difference of INFOTYPE with DATABASE TABLE.

Anirban Bhattacharjee

[rainer_hbenthal]

There is no difference. Infotypes point to databasetable PAxxxx, PBxxxx or HRPxxxx with xxxx = Infotype number.

[GauthamV]

hi,

in hr module there r different submodules like pm,oa,pa,....

so inorder to identify them seperatly infotypes r created.

each infotype will be stored in diff database tables.

ex: infotype 0000 table pa0000

infotype 0001 table pa0001

...........................

pa30 transaction will give u entire employee information.

[Former Member]

hi,

An infotype is a collection of logical and/or business-related characteristics of an object or person. Items such as materials have similar structures that act like infotypes. The one difference is the concept of time constraints that infotypes use for interpreting data during a specified period.

hope this will help.

reward if useful

Sumit Agarwal

[Former Member]

Hai Anirban,

Infotypes:

The information units used to enter the data of an employee are called infotypes.

The infotypes are used to group related data fields together.

These are Database tables but when it comes to ABAP-HR they are termed as Infotypes. Here only the terminology is different.

Regards,

Swapna.

[Former Member]

Hi Anirban,

An Infotype is just a structure. That means that in ABAP HR , if we are creating an infotype means we are creating a structure with fields.

Once we create the structure, then we need to generate that structure. Then, the related module pool programs , tables and selection screens are created for that infotype.

Every infotype is related to a database table.

But generally an infotype is termed as a combination of all the above three things.

Structure - PSNNNN

Table - PANNNN

Module Pool Programs - MPNNNN00

NNNN - Infotype Number.

Hope this helps you.

Any queries, get back to me.

Regards,

Chandra Sekhar

[Former Member]

hi,

infotypes contains group of logically related fields on a single screen (just like TABLE) and which is bounded by TIME CONSTRIANT (no time constrint for table).

main diffarence is TIME CONSTRAINT, means validity period of data records in infotypes based on time constrint only.

for more information on time constrint follow this link.........

http://help.sap.com/saphelp_erp2005/helpdata/en/48/35c9f24abf11d18a0f0000e816ae6e/content.htm

each infotype contains, its corresponding database table.

ex: 0002---> personal information.

its database table: pa0002.

the table pa0002 contains four strctures pakey, pshd1, ps0002 and ci_p0002.

pakey-->contains key fields information.

psdh1--->contains last logon detils (usename....)

ps0002--->contains infotype specific fields.

ci_p0002--> for furthur addinf an any extra fields

Edited by: Ashok Reddy on Jun 25, 2008 2:12 PM

[Former Member]

helpful info.

[Former Member]

Hi

I am getting error "personnel number" yet not assigned when am trying to create an employee with this from hr_infotype_operation.

Do we have any other option other than bdc to create 'pernr'.

Pls help me .

Regards

Meeta