EKBE TABLE FETCH

[Former Member]

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.

[Former Member]

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.

[Former Member]

hi

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

INTO TABLE EKBE_TAB

WHERE BUDAT IN <b>EKBE_BUDAT</b> AND

MATNR IN <b>EKBE_MATNR</b> AND

WERKS IN <b>EKBE_WERKS</b> AND

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

VGABE EQ '1' AND

MATNR NE SPACE ORDER BY MATNR.

praveen

[Former Member]

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.

[Former Member]

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

[Former Member]

Continuing my above post...

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

reward if useful!