How to fetch PSPNR based on PSPHI

[ajoy_chakraborty]

Hi All,

I want to fetch PSPNR from PRPS table based on PRPS-PSPHI and PRPS-STUFE = 4.

Select query is giving SY-SUBRC EQ 4.

Ex:

SELECT pspnr

FROM prps

INTO TABLE it_prps

WHERE psphi EQ 'NS11.00001' AND

stufe EQ '4'.

Please let me know if we need to use any CONVERSION EXIT.

Thanks in advance.

Edited by: Ajoy Chakraborty on Sep 14, 2010 5:26 PM

[Former Member · Accepted solution]

PSPHI is NUMC, you cannot give CHARACTERS for that field.

You have to use conversion exit for achieving your requirement:

Check with the conversion routine: KONPD

CONVERSION_EXIT_KONPD_INPUT

CONVERSION_EXIT_KONPD_OUTPUT

also check this <link deleted> for more info on conversion exits

You can also check the domain PS_PSPNR in SE16.

Praveen

Edited by: b praveen savan on Sep 14, 2010 6:14 PM

Edited by: Virendra Pal on Sep 15, 2010 8:13 AM

Praveen good answer - please avoid external links - link has now been deleted

[ajoy_chakraborty · Accepted solution]

Thanks a lot Praveen.

SOLUTION:

DATA wbes(24). "User I/P based on few parameters

DATA lv_wbes_4 TYPE ps_psphi.

CLEAR lv_wbes_4.

CALL FUNCTION 'CONVERSION_EXIT_KONPD_INPUT'

EXPORTING

input = wbes

IMPORTING

output = lv_wbes_4

EXCEPTIONS

not_found = 1

OTHERS = 2.

SELECT pspnr

FROM prps

INTO TABLE it_wbes_4

WHERE psphi EQ lv_wbes_4 AND

stufe EQ '4'.

[Former Member · Accepted solution]

Thnx for sharing the solution....

[former_member203108]

Ajoy,

It seems to me that you want to pull level 4 WBS element from PRPS using the project definiton number. Is this what you need?

[Former Member]

Hi,

>psphi EQ 'NS11.00001' 

PSPHI is numeric field and you are putting characters also in it. Kindly check the table once.

Regards,

Harsh.