topic Re: PROJ-PSPID format in Application Development and Automation Discussions

PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:31:53 GMT

Hello,

In my selection-screen I'm asking for a project definition like this:

parameter pa_proj like proj-pspid obligatory

The problem is that I want to check the values of an excel file against this parameter, but they have different formats.

eg. in Excel file: DBR-05/029

in SE11 for proj-pspid: DBR0502900

How to make the conversion between these 2 formats so I can compare the values?

thanks

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:33:07 GMT

do a search on conversion exits for PSPID in this forum.

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:44:48 GMT

Hello

Try FM CONVERSION_EXIT_PSPID_OUTPUT

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:45:25 GMT

Hello,

Thanks for your answer.

I tried both CONVERSION_EXIT_ABPSP_INPUT and CONVERSION_EXIT_ABPSP_OUTPUT, but none of them did what I want to have...

Anyone other ideas?

Regards

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:48:44 GMT

Hello,

I tried this FM, but it gives a runtime error:

The function module (conversion_exit_pspid_output) is not active or contains no code.

Regards

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:51:49 GMT

The conversion-exts mentioned by you are the right ones. They should ideally do the trick.

In SE11 if you give the input as DBR-05/029 you would get record who's PSPID is DBR0502900.

Please check in debugging if the pspid is being properly converted to the required format and you are displaying the right output.

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:56:11 GMT

I tried this:

data: lv_projectdef like proj-pspid.
CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT'
  EXPORTING
    INPUT         = wa_record-projectdef
 IMPORTING
   OUTPUT        = lv_projectdef.

But it gives a runtime error:

Unable to interpret "DBR-05/029" as a number.

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:57:07 GMT

Hi,

Please use the following two conversion exits before comparing the data

CONVERSION_EXIT_ABPSN_INPUT - to convert to Internal format ( eg 00012435 )

CONVERSION_EXIT_ABPSN_OUTPUT - to convert to output format ( eg 1CNA/EFR )

Hope this helps,

Raj

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:57:50 GMT

Hello


I tried this FM, but it gives a runtime error:
The function module (conversion_exit_pspid_output) is not active or contains no code.

It mean that does not occur conversion when writing in table.

So, you need manually convert data.

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 09:58:39 GMT

how did you define lv_projectdef ?

Is it a char field? My guess is that you defined it as I.

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 10:04:03 GMT

Thanks a lot!

This one worked: CONVERSION_EXIT_ABPSN_INPUT

Regards

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 10:14:59 GMT

Visually theres very little difference between CONVERSION_EXIT_ABPSP_OUTPUT and CONVERSION_EXIT_ABPSN_INPUT, which made me overlook this in your first reply

Anyways you could get this Conversion Exit by double-clicking on the Data Element and under Defnition Tab in Domain you can find the Conversion Routine Value "ABPSN". Double clicking this, would take you to the FM.

Re: PROJ-PSPID format

Former Member — Fri, 05 Dec 2008 10:25:10 GMT

Thanks for the very helpful tip!

I didn't know about that one...

Regards