Regd Position Text - HR ABAP

[Former Member]

Hi All...

I have a requirement where i have to pick up position text of the employee from T528T-PLSTX for P0000-MASSN (Action Type) = Joining (BJ) and display in my smartform. Please advice me steps to do the same.

Thanks & Regards,

Preeti

[Former Member]

Hi All...

I have a requirement where i have to pick up position text of the employee from T528T-PLSTX for P0000-MASSN (Action Type) = Joining (BJ) and display in my smartform. Please advice me steps to do the same.

Thanks & Regards,

Preeti

[Former Member]

Hi

Position texts are in T528T table

write a select and take it by passing position field

declare ITAB with fields like PERNR,PLANS, TEXT.

select a_{pernr a}PLANS into table ITAB

from PA0001 as a join pa0000 as b on

a_{pernr = b}pernr

where b~massn = 'BJ'.

tables t528t.

loop at ITAB.

select single plstx into itab-text

where plans = itab-plans.

if sy-subrc = 0.

modify itab index sy-tabix transporting plstx.

endif.

endloop.

Reward points if useful

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Message was edited by:

Anji Reddy Vangala

[Former Member]

Hi Anji,

I have to take action as "joining" also into consideration. Please advice how can i do that.

thanks & regrds,

preti

[Former Member]

Hi

See the select again.

I modified it.

regards

Anji

[amit_khare]

select plansa from pa0001 where pernr = v_pernr.

select plastx from t528t where plans = p0001-plans

and sprsl = sy-langu

and otype = 'S'.

Regards,

Amit

Reward all helpful replies.

[suresh_datti]

get the employee's Position no from Infotype 0001ie p0001-plans & then read its text from the db table T528T.

~Suresh

[Former Member]

Hi,

Position of an employee is available in table PA0001. (PLANS) You can select particular record from that table based on employee number and Action date.

Then the text can be fetched from table HRP1000, One sample query can be

SELECT SINGLE stext FROM hrp1000 INTO l_emp_pos_text

WHERE plvar = '01'

AND otype = 'S'

AND objid = l_emp_pos

and langu = 'E'

and begda LE sy-datum

and endda GE sy-datum.

Regards,

Devendra