Skip to Content
0
Former Member
Aug 02, 2013 at 08:59 PM

Abap Query

36 Views

Hello, i have a question about abap. i am doing a look up to another dso from this one dso. the dso i am looking up to has about 10 fields that i want in my dso as well. so this is what i wrote in my start routine but the system won't let me do SELECT SINGLE *. It works for SELECT * but i don't want to do SELECT * as it takes too long. can some one tell me how to do SELECT SINGLE * so it will take less time loading please?
Thanks.


DATA: it_1 TYPE STANDARD TABLE OF /BIC/AZD_vb00 INITIAL SIZE 0.
DATA: wa_1 TYPE /BIC/AZD_vb00.


SELECT * INTO TABLE it_1 FROM /BIC/AZD_vb00

FOR ALL ENTRIES IN SOURCE_PACKAGE

WHERE DOC_NUMBER = SOURCE_PACKAGE-DOC_NUMBER AND

S_ORD_ITEM = SOURCE_PACKAGE-S_ORD_ITEM.

then at the field level i am doing a read statements.

Thanks