How to get active plan version dynamically

[Former Member]

Hi all,

I am making some HR reports in which I am pulling up position long text from hrp1001 by giving condition - where plavr = '01' . Now if the active plan version is not 01, my condition becomes vague.

Please let me know how to determine the active plan version dynamically in my sample code below

SELECT A_{PERNR A}OTYPE B~STEXT INTO CORRESPONDING FIELDS OF TABLE ITAB_EMP_DEATILS3 FROM PA0001 AS A

INNER JOIN HRP1000 AS B ON B_{OTYPE = A}OTYPE AND B_{OBJID = A}PLANS WHERE ( B_{OTYPE = 'S' AND B}PLVAR = '01' AND A_{ENDDA = '99991231' AND B}ENDDA = '99991231') AND A~PERNR IN PNPPERNR.

SORT ITAB_EMP_DEATILS3 BY PERNR.

DELETE ADJACENT DUPLICATES FROM ITAB_EMP_DEATILS3.

[franois_henrotte]

Simply call FM RH_GET_PLVAR

[Former Member]

great man..... solved.