Historical Records problem.

[Former Member]

Hi all,

I want pick the data from various infotype.in same employee number in different infotype different recorda(historical).how can pich the data.

employee number :5562031 in this emp

ex:

This is pa0000 table ,from here same employee number have 4 records.

This is pa0007 infotype, from here same employee number have 5 records.

This is pa0008 infotype, from here same employee number have 5 records.

This is pa0014 infotype, from here same employee number have 5 records.

this is example.same employee number different records .how to write code.

Regards,

KK.

[Former Member]

based on the BEGDA,ENDDA u have to select.

Regards

Prabhu

[Former Member]

Hi Prabhu,

begda and endda based on i writen code .but final it featch only one record .

i wann to all (how many records r there).

regards,

kk.

[amit_khare]

SELECT * FROM PA0001 inti table t_pa0001 where PERNR = EMP_NUM.

This will fetch all record for that employee.