Skip to Content

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

program optimization

hello all,

I need your expert opinion, can you please suggest on how can i optimize this code?

SELECT ekkoebeln eketeindt ekkolifnr ekkoreswk ekpo~werks

ekkobsart ekkoekgrp ekpoebelp ekpomatnr eket~menge

eketwamng ekpomeins ekpoelikz ekpoeglkz ekko~unsez

ekkoihrez ekporetpo ekkobedat ekpoevers eket~wemng

ekpoloekz ekkoabsgr ekpo~bukrs

FROM ekko

JOIN ekpo

ON ekpoebeln EQ ekkoebeln

JOIN eket

ON eketebeln EQ ekpoebeln

AND eketebelp EQ ekpoebelp

JOIN mara

ON maramatnr EQ ekpomatnr

INTO CORRESPONDING FIELDS OF TABLE i_tab

WHERE ekko~bsart IN s_bsart

AND ekko~bedat IN s_bedat

AND ekko~ebeln IN s_ebeln

AND ekko~ekgrp IN s_ekgrp

AND ekko~lifnr IN s_lifnr

AND ekko~reswk IN s_reswk

AND ekko~absgr IN s_absgr

AND ekpo~werks IN s_werks

AND ekpo~evers IN s_evers

AND ekpo~matnr IN s_matnr

  • AND ekpo~loekz EQ space

AND eket~eindt IN s_eindt

AND mara~mtart IN s_mtart.

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