Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Background job hanged due to secondary log issues. What could be the issue??

Former Member
0 Kudos

Hi Team,

Below is the mail chain i recieved.

I am unable to find out why this has happened.

_____________________

Please don’t take any action immediately. We will check it with our developer and come back to you soon.

Please let us know if we can cancel this job?

As job idle and doing nothing….no reads/writes etc.

Seems job was hanged due to secondary log issues occurred on 31st Aug midnight so production was also hanged.

Please let us know.

We checked and found that job is in running status as per schedule. Below mention SQL statements are still active on production database. For more detail kindly contact Function Team.

Kindly check with Function team and let us know in case you need any help from Basis side.

Just for your information job that occupied the complete db2 secondary logs on Sunday and Production was hanged for some time.

SQL statement:

SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR"

, T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01.

"EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00

INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND

T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND

T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01.

"MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS"

, T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01.

"BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON

T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR"

WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT"

>= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR"

, T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01.

"MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS"

FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR"

= T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01.

"BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01.

"MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00.

"BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE"

, T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01.

"EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN

"MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR"

= T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ?

AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR"

, T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01.

"MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ"

, T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND

T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT"

= ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL

SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR"

, T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01.

"EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00

INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND

T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND

T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01.

"MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS"

, T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01.

"BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON

T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR"

WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT"

>= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR"

, T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01.

"MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS"

FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR"

= T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01.

"BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01.

"MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00.

"BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE"

, T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01.

"EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN

"MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR"

= T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ?

AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR"

, T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01.

"MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ"

, T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND

T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT"

= ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL

SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR"

, T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01.

"EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00

INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND

T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND

T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01.

"MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS"

, T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01.

"BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON

T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR"

WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT"

>= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR"

, T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01.

"MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS"

FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR"

= T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01.

"BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01.

"MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00.

"BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE"

, T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01.

"EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN

"MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR"

= T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ?

AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR"

, T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01.

"MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ"

, T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND

T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT"

= ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL

SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR"

, T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01.

"EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00

INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND

T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND

T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01.

"MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS"

, T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01.

"BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON

T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR"

WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT"

>= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR"

, T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01.

"MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS"

FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR"

= T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01.

"BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01.

"MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00.

"BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE"

, T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01.

"EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN

"MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR"

= T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ?

AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR"

, T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01.

"MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ"

, T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND

T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT"

= ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL

SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR"

, T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01.

"EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00

INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND

T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND

T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01.

"MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS"

, T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01.

"BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON

T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR"

WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT"

>= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR"

, T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01.

"MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS"

FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR"

= T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01.

"BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01.

"MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00.

"BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE"

, T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01.

"EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN

"MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR"

= T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ?

AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR"

, T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01.

"MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ"

, T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND

T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT"

= ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL

SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR"

, T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01.

"EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00

INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND

T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND

T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01.

"MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS"

, T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01.

"BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON

T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR"

WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT"

>= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR"

, T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01.

"MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS"

FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR"

= T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01.

"BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01.

"MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ? UNION ALL SELECT T_00.

"BUDAT", T_01."MBLNR", T_01."MATNR", T_01."LIFNR", T_01."MJAHR", T_01."ZEILE"

, T_01."WERKS", T_01."SHKZG", T_01."MENGE", T_01."MEINS", T_01."EBELN", T_01.

"EBELP", T_01."BWART", T_01."SOBKZ", T_01."WAERS" FROM "MKPF" T_00 INNER JOIN

"MSEG" T_01 ON T_01."MANDT" = ? AND T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR"

= T_01."MJAHR" WHERE T_00."MANDT" = ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ?

AND T_00."BUDAT" >= ? UNION ALL SELECT T_00."BUDAT", T_01."MBLNR", T_01."MATNR"

, T_01."LIFNR", T_01."MJAHR", T_01."ZEILE", T_01."WERKS", T_01."SHKZG", T_01.

"MENGE", T_01."MEINS", T_01."EBELN", T_01."EBELP", T_01."BWART", T_01."SOBKZ"

, T_01."WAERS" FROM "MKPF" T_00 INNER JOIN "MSEG" T_01 ON T_01."MANDT" = ? AND

T_00."MBLNR" = T_01."MBLNR" AND T_00."MJAHR" = T_01."MJAHR" WHERE T_00."MANDT"

= ? AND T_01."BWART" IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

? ) AND T_01."MATNR" = ? AND T_01."LIFNR" = ? AND T_00."BUDAT" >= ?  WITH UR --

OPTLEVEL( 5 ) -- QUERY_DEGREE( 1 ) -- LOCATION( ZMMPRO_RECIEPT_QTY_SUM , 450

) -- SYSTEM( P10 , SAPP10 )

1 ACCEPTED SOLUTION

Former Member
0 Kudos

This issue has been resolved.

Created secondary index on MSEG table and used cursor
statement with Select query while fetching records from MSEG table.

1 REPLY 1

Former Member
0 Kudos

This issue has been resolved.

Created secondary index on MSEG table and used cursor
statement with Select query while fetching records from MSEG table.