Skip to Content
0

SELECT statement Time out error after EHP7

Mar 29, 2017 at 05:54 AM

29

avatar image
Former Member

Dear experts,

The below querry has been run normally before implementation of EHP7 but now it was giving timeout error.

SELECT QMEL~QMNUM QMEL~QMART QMEL~QMTXT QMEL~QMDAT QMEL~MATNR QMEL~SERIALNR QMEL~ERNAM QMEL~BSTNK QMEL~SPART QMEL~PRIOK QMEL~QMCOD QMEL~ZZPRIMARY QMEL~ZZSECONDARY QMEL~ZZPATIENT QMEL~ZZINJURY QMEL~ZZDEATH VBAK~VBELN VBAK~AUART VBFA~POSNV MSEG~MBLNR MSEG~MJAHR MSEG~ZEILE MSEG~MATNR MSEG~MENGE MSEG~MEINS MSEG~DMBTR MSEG~WAERS MKPF~BUDAT INTO TABLE IT_EXCHANGE FROM MSEG

INNER JOIN MKPF ON ( MKPF~MBLNR = MSEG~MBLNR AND MKPF~MJAHR = MSEG~MJAHR )

INNER JOIN VBFA ON ( VBFA~VBELN = MSEG~MBLNR AND VBFA~MJAHR = MSEG~MJAHR AND VBFA~POSNN = MSEG~LINE_ID )

INNER JOIN VBAK ON VBAK~VBELN = VBFA~VBELV

INNER JOIN QMEL ON QMEL~VBELN = VBAK~VBELN

WHERE MKPF~BUDAT IN S_IDAT2

AND MSEG~BWART = 'ZB1' AND VBFA~BWART = 'ZB1'

AND VBFA~VBTYP_V = 'C' "SD ORDER

AND NOT EXISTS ( SELECT * FROM MSEG AS D WHERE

D~SMBLN = MSEG~MBLNR

AND D~SJAHR = MSEG~MJAHR

AND D~SMBLP = MSEG~ZEILE

AND D~BWART = 'ZB2' )

AND QMEL~MATNR IN S_MATNR

AND QMEL~QMNUM IN S_QMNUM

AND QMEL~QMART IN S_QMART

AND QMEL~QMTXT IN S_QMTXT

AND QMEL~QMDAT IN S_QMDAT

AND VBAK~VBELN IN S_VBELN

AND VBAK~AUART IN S_VAUART.

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers