Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance issue

hi all Performance issue

SELECT VBRP~VBELN

VBRP~POSNR

VBRP~AUBEL

VBRP~AUPOS

VBRP~FKIMG " VBRP

VBRK~FKDAT " VBRK

INTO TABLE T_VBRK

FROM VBRP

INNER JOIN VBRK ON VBRKVBELN = VBRPVBELN

WHERE VBRK~VBELN IN S_VBELN AND -


> this is always BLANK

VBRK~FKART NOT IN R_FKART AND

VBRK~FKDAT IN S_FKDAT AND

VBRK~SPART IN S_SPART AND

VBRP~AUBEL IN S_KDAUF. -


> this is always BLANK

Due to the ABAOVE the below statement is taking many hours to execute

SELECT BUKRS

BELNR

GJAHR

AWKEY

INTO TABLE T_SVBKPF

FROM BKPF

FOR ALL ENTRIES IN T_VBRK

WHERE BUKRS IN S_BUKRS AND

BUDAT = T_VBRK-FKDAT AND

AWKEY = T_VBRK-AWKEY.

-


1) Is S_VBELN needed as we can vet vbeln based on VBRK~FKDAT.

Regards

babu

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question