topic Re: Incorrect value getting fetched in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/incorrect-value-getting-fetched/m-p/4423724#M1050591 <HTML><HEAD></HEAD><BODY><P>here you are selecting only pspnr from prps.</P><P>so only you are getting value as 000041.</P><P></P><P>use, </P><P>SELECT objnr pspnr FROM prps INTO TABLE gi_prps WHERE objnr = gw_auak-objnr.</P><P></P><P>objnr will have PR000041...</P><P></P><P>check in SE16 for table PRPS what values are been stored for various fields...</P></BODY></HTML> Thu, 04 Sep 2008 14:03:49 GMT Former Member 2008-09-04T14:03:49Z Incorrect value getting fetched https://community.sap.com/t5/application-development-and-automation-discussions/incorrect-value-getting-fetched/m-p/4423723#M1050590 <HTML><HEAD></HEAD><BODY><P>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</P><P></P><P>check gw_auak-objnr CA 'PR'.</P><P> SELECT pspnr FROM prps INTO TABLE gi_prps WHERE objnr =</P><P>gw_auak-objnr.</P><P></P><P>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</P></BODY></HTML> Thu, 04 Sep 2008 13:59:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/incorrect-value-getting-fetched/m-p/4423723#M1050590 Former Member 2008-09-04T13:59:28Z Re: Incorrect value getting fetched https://community.sap.com/t5/application-development-and-automation-discussions/incorrect-value-getting-fetched/m-p/4423724#M1050591 <HTML><HEAD></HEAD><BODY><P>here you are selecting only pspnr from prps.</P><P>so only you are getting value as 000041.</P><P></P><P>use, </P><P>SELECT objnr pspnr FROM prps INTO TABLE gi_prps WHERE objnr = gw_auak-objnr.</P><P></P><P>objnr will have PR000041...</P><P></P><P>check in SE16 for table PRPS what values are been stored for various fields...</P></BODY></HTML> Thu, 04 Sep 2008 14:03:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/incorrect-value-getting-fetched/m-p/4423724#M1050591 Former Member 2008-09-04T14:03:49Z