Skip to Content
Aug 24, 2016 at 11:52 PM

Select distinct issue


Hi gurus.

Forgive me for such silly question but I don't have too much experience in ABAP.

I search for an answer for this question but being honest, I have no idea of an effective way to search for this.

Well, the problem is:

I build a dynamic SQL statement like this.

So, I'm facing a problem, when I execute the same statemant using SE11 I got more records than when I execute this sentence in the program, so, I record a trace for this statemant in ST05 and for my surprise I got this.

So, I ask you guys, where that DISCTINC came from? Because it is not in the lv_fields variable.

I could solve this problem by selecting the PK fields for this table but, I don't need those fields.

I very appreciate any help.




img_select.png (3.6 kB)
trace_result.png (12.5 kB)