cancel
Showing results for 
Search instead for 
Did you mean: 

Column transformation in Bex

Former Member
0 Kudos

There is a need for pulling data from SAP. This is done using BEX by client. The output is then fed to the application which is developed using Visual Basic 6.0.

We could avoid coding effort if the query framed in BEX suits our upload file specification. The following are the details what we will need to accomplish using BEX:

1) Is there a way use CASE .. END like statements in BEX ?

2) In spite of using NODIM (), the value is displayed with commas. Is there a way to return only numeric values?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Welcome to SDN!

All formating you need you can do in VBA code embedded into workbook in SAPBExOnRefresh subroutine.

Best regards,

Eugene

Answers (0)