Skip to Content
Former Member
May 28, 2009 at 05:30 AM

Need Help in Select Statement


Dear gurus.

Below is my select statement fetching data from table BKPF and comparing it from my internal table.

Problem is that BKPF table contain more then 50,000 entries. which take my program to hang

is there any solution to help my problem.

My Program is a Print program which take two inputs

1) Document No.

2) Facial year.

SELECT belnr bldat xblnr
     FROM bkpf
    INTO TABLE zbkpf
    FOR ALL ENTRIES IN document_tab
    WHERE belnr EQ document_tab-belnr
            AND bukrs EQ 'TPF'
          and  awtyp = 'BKPF'
          AND gjahr = document_tab-gjahr.

Please Help