topic Re: Any function module to read all the values in Tcode-PPQD? in Application Development and Automation Discussions

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

Former Member — Tue, 28 Mar 2006 21:12:30 GMT

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.

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

ferry_lianto — Tue, 28 Mar 2006 21:16:14 GMT

Hi Murali,

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

Hope this will help.

Regards,

Ferry Lianto

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

Former Member — Tue, 28 Mar 2006 21:32:01 GMT

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.

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

suresh_datti — Tue, 28 Mar 2006 21:44:44 GMT

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

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

Former Member — Tue, 28 Mar 2006 21:51:31 GMT

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.

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

suresh_datti — Tue, 28 Mar 2006 21:55:47 GMT

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

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

suresh_datti — Tue, 28 Mar 2006 22:00:47 GMT

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

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

Former Member — Tue, 28 Mar 2006 22:09:45 GMT

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.

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

Former Member — Tue, 28 Mar 2006 22:19:41 GMT

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

Rob

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

suresh_datti — Tue, 28 Mar 2006 22:59:11 GMT

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

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

Former Member — Fri, 28 Jun 2013 05:13:38 GMT

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.