Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to find more specific entries from database table ?

Former Member

‎12-01-2016 11:00 AM

0 Kudos

Hi,

As show in below screen shot we have custom table where all gray fields are key fields.we need find fully specified entries from table.So in this case last entry should read from table base on keys.

Thanks,

Preview file
61 KB
Preview file
55 KB
Preview file
61 KB
4 REPLIES 4

former_member196331
Active Contributor

‎12-01-2016 11:12 AM

0 Kudos

I hope question is not Clear:

we need find fully specified entries from table.So in this case last entry should read from table base on keys.

Can please Explain what is the meaning of above statement.

Jelena
Active Contributor

‎12-02-2016 10:36 PM

0 Kudos

Same here, can't understand the question. What exactly is a problem?

horst_keller
Product and Topic Expert
Product and Topic Expert

‎12-03-2016 1:20 PM

Read the documentation of the ABAP SELECT statement ...

raghug
Active Contributor

‎12-05-2016 2:39 PM

0 Kudos

Are you asking if there is a way to select the fully qualified key first, followed by a key that is not fully qualified? You will have to write multiple SELECT statements for it... first with the fully qualified key, if nothing is found then without one of the key fields and so on. Sorry, there is no magic, just some elbow grease.