Skip to Content

How to connect LUMIRA to SAP ECC and use selection parameters

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 21, 2016 at 09:10 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2016 at 07:06 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.