topic Re: select one in Application Development and Automation Discussions

select one

Former Member — Thu, 23 Oct 2008 07:06:44 GMT

hii,

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

i want to select the first joining date.

Re: select one

Former Member — Thu, 23 Oct 2008 07:07:59 GMT

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

Re: select one

Former Member — Thu, 23 Oct 2008 07:10:05 GMT

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.

Re: select one

GauthamV — Thu, 23 Oct 2008 07:10:40 GMT

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.

Re: select one

rainer_hbenthal — Thu, 23 Oct 2008 07:19:40 GMT

To be HR compliant, use macro rp_provide_from_first

Re: select one

JozsefSzikszai — Thu, 23 Oct 2008 07:22:08 GMT

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

Re: select one

Former Member — Thu, 23 Oct 2008 07:24:26 GMT

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

Re: select one

Former Member — Thu, 23 Oct 2008 07:57:33 GMT

MIN( date ).

is not working with for all entries.

Re: select one

JozsefSzikszai — Thu, 23 Oct 2008 08:01:21 GMT

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.

Re: select one

rainer_hbenthal — Thu, 23 Oct 2008 08:03:23 GMT

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

Re: select one

JozsefSzikszai — Thu, 23 Oct 2008 08:16:33 GMT

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

Re: select one

ThomasZloch — Thu, 23 Oct 2008 08:37:21 GMT

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

Re: select one

rainer_hbenthal — Thu, 23 Oct 2008 08:48:17 GMT

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?

Re: select one

Former Member — Thu, 23 Oct 2008 09:07:41 GMT

thanks Eric..