Skip to Content
1
Former Member
Jul 02, 2007 at 01:52 PM

Regarding ECC 6.0

9 Views

Hi Experts,

Program is exeuting syntatically fine, but, when executing its show, time exceed error in ECC 6.0 , initially it is developed in 4.6c. Please, can any one suggest this same code to incorporate in Forall entries.

SELECT abukrs aebeln bebelp aaedat alifnr aernam

bknttp bbednr b~banfn

cbelnr cwrbtr cgjahr cshkzg clfbnr clfgja

dbldat dbudat d~kursf

e~dir_indir

INTO CORRESPONDING FIELDS OF TABLE it_output

FROM ekko AS a

JOIN ekpo AS b ON bebeln = aebeln

JOIN rseg AS c ON cebeln = bebeln

AND cebelp = bebelp

AND cbukrs = abukrs

JOIN rbkp AS d ON dbelnr = cbelnr

AND dgjahr = cgjahr

LEFT JOIN zpo_dirindir AS e ON eknttp = bknttp

WHERE a~bukrs = p_bukrs

AND a~lifnr IN s_vendor

AND a~ebeln IN s_purcdo

AND a~bsart IN s_doctyp

AND a~ekorg IN s_purorg

AND a~aedat IN s_credat

AND b~knttp IN s_knttp

AND b~werks IN s_plant

AND b~bednr IN s_trcnum.