Regarding select query Issue

[Former Member]

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]

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]

Hi Raymond,

Can you please explain what is extternal value..

If possible please give one example of that..

Thanks in Advance...

Deepa

[vinod_vemuru2]

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]

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

Regards,

Raymond