Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance tuning: Retrieving data from 4 tables

Hi All,

Please find below a select stmt and recommend a better one.

select abelnr abldat abudat amonat ausnam abktxt awaers bracct bwsl bdrcrk bbuzei ctxt50 d~altkt

into table gt_all

from bkpf as a inner join faglflexa as b on abelnr = bdocnr

inner join skat as c on bracct = csaknr

inner join skb1 as d on csaknr = dsaknr

where a~bukrs = p_bukrs and

a~gjahr = p_gjahr and

a~blart = p_blart and

a~budat in s_budat and

a~monat in s_monat and

b~ryear = p_gjahr and

b~rbukrs = p_bukrs and

b~rldnr = '0L' and

b~rvers = '001'.

Reward points awaiting.....

Regards,

Younus

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question