Hello,
in my reports FI accounts are displayed like this: OPCA/1250000000 but I would like to see only account number 1250000000.
Do anybody know how to change this?
Hello,
I would like to use Microsoft Power BI tool to build reports on HANA CDS views. When connecting to HANA database from Power BI I can see some predefine content. I would like to add to this content new folder and new custom CDS views. Any adv...
Hello,
I am trying to access directly (from database, Excel or Power BI) predefine CDS views. Most of them are with annotation @ClientHandling.algorithm: #SESSION_VARIABLE.
In this case I get always empty table as I am not able to specify sessi...
Hello,
I am trying to use USING CLIENT addition for specifing client for view but it return me this error. Please could you help me?
select * from SAPABAP1.IMATERIALSTOCK using client '200'
Error:
Could not execute 'select * from SAPABAP1.IMA...
florian.pfeffer I am using connection from Power BI application but the same problem I have when trying to connected to view from our SQL server.Example for Power BI:Here are I am calling predefine CDS view for storage location list. This view has a...
Unfortunately "where" is not working in case @ClientHandling.algorithm: #SESSION_VARIABLEPoint is that I would like to use existing CDS views prepared by SAP, but it expect client to be specified in session variable, what I don't know how to do it ca...
Hello,
I am trying to use USING CLIENT addition but it is not working. Please do you see the problem?
Could not execute 'select * from SAPABAP1.IMATERIALSTOCK using client '200''
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "usin...