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

[former_member242633]

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

[former_member242633]

HI Koen,

How to use this function module in Routine.

can you Pls Share some sample code

Regards

vinod patel

[kohesco]

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

[former_member242633]

HI Koen,

I am getting the Error when i use the function.

Error:- Query is unknow

Regards,

vinod patel

ext no-3142

[kohesco]

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

I_QUERY = 'Techn Name'

[former_member242633]

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

[kohesco]

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

[former_member242633]

Hi Koen,

Can u share sample code.

Regards,

vinod patel

[kohesco]

Hi

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

Grtz

Koen

[kohesco]

Hi,

https://blogs.sap.com/2015/09/22/read-query-output-using-abap-to-overcome-apd-constraints/

could help you

Koen