topic Re: Regarding select query Issue in Application Development and Automation Discussions

Regarding select query Issue

Former Member — Mon, 16 Nov 2009 13:01:23 GMT

Hi ABAPERS,

I had written one written one 'select single' query to retrieve the data from PRPS table.

but what the data was selecting for OBJNR (Object number)field based on PSPNR(WBS element) .

That OBJNR values in the report is totally different from the database table OBJNR values.How its possible

I am not getting.So can anyone please help me regarding this...

Thanks and Regards

Deepa

RaymondGiuseppi — Mon, 16 Nov 2009 13:05:55 GMT

There is a conversion exit on field PSPNR (domain PS_POSNR CnvExt ABPSP 8n > 24a ) , and none on OBJNR (22a)

- OPJNR > 'PR' + internal value of PSPNR

- PSPNR > external value of PSPNR

Regards,

Raymond

Former Member — Mon, 16 Nov 2009 14:51:39 GMT

Hi Raymond,

Can you please explain what is extternal value..

If possible please give one example of that..

Thanks in Advance...

Deepa

vinod_vemuru2 — Mon, 16 Nov 2009 15:05:45 GMT

Hi deepa,

Pass the values to the select query where clause as you can see the values in SE16 display.(This is external format)

If a table field as conversion routine, then SAP dosplay some thing on screen and store some thing else in data base.

To check conversion exit go to domain of that field. Here you can see the routine used.

For example you can check domain MATNR. Externally it display with leading zeros. But internally it stores with out zeros.

Thanks,

Vinod.

RaymondGiuseppi — Mon, 16 Nov 2009 15:16:25 GMT

Read [conversion routine |http://help.sap.com/abapdocu_70/en/ABENCONVERSION_ROUTINE_GLOSRY.htm]

Regards,

Raymond