How to connect LUMIRA to SAP ECC and use selection parameters

[dali_raduch]

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:

• 0    ALCUR
• 3    DD_AUGDT
• 8    DD_BUKRS
• 11    DD_GJAHR
• 15    DD_INDEX
• 17    DD_KUNNR
• 27    DD_STIDA
• 37    EXCDT
• 1    DECCOMMA

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

[TammyPowlas · Accepted solution]

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."

[dali_raduch]

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