‎2006 Sep 12 6:19 AM
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
‎2006 Sep 12 6:28 AM
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
‎2006 Sep 12 6:28 AM
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
‎2006 Sep 12 6:45 AM
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
‎2006 Sep 12 6:46 AM
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
‎2006 Sep 12 6:49 AM
hi,
use this FM
VPKPS_EXTERN_TO_INTERN_CONVWBS VPKPS_INTERN_TO_EXTERN_CONVWBS
rgrds
anver