Skip to Content
avatar image
Former Member

SELECT statement Time out error after EHP7

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers