You notice poor performance of transaction CK40N on SQL Server. After analyzing through DBA Cockpit's SQL Statement (DBACockpit transaction > Performance > SQL Statements) you find the most impactful statement /* R3:SAPRCK60:526 T:MACKW */.
The ABAP code for this statement is present in the report SAPRCK60:
select * from mackw
into table t_mackw
for all entries in ck_matnr
where matnr eq ck_matnr-low
and disst in ck_disst
and mtart in ck_mtart
and werks in ck_werks
and cuobj in ck_cuobj.
The query on SQL Server is similar to the following:
SELECT <Column, Column..>
FROM "MACKW" T_00,
(SELECT "C_01"= <VAR1>
UNION ALL SELECT <VAR2>
UNION ALL SELECT <VAR3> ...) as T_01
WHERE T_00.<FIELD1> = <VAR> AND T_00.<FIELD2> = T_01.C_01 AND ...
- SAP systems based on SAP NetWeaver with ABAP/Dual Stack;
- MS SQL Server 2008 and higher;
- SAP_APPL 600 and higher;
mackw, cuobj, werks, mtart, matnr, performance, sqlserver, sqlsrv, sqlservr, mssql, ms sql, ms_sql, msql, dbacockpit, saprck60, dba cockpit, SAP_APPL, CK40N, FAE, FOR ALL ENTRIES, prefer join, view, MARA, MARC, statement, tune, tuning , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , CO-PC-PCP , Product Cost Planning , CO-PC-PCP-WQS , Product Costing with Quantity Structure , SV-PERF , Performance Messages , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.