Any function module to read all the values in Tcode-PPQD?

[Former Member]

Hi all

Is there any function module to read all the values in Tcode-PPQD (Display Qualifiaction Catalog).

and any idea what tables are involved to get these values like parent and child relationship?

Thanks in advance.

Murali.

[ferry_lianto]

Hi Murali,

Please check this FM <b>RHPE_SHOW_QUALI_CATALOGUE</b>.

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

Hi Ferry,

Thanks for ur answer,but i am looking data in Internal table showing with parent and child relationshsip.

this FM is showing just like tcode.

Thanks for ur time.

Murali.

[suresh_datti]

Hi.

The transaction PPQD internally uses the same function module RHPE_SHOW_QUALI_CATALOGUE .. the tables that these values reside in are HRP1000 & HRP1001. (OTYPE = 'QK' for Qual Catalog & OTYPE = 'Q' for Qualification.

Regards,

Suresh Datti

[Former Member]

Hi Suresh,

Thanks for the answer, yes I just found the tables names what u said, but any way is there any FM to read this data in Parent and Child relationship in internal table?

I need data based on OTYPE = Q and corresponding records with OTYPE = QK like all the existing records.

Thanks

Murali.

[suresh_datti]

Murali,

It is the other way round.. the Qualification catalog (QK)is the parent & the Qualification(Q) is the child & the relationsship is a B30.may be a function module exists but you can get the same with a select on HRP1001.

Regards,

Suresh Datti

[suresh_datti]

Murali,

you can use the following..

data: w_sobid type sobid, "Qualification ID
      w_objid type objid. "Qualification Catalog
select objid  into w_objid
              up to 1 rows
              from HRP1001
             where otype = 'QK'
               and plvar = '01'
               and istat = 1
               and risgn = 'B'
               and relat = '030'
               and endda ge sy-datum
               and begda le sy-datum
               and sclas = 'Q'
               and sobid = w_sobid.
endselect.
if sy-subrc eq 0.
write: / w_objid,w_sobid.
endif.

Regards,

Suresh Datti

[Former Member]

I am giving example .

1. ITSKILLS(parent)

SAP( child for ITSKILLS)

ABAP(child for SAP )

ABAP1(Child for SAP )

if this is the case i need values in internal table

Child parent(N) parent(N-1) ( fields for the ITAB)

-

---

-

---

-

---

ABAP ITSKILLS SAP

ABAP1 ITSKILLS SAP

Do u think is there any FM to dispaly like this?

If not i will develop code.

Thanks for ur time.

Murali.

[Former Member]

Try FM RHPE_QCAT_READ. If not that, look at the other FMs in that group.

Rob

[suresh_datti]

Hi Murali,

I guess your starting point is Infotype 0024 of an employee.. It is still not clear to me,what you mean by parent/child.. do you wnat to report the skills(IT 0024) of the employees? In that case you can use the function module RHPP_R_PROFILE_READ.

Regards,

Suresh Datti

[Former Member]

FYI,

using FM  BAPI_QUALIDIRECTORY_LIST we will get the list of qualifcation with Qualifictaion group.

in the return structure , PUP_objid is the parent for the corresponding 'Q' object.