topic Re: EKBE TABLE FETCH in Application Development and Automation Discussions

EKBE TABLE FETCH

Former Member — Fri, 20 Apr 2007 09:48:35 GMT

Dear All,

Please look my query.

SELECT WERKS MATNR MENGE EBELN EBELP BWART BUDAT LFGJA LFBNR XBLNR GJAHR BELNR FROM EKBE

INTO TABLE EKBE_TAB

WHERE BUDAT IN BUDAT AND

MATNR IN MATNR AND

WERKS IN WERKS AND

BWART IN ('101', '105') AND

VGABE EQ '1' AND

MATNR NE SPACE ORDER BY MATNR.

Here I am using Single table only. Moreover I have created Index for BUDAT+MATNR. If i give 1000 materials for a period of one year it is

taking so much time and time out occurs.

Is there any other way to fetch the above details quicky.

Re: EKBE TABLE FETCH

Former Member — Fri, 20 Apr 2007 09:52:43 GMT

SELECT WERKS MATNR MENGE EBELN EBELP BWART BUDAT LFGJA LFBNR XBLNR GJAHR BELNR FROM EKBE

INTO TABLE EKBE_TAB

WHERE BUDAT IN EKBE_BUDAT AND

MATNR IN EKBE_MATNR AND

WERKS IN EKBE_WERKS AND

BWART IN ('101', '105') AND

VGABE EQ '1' AND

MATNR NE SPACE ORDER BY MATNR.

praveen

Re: EKBE TABLE FETCH

Former Member — Fri, 20 Apr 2007 09:53:17 GMT

Hi Srini,

1.Try to give as much as possible conditions for Primary keys.

Its fast way to search your record.

2. Check your Table buffering and space get help from admin person.

3.You can fetch the records and do collective operation on internal table for

matnr <> space.

Re: EKBE TABLE FETCH

Former Member — Fri, 20 Apr 2007 09:54:50 GMT

Remove ORDER by clase.

later you can sort the internal table by matnr.

Remove this condition also ->MATNR NE SPACE

matnr-sign = 'I'.
matnr-option = 'NE'.
matnr-low = space.
append matnr.
clear matnr.

SELECT WERKS MATNR MENGE EBELN EBELP BWART BUDAT LFGJA LFBNR XBLNR GJAHR BELNR FROM EKBE
INTO TABLE EKBE_TAB
WHERE BUDAT IN BUDAT AND
MATNR IN MATNR AND
WERKS IN WERKS AND
BWART IN ('101', '105') AND
VGABE EQ '1' .

sort ekbe_tab by matnr.

Regards,

Ravi

Re: EKBE TABLE FETCH

Former Member — Fri, 20 Apr 2007 09:55:26 GMT

Continuing my above post...

Dont hardcode the values you can set it globally in selection extention or in include.

reward if useful!