Hi,
I'm having the following code. its performance is very high. Is it possible to reduce the processing time?
SELECT objnr gjahr kstar beknz twaer
wtg001 wtg002 wtg003 wtg004 wtg005 wtg006
wtg007 wtg008 wtg009 wtg010 wtg011 wtg012
wkg001 wkg002 wkg003 wkg004 wkg005 wkg006
wkg007 wkg008 wkg009 wkg010 wkg011 wkg012
wog001 wog002 wog003 wog004 wog005 wog006
wog007 wog008 wog009 wog010 wog011 wog012
FROM cosp APPENDING TABLE i_cosp_t PACKAGE SIZE 2000
FOR ALL ENTRIES IN p_i_vbakp
WHERE lednr EQ c_lednr_0 AND
versn EQ c_versn_0 AND
gjahr EQ p_gjahr AND
wrttp EQ c_wrttp AND
kstar IN p_r_kstar_cosp.
ENDSELECT.
READ TABLE COSS AND APPEND TO P_I_COSP FILLED ABOVE
SELECT objnr gjahr kstar uspob beknz twaer
wtg001 wtg002 wtg003 wtg004 wtg005 wtg006
wtg007 wtg008 wtg009 wtg010 wtg011 wtg012
wkg001 wkg002 wkg003 wkg004 wkg005 wkg006
wkg007 wkg008 wkg009 wkg010 wkg011 wkg012
wog001 wog002 wog003 wog004 wog005 wog006
wog007 wog008 wog009 wog010 wog011 wog012
FROM coss APPENDING TABLE i_coss_t PACKAGE SIZE 2000
FOR ALL ENTRIES IN p_i_vbakp
WHERE lednr EQ c_lednr_0 AND
versn EQ c_versn_0 AND
gjahr EQ p_gjahr AND
wrttp EQ c_wrttp AND
kstar IN p_r_kstar_coss.
ENDSELECT.
Thanks & Regards,
Vallamuthu.M