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: 

getting multiple values in join statement!

Former Member

‎12-12-2007 7:02 AM

0 Kudos

Hey friends,

I have written a join statement where I have joined multiple tables because I want to fetch data from different fields. Against Vbeln i am supposed to get the values of other fields!

Is it possible to get multiple records against one VBELN.?

I know i should not use join but for all entries but i am just asking whether i am supposed to get multiple values or not !

1 REPLY 1

Former Member

‎12-12-2007 7:08 AM

0 Kudos

Ofcourse u can get, fetch all values that forms unique records.

If u use for all entries and fetch only vbeln, it will automatically delete the duplicates. so the technique is use vbeln, posnr and other fields that forms unique