Skip to Content
avatar image
Former Member

Incorrect value getting fetched

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 02:03 PM

    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...

    Add comment
    10|10000 characters needed characters exceeded