HANA Live Query : CostcenterActualCostItemQuery

[Former Member]

Hi,

I want to make a custom query based on the standard query CostCenterActualCostItemQuery which I copied.  Without doing any modifications, I get an error message when I check and save the view : "Exception Occurred : element SPRAS IS no longer available".

This is the cause of the issue : 

Does anyone know how to resolve this ?

Kind Regards,

Els

[Former Member]

Hello,

I had the same issue, in the "join 6"  and resolved it the following way:

• I just clicked on the view "SKA1" and chose "Replace with DataSource"
• Select the view SKA1 from sap.hba.ecc and redo the mapping

Now, the SPRAS is gone and you can reactivate the view and use it. However, when you will close and reopen the view for edititon, the SPRAS will be back and you'll have to redo the same steps before being able to reactivate.

Strange bug...   

[former_member196618]

If that's an attribute or calc view for SKA1 added to Join 6, you should edit it and remove SPRAS there.

SKA1 is a standard table that does not have a SPRAS field...

[Former Member]

Hello Fernando,

Join 6 is a join of another join with SAP.HBA.ECC.SKA1. I tried to modiy SAP.HBA.ECC.SKA1, but this is not possible.

Kind Regards,

Els

[former_member196618]

From that screenshot I would say that's what you need to do.

Can you create a copy of SAP.HBA.ECC.SKA1, remove SPRAS there and then use it on Join 6?

[Former Member]

Hello Fernando,

I will try so. Thanks a lot for your input.

Kind Regards,

Els

[Former Member]

Hi Els,

Have you resolved the issue? I am having the same issue.  I created a copy of SAP.HBA.ECC.SKA1, trying to remove SPRAS, but it is not in the column list.  Can you plase share your solution?

Thanks,

Jenny

[Former Member]

Hi Jenny,

Unfortunately we didn't find a solution. 

Kind Regards,

Els