select one

[Former Member]

hii,

one personnel number has 2-3 joining date in table.

i want to select the first joining date.

[Former Member]

retrieve the joining dates in internal table, sort then use read table with index 1

[Former Member]

Hi,

Do you want to take the earliest data?

If so do like:

select * from the tabe to an internal table where conditions.

sort itab by datefield.

read table itab into wa index 1.

Hope this helps.

Regards,

Renjith Michael.

[GauthamV]

hi,

after getting all the records into your internal table.

sort your internal table ascending.

then use this statement.

DELETE ADJACENT DUPLICATES FROM it_pa0001 COMPARING pernr.

[rainer_hbenthal]

To be HR compliant, use macro rp_provide_from_first

[JozsefSzikszai]

SELECT min( date )
FROM...
INTO...
WHERE employee = employee_number.

date is the name of the field in the table for the joining date

employee is the name of the field in the table for the employee

[Former Member]

Hi,

You Can first take all dates in an internal and take the first by setting index

or you can use it by usin min statement in your select query.

Thanks & Regards

[Former Member]

MIN( date ).

is not working with for all entries.

[JozsefSzikszai]

so you want to select the earlies joining dates for several employee at the same time? if yes, than you have to select all employee numners and dates into an internal table and:

SORT itab.

LOOP AT itab.

AT NEW date.

==> this will be the earliest date for the employee.

ENDAT.

ENDLOOP.

[rainer_hbenthal]

Might be correct... but this is not the way of doing such things in HR.

[JozsefSzikszai]

you are right... but in the original question it is never mentioned that it is about HR, it could be any Z... table

[ThomasZloch]

The original question and subject line is so vague, I wouldn't bother at all. I mean, everybody is guessing around just because the OP cannot or does not want to phrase a proper and detailed question.

Cheers

Thomas

[rainer_hbenthal]

Yupp, i'm always taking my way of doing things, and if the data is stored elswehere, i would never store them a seconf time...

Maybe the OP kann specify a little bit more e.g. if he's using LDB and taking hiring/firing from infotype zero. And: there are function modules to get the hire/fire dates out from there...

By the way... i need to take something out of my car, how can i do this?

[Former Member]

thanks Eric..