Qualification Language - Get Only the User with Qualification Language

[former_member445510]

Hello,

Can someone help me to get only the users within the Qualification language?

This is my started select:

SELECT DISTINCT p2~pernr,p2~vorna,p2~nachn,p2~zzp_rrn,p2~gesch,p1~persk,p1~persg,p2~sprsl
FROM pa0002 AS p2
INNER JOIN pa0001 AS p1 ON p2~pernr EQ p1~pernr
INNER JOIN hrp1001 AS h1 ON p2~pernr EQ h1~sobid
INNER JOIN hrp1000 AS h0 ON h0~otype EQ h1~otype AND h0~objid EQ h1~objid
INTO CORRESPONDING FIELDS OF TABLE @lt_com_skil_tmp
WHERE h1~otype EQ 'Q'
AND rsign EQ 'B'
AND relat EQ '032'
AND sclas EQ 'P'
AND langu EQ @sy-langu
AND h0~plvar EQ '01'
AND h1~begda LE @sy-datum
AND h1~endda GE @sy-datum
AND (where).

[former_member445510 · Accepted solution]

I've found it!

It's a select within the following tables:

hrp1001
pa0002
pa0001
hrp1000
hrpad31
t77tp