on 08-21-2016 10:00 AM
Hi Experts,
I've spent couple of hours recently to figure out how to connect SAP LUMIRA (desktop edition) to SAP ECC using infoset with Logical Database behind.
I've tested this scenario:
I have an old fashioned logical database called "DDF" in SAP ECC system to display Account Receivable data. Now I've tested both approaches that means either I've created custom infoset using this logical database or I've used the standard one "/SAPQUERY/FIDD". I've done all necessary preparations such as create user group, assign infoset to user group, assign my user to user group etc. Then I've started Lumira, connected to Infoset and I got error message NO_SELSCREEN. Since I've been struggling to find out how to send the parameters to the query.
As this select doesn't work
select * from "Global"."INFOSET"."ZFI_FIDD"
I need to add the condition. Logical database has theese fields as selection fields:
So I thought maybe this will work
select * from "Global"."INFOSET"."ZFI_FIDD" WHERE DD_STIDA = DATE'2016-01-01' but I get exception uknown column name...
Any ideas?
Thanks for help
Kind Regards
Dalibor
Lumira does not work against SAP Logical Database Infosets - see
If you want to use Lumira against ECC, create a BI universe or consider another work around mentioned in the thread referenced: "To work around this, you can create your own InfoSet using the SQxx transactions against the related transparent tables, then it should work."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Tammy,
sometimes the application logic in SAP logical database is a bit more complex, so I cannot simply creare one or two queries(joins).
Anyway, good to know that I cannot use Logical Databses in Infosets for SAP Lumira. Or I think I can, but I cannot use selection parameters with them. As our customers usually don't have BO/BI, I have to think of a different way how to consume reports from SAP ECC insdie SAP Lumira destkop. I will evaluate OData or Restful WS.
Anyway, thanks a lot for answer.
Dali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.