Skip to Content
0

Value Cannot be calculateing when using the SUMCT FUNCTION IN BEx QUERY

Dec 11, 2017 at 05:11 AM

74

avatar image
sumct-function.png

HI,

I Have Create a BEx query where i have created formula and use the Sumct function(kindly refer Attached file).

This Bex Query I am using as Query as Info-provider means i am using this query as data sources and loading the Data in DSO.

when i am Try to load the Data in DSO during that i am Geting the Below Error.

Error:- Value Cannot not Be Calculate.

If I am remove the mapping between the transformation and DSO of the particuler filled(where i have used the Sumct Function),then data has loaded successfully Means without that filed the data is loading in DSO.

Kindly refer the Screen shot for more clarification.

Regards

vinod patel

ext no-3142

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Dec 12, 2017 at 09:22 AM
0
Share
10 |10000 characters needed characters left characters exceeded
Vinod Patel Dec 12, 2017 at 11:18 AM
0

HI Koen,

How to use this function module in Routine.

can you Pls Share some sample code

Regards

vinod patel

Show 7 Share
10 |10000 characters needed characters left characters exceeded

Hi,

you can use call function to get the FM's output

call function 'RRW3_GET_QUERY_VIEW_DATA'
exporting
I_QUERY = query "technical name of query"
importing
E_CELL_DATA = it_data."declare a table to get the result
0

HI Koen,

I am getting the Error when i use the function.

Error:- Query is unknow

Regards,

vinod patel

ext no-3142

0

if you assign directly your tech name to the FM, you need to set it as

I_QUERY = 'Techn Name'

0

HI Koen,

Now the Error is not showing but i am not getting the Expected output.

Here I am attaching the Query and DSO OUTPUT.

Regards,

1.BEx Query Output

2.Transformation Between Query And DSO.

3.Routine(Pls check the yellow Color)

4.After Apply the Function output.

vinod patel

ext no-3142

sum-ct-error.png (121.5 kB)
0

Hi,then the only option will be to write an endroutine and calculate it via abap

0

Hi Koen,

Can u share sample code.

Regards,

vinod patel

0

Hi

Can you share some sample data so I can reproduce code on that example.

Grtz

Koen

0