Skip to Content
0
Former Member
Aug 30, 2008 at 04:44 AM

Performance on Select's LIKP, LIPS, VBUK, VBUP..ect..

351 Views

Hello Abap guru's...

I have a performance issue on this select, Please give me good input's!

SELECT VBELN LFART VKORG LFDAT INCO2 ROUTE FAKSK KUNNR KUNAG

WAERK BLDAT VSART ZZINS_FACE ZZDELY_VAL ZZLSCH FROM LIKP

INTO TABLE ISO_LIKP

WHERE VBELN IN S_VBELN AND

VKORG IN S_VKORG AND

LFART IN S_LFART AND "('ZLF','ZNL','ZRT') AND

VSART IN S_VSART AND

ROUTE IN S_ROUTE AND

KUNNR IN S_KUNNR AND

KUNAG IN S_KUNAG.

SELECT VBELN POSNR ERNAM ERZET ERDAT MATNR MATKL WERKS LGORT CHARG

LFIMG VBELV POSNV VRKME ARKTX VGBEL VGPOS VTWEG SPART SOBKZ FROM LIPS

INTO TABLE IST_LIPS

FOR ALL ENTRIES IN ISO_VBUP

WHERE VBELN = ISO_VBUP-VBELN AND

POSNR = ISO_VBUP-POSNR AND

ERNAM IN S_ERNAM AND

ERDAT IN S_ERDAT AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

CHARG IN S_CHARG AND

VGBEL IN S_VGBEL AND

VGPOS IN S_VGPOS AND

VTWEG IN S_VTWEG AND

SPART IN S_SPART.

SELECT VBELN LFSTK FKSTK FROM VBUK

INTO TABLE ISO_VBUK

FOR ALL ENTRIES IN ISO_LIKP

WHERE VBELN = ISO_LIKP-VBELN AND " FKSTK IN S_FKSTK

WBSTK <> 'C'.

SELECT VBELN POSNR LFSTA WBSTA FKSTA KOSTA FROM VBUP

INTO TABLE ISO_VBUP

FOR ALL ENTRIES IN ISO_VBUK

WHERE VBELN = ISO_VBUK-VBELN AND " POSNR = IST_LIPS-POSNR AND

LFSTA IN S_LFSTA AND FKSTA IN S_FKSTA AND

WBSTA <> 'C'.

SELECT OBJEK ATINN ATWRT ATFLV FROM AUSP

INTO TABLE IST_AUSP

FOR ALL ENTRIES IN ISO_MCH1

WHERE OBJEK = ISO_MCH1-CUOBJ_BM AND

ATINN IN (L_A_NET_WT,L_A_PACK_WT,L_A_PRODUCT_FORM,L_A_SR_GRADE,L_A_THICK_MM,

L_A_WIDTH_MM,L_A_LENGTH_MM,L_A_COATING_GSM,L_A_LOCATION).

<removed_by_moderator>

Regards,

Raju

Edited by: Julius Bussche on Sep 1, 2008 5:50 PM