Using a Database Table as a Select Option (Range Table)

former_member302834 — Wed, 26 May 2021 16:42:19 GMT

Hello.

Scenario:

Database Table A (Parameter_Id; Value)

Database Table B (Parameter_Id; Sign; Option; Low; High)

Table B is used like a select option. It has the value definitions of the parameters from table A. So every Parameter from Table A can have multiple entries in Table B.

I want to select every parameter which Value is NOT IN the value definition of Table B. A simple NOT IN command if table B was a Select Option.

Now the Problem: those 2 Tables are huge. I want to avoid selecting the range-lines from Table B, store them in an internal table and THEN use them as a select option for Table A. This would cause a huge data transfer from the data base which would result in a terrible performance. The underlying system is a HANA System, so if it is possible to do this task in one Select Statement or an CDS-View or an Select from a CDS View (anything that avoids unnecessary data transfer), the performance should'nt be as bad.

But i don't know how to code this with open SQL or CDS.

Does anyone have an idea?

Greetings,

Robert Arnold

topic Using a Database Table as a Select Option (Range Table) in Application Development and Automation Discussions

Using a Database Table as a Select Option (Range Table)