Skip to Content
0
Former Member
Feb 11, 2011 at 09:21 AM

Need Performance Suggestion on Following SQL

44 Views

Hi Experts,

First of all let me tell you my situation.

I am at a place/system where I dont have access to any client apart from DEV Server.

& DEV server has not even a single record for testing.

More over I am not supported/permitted to create a test program.

Now My task is to find the performance of this SQL, & check if there is anyother better SQL which can replace.

  SELECT bsis~bukrs bsis~belnr bsis~gjahr
         bsis~buzei
  INTO TABLE l_it_fidoc_items
  FROM bkpf INNER JOIN bsis ON
       bkpf~bukrs = bsis~bukrs AND
       bkpf~belnr = bsis~belnr AND
       bkpf~gjahr = bsis~gjahr
  WHERE bkpf~bukrs = l_s_company-bukrs AND
        bkpf~belnr IN s_belnr AND
        bkpf~blart IN (l_s_revn_doctype-plan_allowance,
                       l_s_revn_doctype-time_entry) AND
        bkpf~budat IN s_budat AND
        bkpf~bvorg = space AND
        bkpf~stblg = space AND
        bsis~hkont IN ( SELECT saknr FROM ska1
                        WHERE ktopl = l_s_company-ktopl AND
                              gvtyp = 'X' ) AND   "P&L Acct
        NOT EXISTS
        ( SELECT * FROM bkpf AS bkpf_rev
          WHERE bukrs = bkpf~bukrs AND
                bstat = space AND
                blart IN (l_s_revn_doctype-rev_plan_allowance,
                          l_s_revn_doctype-rev_time_entry) AND
                bktxt = bkpf~awkey ) AND
        EXISTS ( SELECT * FROM aufk
                 WHERE aufnr = bsis~aufnr AND
                       kostv <> bsis~kostl ).

Note: I Neither have access to create nor to edit this program, I am just assigned to give a feed back on this Select Statement.

I even have no data to test this Select.

Experts please need your Valuable Advice/Suggestions.

Thanks & Regards,

Dileep .C