Application Development and Automation 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: 

Nested select

former_member438956
Active Participant

‎2010 May 21 10:04 AM

0 Kudos
153

Hi All,

I need syntax to select data from a table which will have a nested select query.

mblnr mjahr zeile matnr werks sjahr smbln

4900000276 2010 0001 000000000000000131 1000 0000

4900000277 2010 0001 000000000000000131 1000 0000

4900000278 2010 0001 000000000000000131 1000 2010 4900000277

4900000279 2010 0001 000000000000000131 1000 2010 4900000276

4900000280 2010 0001 000000000000000131 1000 0000

I want if I input material no as input I should get o/p as one row which is 4900000280.

I need to skip those records where sjahr,smbln contains any value and also the value it contains should not be selected as smbln contains 4900000277 and 4900000276 as mblnr.

Regards,

Anil N.

1 REPLY 1

faisal_altaf2
Active Contributor

‎2010 May 21 10:11 AM

0 Kudos
115

Hi, Anil

Please get F1 help of Select and find out the Sub Query Example. It will solve out your problem.

Best Regards,

Faisal