topic Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function in Application Development and Automation Discussions

WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

Former Member — Wed, 20 May 2015 20:16:19 GMT

Hello dear all,

I am trying to format the POSID field using only SQL, to show it then in a specific table that i'm creating.

I searched and found that this function CONVERSION_EXIT_ABPSP_OUTPUT is the responsible to format the field as needed.

Is there any information that I can use to create the same result given by that function, using only SQL?

Thank you for you time.

Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

Former Member — Wed, 20 May 2015 20:48:02 GMT

If the FM works as advertised, why are you looking for a different solution?

Rob

Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

Former Member — Thu, 21 May 2015 07:16:15 GMT

On this case because the table data was transfered to another system ( different from SAP ) to be worked, and i can't use directly the function.

Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

Former Member — Thu, 21 May 2015 12:48:22 GMT

It's pretty hard to see how you would manage this with only SQL.

Rob

Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

Former Member — Thu, 21 May 2015 14:42:21 GMT

What do you mean format POSID? Do you have PSPNR? If so you can do a select on PRPS with PSPNR to get POSID.

Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

RaymondGiuseppi — Thu, 21 May 2015 14:48:24 GMT

So don't transfer PRPS-PSPNR to other system but PRPS-POSID (as a BW extractor for sample) ?

Regards,

Raymond

Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

Former Member — Thu, 21 May 2015 14:49:59 GMT

Exactly, i have it there like you say. But on my case I can give an example:

The POSID in PRPS is "I0133334455". I have to format it so it can be as "I.01.3333.455"

Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

Former Member — Thu, 21 May 2015 15:07:11 GMT

If you have PSPNR just do the select as you will get it formatted correctly.

Edit: Sorry, I didn't understand your response at first. If it isn't formatted correctly in the table then I'm not sure how you will get it formatted.

Message was edited by: Aaron Shover

Re: WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

Former Member — Thu, 21 May 2015 15:33:58 GMT

I think you need to find a way to provide the formatted value of POSID as the result of the conversion exit function. If no other option, consider adding a field to PRPS (thru CI_PRPS customer include) or create a Z table with a key of PSPNR and another column with formatted POSID value.

It would be a lot of work to duplicate the logic of that conversion exit in SQL, as you would have to read the configuration for project masks and duplicate a lot of logic. Let SAP do it for you!

Jim