topic difference between Infotype and Database table in Application Development and Automation Discussions

difference between Infotype and Database table

Former Member — Wed, 25 Jun 2008 11:38:51 GMT

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

Re: difference between Infotype and Database table

rainer_hbenthal — Wed, 25 Jun 2008 11:45:16 GMT

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

Re: difference between Infotype and Database table

GauthamV — Wed, 25 Jun 2008 11:48:41 GMT

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.

Re: difference between Infotype and Database table

Former Member — Wed, 25 Jun 2008 11:49:33 GMT

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

Re: difference between Infotype and Database table

Former Member — Wed, 25 Jun 2008 11:49:47 GMT

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.

Re: difference between Infotype and Database table

Former Member — Wed, 25 Jun 2008 11:57:30 GMT

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

Re: difference between Infotype and Database table

Former Member — Wed, 25 Jun 2008 12:09:49 GMT

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

Re: difference between Infotype and Database table

Former Member — Fri, 08 Aug 2008 04:31:47 GMT

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

Re: difference between Infotype and Database table

Former Member — Mon, 06 Apr 2015 10:53:51 GMT

helpful info.