Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

WBS element

Former Member
0 Likes
2,733

hai all,

im trying to download WBS element into an excel sheet, it is downloading without obliques(/). My work area field for WBS element contains values like C54000002000200. But when we see in SE11, it displays like C/54/000002/00/0/2. Anyone plz let me know how to convert the format? Is there any FM available.

Thanks & Regards,

Vinny

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,192

You will have to use the FM <b>CONVERSION_EXIT_ABPSP_INPUT</b>to convert external WBS element(one which is displayed on the screen) to internal WBS Element(as stored in PRPS table)

FUNCTION CONVERSION_EXIT_ABPSP_INPUT.

IMPORTING

VALUE(INPUT) = "External WBS Number"(P.CS.0030.40.01)

EXPORTING

VALUE(OUTPUT) = "Internal WBS Number"(00173294)

EXCEPTIONS NOT_FOUND

While displaying as output you must always display the external WBS.You can use the FM <b>CONVERSION_EXIT_ABPSP_OUTPUT</b> FOR THIS PURPOSE

4 REPLIES 4
Read only

Former Member
0 Likes
1,193

You will have to use the FM <b>CONVERSION_EXIT_ABPSP_INPUT</b>to convert external WBS element(one which is displayed on the screen) to internal WBS Element(as stored in PRPS table)

FUNCTION CONVERSION_EXIT_ABPSP_INPUT.

IMPORTING

VALUE(INPUT) = "External WBS Number"(P.CS.0030.40.01)

EXPORTING

VALUE(OUTPUT) = "Internal WBS Number"(00173294)

EXCEPTIONS NOT_FOUND

While displaying as output you must always display the external WBS.You can use the FM <b>CONVERSION_EXIT_ABPSP_OUTPUT</b> FOR THIS PURPOSE

Read only

Former Member
0 Likes
1,192

hi Ravi,

Thanks a lot, it solved the prob.

Again, in the same report there is an amount field and a quantity field which are need to be downloaded with 1000 separator with 2 decimal places like for eg.10,000.00

I've concatenated the workarea fields for amount and quantity on appropriate places with comman and dot.

As in my report there are 3 different sections with 3 different number of columns, before downloading, im using a z FM to convert the itab into .CSV format. This FM has a single field with 5000 characters onto which every itab is appended, but before appending it is replacing commas with spaces, thereby my quanity and amount fields are not showing commas even though i formated before calling this FM. Now these quantity and amount fields are displaying like 10 000.00

Plz guide how to solve this.

Thanks & Regards,

Vinny

Read only

Former Member
0 Likes
1,192

HI,

find the function module for wbs conversions.

Realted to WBS conversions:

VPKPS_EXTERN_TO_INTERN_CONVWBS: converts external format to internal format.

VPKPS_INTERN_TO_EXTERN_CONVWBS:converts internal format to external format.

regards,

anil

Read only

0 Likes
1,192

hi,

use this FM

VPKPS_EXTERN_TO_INTERN_CONVWBS VPKPS_INTERN_TO_EXTERN_CONVWBS

rgrds

anver