getting multiple values in join statement!

[Former Member]

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 !

[Former Member]

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