topic Re: Regarding ECC 6.0 in Application Development and Automation Discussions

Regarding ECC 6.0

Former Member — Mon, 02 Jul 2007 13:52:45 GMT

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 a_{bukrs a}ebeln b_{ebelp a}aedat a_{lifnr a}ernam

b_{knttp b}bednr b~banfn

c_{belnr c}wrbtr c_{gjahr c}shkzg c_{lfbnr c}lfgja

d_{bldat d}budat d~kursf

e~dir_indir

INTO CORRESPONDING FIELDS OF TABLE it_output

FROM ekko AS a

JOIN ekpo AS b ON b_{ebeln = a}ebeln

JOIN rseg AS c ON c_{ebeln = b}ebeln

AND c_{ebelp = b}ebelp

AND c_{bukrs = a}bukrs

JOIN rbkp AS d ON d_{belnr = c}belnr

AND d_{gjahr = c}gjahr

LEFT JOIN zpo_dirindir AS e ON e_{knttp = b}knttp

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.

Re: Regarding ECC 6.0

Former Member — Mon, 02 Jul 2007 14:01:48 GMT

well even in SAP documentation it says that joins over more than 3 tables are tending to be NOT performant.

so why dop you wonder that a JOIN like that with 5 tables runs into a timeout.

Re: Regarding ECC 6.0

Former Member — Mon, 02 Jul 2007 14:03:21 GMT

I can suggest you to create one or two views. This would enhace the performance.

This is what I did also.

Thanks

Kiran

Re: Regarding ECC 6.0

Former Member — Mon, 02 Jul 2007 14:12:52 GMT

hi kiran, could u incorporate this code in forall entries.

Re: Regarding ECC 6.0

Former Member — Mon, 02 Jul 2007 14:45:43 GMT

Hi Venu,

Let us have different internal tables,

1) T_PURC (with fields BUKRS, EBELN, AEDAT, LIFNR, ERNAM, EBELP, BELNR, BEDNR, BANFN in the same order).

2) T_RSEG (with fields EBELN, EBELP, BUKRS, BELNR, WRBTR, GJAHR, SHKZG, LFBNR, LFGJA).

3) T_RBKP (with fields BELNR, GJAHR, BLDAT, BUDAT, KURSF)

3) T_ZPO_DIRINDIR (with fields KNTTP, DIR_INDIR)

SELECT a_{bukrs a}ebeln b_{ebelp a}aedat a_{lifnr a}ernam

b_{knttp b}bednr b~banfn

INTO TABLE T_PURC

FROM ekko AS a

JOIN ekpo AS b ON b_{ebeln = a}ebeln

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.

IF NOT T_PURC IS INITIAL.

SELECT ebeln ebelp bukrs belnr wrbtr gjahr shkzg lfbnr lfgja

INTO TABLE T_RSEG

FROM RSEG

FOR ALL ENTRIES OF T_PURC

WHERE ebeln in T_PURC-ebeln

AND ebelp in T_PURC-ebelp

AND bukrs in T_PURC-bukrs.

IF NOT T_RSEG IS INITIAL.

SELECT belnr gjahr bldat budat kursf

INTO TABLE T_RBKP

FROM RBKP

FOR ALL ENTRIES OF T_RSEG

WHERE belnr in T_RSEG-belnr

AND gjahr in T_RSEG-gjahr.

ENDIF.

SELECT knttp dir_indir

INTO TABLE T_ZPO_DIRINDIR

FROM ZPO_DIRINDIR

FOR ALL ENTRIES OF T_PURC

WHERE knttp in T_PURC-knttp.

ENDIF.

Now if you require you can move all the fields of all these tables by reading them into a single internal table or else you can use them seperately.

Saying thanks in SDN is by awarding points.

Kiran

Re: Regarding ECC 6.0

Former Member — Mon, 02 Jul 2007 14:50:33 GMT

Hi Venu,

there is a small correction needed to be made,

I have wrongly typed FOR ALL ENTRIES OF,

Plz change that to FOR ALL ENTRIES IN

Plz do not forget to reward with points.

Kiran

Re: Regarding ECC 6.0

Former Member — Mon, 02 Jul 2007 14:53:39 GMT

hi kiran,

i will try to use this logic in my code and will let u know for any clarifications required

regards

venu

Re: Regarding ECC 6.0

Former Member — Tue, 03 Jul 2007 13:29:06 GMT

hi kiran, could u give me ur personal mail id , so that i can approach u clearly about my issue