Infotypes

[Former Member]

Hi All,

Can anyone tell me why do we have three tables maintained for each infotype. i.e for infotype 0000 we have p0000

pa0000

ps0000

for infotype 0001 we have p0001

pa0001

ps0001

What is the need of having in this way?

Thanks in advance.

Swapna

[Former Member]

Thanks All.

Preetham Thanks a lot

Regards,

Swapna.

[Former Member]

Hi,

Each infotype nnnn requires at least two structures and one table:

Structure PSnnnn

Structure PSnnnn contains all of the infotype data fields.

Transparent table PAnnnn and/or transparent table PBnnnn

Transparent table PAnnnn is required if you want to use an infotype within Personnel Administration.

If you want to use an infotype within Recruitment, transparent table PBnnnn is required.

Structure Pnnnn

Structure Pnnnn contains infotype key fields and all of the data fields from structure PSnnnn .

You may refer following link that will give you more insights.

http://help.sap.com/saphelp_46c/helpdata/en/4f/d5256c575e11d189270000e8322f96/content.htm

Thanks & Regards,

DN

[Former Member]

hi,

P0000 ans Ps0000 are structures and not tables with data.

structures are like skeletal tables.

Pa0000 is the table which contains data.

regards

nalla

[Former Member]

Hi,

PXXXX is a structure for the infotype data. This will have same field structure as of the database table. But the data will not be stored in this. This structure is used by ABAP code to query data from the table. With structures it is possible to use fields from more than one table.

PAXXXX is a transparent table for the data for infotypes. As per my knowledge this transparent table fetches data from the infotype tables which have names like for eg. T001P.

PSXXXX is again a structure for table with some fields from different tables. This structure is mainly used for ABAP code to query data.

Experts please correct me.

Reward if helpful,

Thanks,

Preetham.