topic Re: Historical Records problem. in Application Development and Automation Discussions

Historical Records problem.

Former Member — Wed, 09 May 2007 12:16:26 GMT

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 — Wed, 09 May 2007 12:21:09 GMT

based on the BEGDA,ENDDA u have to select.

Regards

Prabhu

Former Member — Wed, 09 May 2007 12:31:02 GMT

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 — Wed, 09 May 2007 12:36:46 GMT

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

This will fetch all record for that employee.