WBS Element - Conversion of CONVERSION_EXIT_ABPSP_OUTPUT function

[Former Member]

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.

[Former Member]

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

Rob

[Former Member]

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.

[Former Member]

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

Rob

[Former Member]

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

[Former Member]

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"

[Former Member]

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

[RaymondGiuseppi]

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

Regards,

Raymond

[Former Member]

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