Skip to Content
0
Former Member
Jun 08, 2009 at 03:52 PM

abap select query problem

420 Views

This report will take delivery document number and delivery date from user and fetches details from delivery table and fetches

corresponding sales order details and billing details and displays sales order details with ALV list.

<< Please only post the relevant portions of your code >>

i just want to know that is this way of fetching the data into internal table okay ?are there any better ways of fetching the data into the internal table ? why is it looping in work area of lips, why not in likp?

(plz dont use field-symbols or oo abap or macros) I WANT TO USE PLAIN AND SIMPLE ABAP STATEMENTS LIKE ABOVE..

By using "vbeln type lips-vbeln" are we refering to the field or data element? plz suggest.

P.S. [my approach was to inner join likp and lips into itab(my internal table).

select data from kna1, vbak,vbap,vbrp into respective internal tables like it_kna1,it_vbak etc.

then using individual loops into the tables, i would use read table to insert data into itab(my final internal table) plz suggest which method wud be more efficient? ]

Edited by: Rob Burbank on Jun 8, 2009 11:54 AM