Error during creation of external views

[manjunath_b]

Hello,

I am trying to create an analytic view modelled like below:

When I do a data preview of the same from the Modeler perspective, it works fine and I can see the data. But I switch to ABAP perspective and consume this Analytic view as an External view and try a data preview, I get an error like below:

Can someone help out as to what could be wrong here.

Thanks and regards,

Manjunath

[jasmin_gruschke]

Hi Manjunath,
I think this might be related to the ADT installation you are using. You might ask for more information on how to solve the issue with the ADT colleagues in the community: .

Additionally, can you try to create a small report, something like:

data lt_res type standard table of zext_an_view.

select * from zext_an_view into table lt_res.

cl_demo_output=>display_data( lt_res ).

If that works, everything is fine with the external view and the issue is rather related to your IDE.

BTW, are you running a recent version of ADT (see SAP Development Tools for Eclipse for an Eclipse installation + ADT plugins).

Cheers,
  Jasmin

[manjunath_b]

Hello Jasmin,

I tried the above report program on my system and the execution results in a dump with

Category               Resource Shortage

Runtime Errors         SYSTEM_NO_ROLL

both using ABAP on eclipse and using txn se80 in SAPGui.

Any thoughts on what could be the issue.

Thanks and regards,

Manjunath

[jasmin_gruschke]

Hi Manjunath,
seems to be a great amount of data... . SYSTEM_NO_ROLL tells you that you're out of memory on your application server.

You can restrict the result set by using SELECT ... UP TO 100 ROWS. Not a solution for an application but it's just a test.

Cheers,
  Jasmin

[manjunath_b]

Thanks a lot. The result is displayed for 100 rows now. So it looks like the external view works fine and it indeed is an issue with IDE.

Will dig a little deeper into the cause now.

Cheers,

Manjunath