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