Incorrect value getting fetched

[Former Member]

Hi in my requirement I want to fetch the wbs element based on the prefixed placed in it .I have coded as follows for one part

check gw_auak-objnr CA 'PR'.

SELECT pspnr FROM prps INTO TABLE gi_prps WHERE objnr =

gw_auak-objnr.

Here the value is getting fetched incorrectely in gi_prps table ie)if the value is PR000041 only the value 000041 is coming .I want the prefix PR also how to do.Please help

[Former Member]

here you are selecting only pspnr from prps.

so only you are getting value as 000041.

use,

SELECT objnr pspnr FROM prps INTO TABLE gi_prps WHERE objnr = gw_auak-objnr.

objnr will have PR000041...

check in SE16 for table PRPS what values are been stored for various fields...

[Former Member]

here you are selecting only pspnr from prps.

so only you are getting value as 000041.

use,

SELECT objnr pspnr FROM prps INTO TABLE gi_prps WHERE objnr = gw_auak-objnr.

objnr will have PR000041...

check in SE16 for table PRPS what values are been stored for various fields...